summaryrefslogtreecommitdiffstats
path: root/web/lib
diff options
context:
space:
mode:
authorMarcel Korpel <marcel.lists@gmail.com>2012-12-23 22:23:45 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2013-01-19 12:17:55 +0100
commitb004333eadb9a4db57592bb501b28edced708943 (patch)
treeb4e54f9e6f5bd44f2f1089d9aa1f27d78e9d8c08 /web/lib
parentb8f07c4c45a27fddb7f2a9c1d88b57ec9d4f2267 (diff)
downloadaur-b004333eadb9a4db57592bb501b28edced708943.tar.gz
aur-b004333eadb9a4db57592bb501b28edced708943.tar.xz
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>
Diffstat (limited to 'web/lib')
-rw-r--r--web/lib/aurjson.class.php22
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);
+ }
}