diff options
Diffstat (limited to 'getjson.php')
-rw-r--r-- | getjson.php | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/getjson.php b/getjson.php index 432b324..63daf0b 100644 --- a/getjson.php +++ b/getjson.php @@ -67,9 +67,16 @@ if (isset($_REQUEST["S"])) else if (isset($_REQUEST["ID"]) && !isset($_REQUEST["C"])) { $id = intval($_REQUEST["ID"]); - $result = $DB->query("SELECT base_uri, filename, id FROM photos". + $result = $DB->query("SELECT base_uri, filename, id, description, time FROM photos". " WHERE id=$id"); } + else if (isset($_REQUEST["IDT"])) + { /* tags of a single image */ + $id = intval($_REQUEST["IDT"]); + $result = $DB->query("SELECT t.name as name FROM photo_tags pt ". + " LEFT JOIN tags t on t.id=pt.tag_id". + " WHERE pt.photo_id=$id"); + } else if (isset($_REQUEST["CLOUD"])) { $result = $DB->query("SELECT t.name as name, count(*) as count FROM photo_tags pt ". |