hdalab/tagsearch.php
changeset 112 e7086d345a7c
parent 109 3371a40449c7
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/hdalab/tagsearch.php	Tue Jan 17 00:19:27 2012 +0100
@@ -0,0 +1,16 @@
+<?php
+include('connect.inc.php');
+
+$q = (isset($_GET['term']) ? pg_escape_string($_GET['term']) : false);
+
+$sql = "SELECT label, COUNT(*) nb FROM hdabo_tag A, hdabo_taggedsheet B WHERE A.id=B.tag_id ".($q?"AND label ILIKE '%$q%' ":"")."GROUP BY label ORDER BY nb DESC LIMIT 20";
+
+$rq = pg_query($sql);
+
+echo json_encode(pg_fetch_all($rq));
+
+pg_free_result($rq);
+
+pg_close();
+
+?>
\ No newline at end of file