<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
// DB info
$dbhost = '10.100.7.5';
$dbuser = 'badams';
$dbpass = 'pizza';
$dbname = 'badams';
$rows = array();
	$rows["data"]="";

if(isset($_REQUEST['query'])) {
	$q = $_REQUEST['query'];
	if(strlen($q) > 0) {
		$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
		if(!$conn) {
			$rows["success"] = false;
			$rows["error"] = "Unable to connect to DB";
			echo json_encode($rows);
			exit;
		}

		if(!mysql_select_db($dbname)) {
			$rows["success"] = false;
			$rows["error"] ="Unable to select database.";
			echo json_encode($rows);
			exit;
		}

		$dbQuery = "SELECT * FROM quicklinks_answers WHERE question_text LIKE '%$q%' LIMIT 15";

		$result = mysql_query($dbQuery);

		if(!$result) {
			$rows["success"] = false;
			$rows["error"] = "Could not successfully run query ($dbQuery) from DB.";
			echo json_encode($rows);
			exit;
		}

		if(mysql_num_rows($result) == 0) {
			$rows["sucess"] = true;
			$rows['error'] = "Sorry, no results found";
			echo json_encode($rows);
			exit;
		}

		while($row = mysql_fetch_assoc($result)) {
			$rows["data"][] = $row;
			exit;
		}
		$rows['success'] = "true";
		$rows['error'] = "";
		echo json_encode($rows);
		exit;
	}
		$rows["success"] = true;
		$rows['error'] = "No search was passed";
	echo json_encode($rows);
} // don't do anything because there was so search sent

?>