MySQLi example

gistfile1.php

<?php
function processURL($originalURL, $array) {
  $base = "http://example.com";
	$avail = "";

	$link = new mysqli($host, $user, $pass, $daba);
	if(mysqli_connect_errno()) {
		die("Connection failed" . mysqli_connect_error());
	}

	for($i = 0; $i < count($array); $i++) {
		$avail = $base . $array[$i];
		$query = "SELECT originalURL FROM url WHERE shortURL = {$avail}";
		if(($link->query($query)) == 0) {
			break; //If empty, use it
		}
	}

	if($avail != "") {
		$link->query("INSERT INTO url VALUES(, {$originalURL}, {$avail})");
		if($link->errno() <> 0) {
			$link->close();
			return $avail;
		}
	}

	return false;
}
?>