1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 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, supplierABN, supplierName, 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['supplierABN'].'-'.$row['supplierName'], "value" => htmlspecialchars($row['supplierName']) , "info" => htmlspecialchars("Supplier - ". $row['count']." records") ); } $query = "SELECT agencyName, 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['agencyName'], "value" => htmlspecialchars($row['agencyName']) , "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>"; } ?> |