--- a/search_autosuggest.php +++ b/search_autosuggest.php @@ -46,6 +46,21 @@ "info" => htmlspecialchars("Government Agency - " . $row['count'] . " records") ); } + $query = "SELECT \"CNID\", description, value FROM contractnotice +WHERE to_tsvector('english', description) @@ plainto_tsquery('english', :input)"; + $query = $conn->prepare($query); + $agencyName = $input . '%'; + $query->bindParam(":input", $input); + $query->execute(); + databaseError($conn->errorInfo()); + foreach ($query->fetchAll() as $row) { + $count++; + $aResults[] = array( + "id" => "cnid-" . $row[0], + "value" => htmlspecialchars($row['description']), + "info" => htmlspecialchars("Contract Notice - Value ".$row['value']) + ); + } } 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 @@ -69,3 +84,4 @@ echo ""; } ?> +