Implemented typeahead suggest

Use Twitter Bootstrap JavaScript framework for typeahead support.

Add a new "suggest" JSON method, which returns the first 20
packages that match the beginning characters of a query.

canyonknight: Link format change, commit message
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>

1 files changed, 21 insertions, 1 deletions

diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php
index 949c34f3..616b7838 100644
--- a/web/lib/aurjson.class.php
+++ b/web/lib/aurjson.class.php
@@ -15,7 +15,7 @@ include_once("aur.inc.php");
 class AurJSON {
     private $dbh = false;
     private static $exposed_methods = array(
-        'search', 'info', 'multiinfo', 'msearch'
+        'search', 'info', 'multiinfo', 'msearch', 'suggest'
     );
     private static $fields = array(
         'Packages.ID', 'Name', 'Version', 'CategoryID', 'Description', 'URL',
@@ -276,5 +276,25 @@ class AurJSON {
 
         return $this->process_query('msearch', $where_condition);
     }
+
+    /**
+     * Get all package names that start with $search.
+     * @param string $search Search string.
+     * @return string The JSON formatted response data.
+     **/
+    private function suggest($search) {
+        $query = 'SELECT Name FROM Packages WHERE Name LIKE ' .
+            $this->dbh->quote(addcslashes($search, '%_') . '%') .
+            ' ORDER BY Name ASC LIMIT 20';
+
+        $result = $this->dbh->query($query);
+        $result_array = array();
+
+        if ($result) {
+            $result_array = $result->fetchAll(PDO::FETCH_COLUMN, 0);
+        }
+
+        return json_encode($result_array);
+    }
 }