--- a/search_autosuggest.php +++ b/search_autosuggest.php @@ -1,1 +1,62 @@ - +<?php +include_once ("./lib/common.inc.php"); +$input = strtolower($_GET['input']); +$len = strlen($input); +$limit = isset($_GET['limit']) ? (int)$_GET['limit'] : 0; +$aResults = array(); +$count = 0; +if ($len) { + $query = "SELECT supplierName as info, supplierABN as id, supplierName as value, count(*) as count +FROM `contractnotice` +WHERE supplierName LIKE '$input%' +GROUP BY supplierName +ORDER BY count DESC +LIMIT 4; +"; + $result = mysql_query($query); + while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { + $count++; + $aResults[] = array( + "id" => "supplier-".$row['id'], + "value" => htmlspecialchars($row['value']) , + "info" => htmlspecialchars("Supplier - ". $row['count']." records") + ); + } + $query = "SELECT agencyName as info, agencyName as id, agencyName as value, count(*) as count +FROM `contractnotice` +WHERE agencyName LIKE '$input%' +GROUP BY agencyName +ORDER BY count DESC +LIMIT 4;"; + $result = mysql_query($query); + while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { + $count++; + $aResults[] = array( + "id" => "agency-".$row['id'], + "value" => htmlspecialchars($row['value']) , + "info" => htmlspecialchars("Government Agency - ". $row['count']." records") + ); + } +} +header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past +header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified +header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 +header("Pragma: no-cache"); // HTTP/1.0 +if (isset($_REQUEST['json'])) { + header("Content-Type: application/json"); + echo "{\"results\": ["; + $arr = array(); + for ($i = 0;$i < count($aResults);$i++) { + $arr[] = "{\"id\": \"" . $aResults[$i]['id'] . "\", \"value\": \"" . $aResults[$i]['value'] . "\", \"info\": \"\"}"; + } + echo implode(", ", $arr); + echo "]}"; +} else { + header("Content-Type: text/xml"); + echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>"; + for ($i = 0;$i < count($aResults);$i++) { + echo "<rs id=\"" . $aResults[$i]['id'] . "\" info=\"" . $aResults[$i]['info'] . "\">" . $aResults[$i]['value'] . "</rs>"; + } + echo "</results>"; +} +?>