--- a/search_autosuggest.php +++ b/search_autosuggest.php @@ -6,10 +6,10 @@ $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 0; $aResults = array(); $count = 0; -if ($len) { - $query = 'SELECT mode("supplierName"), MAX("supplierABN"), count(*) as count +if ($len > 2) { + $query = 'SELECT text_mode("supplierName"), MAX("supplierABN"), count(*) as count FROM contractnotice -WHERE "supplierName" ILIKE :supplierName +WHERE "supplierName" ILIKE :supplierName or "supplierABN"::text = :supplierABN GROUP BY "supplierName" ORDER BY count(*) DESC LIMIT 4; @@ -17,12 +17,14 @@ $query = $conn->prepare($query); $supplierName = $input . '%'; $query->bindParam(":supplierName", $supplierName); + $supplierABN = $input ; + $query->bindParam(":supplierABN", $supplierABN); $query->execute(); databaseError($conn->errorInfo()); foreach ($query->fetchAll() as $row) { $count++; $aResults[] = array( - "id" => "supplier-" . $row[1] . '-' . $row[0], + "id" => "supplier-" . $row[1] . '-' . htmlspecialchars($row[0]), "value" => htmlspecialchars($row[0]), "info" => htmlspecialchars("Supplier - " . $row['count'] . " records") );