Line | |
---|
1 | <?php |
---|
2 | class Tags { |
---|
3 | function load($data){ |
---|
4 | $db = new SQLiteDatabase('sql/imgorg.db'); |
---|
5 | // use $query for type-ahead |
---|
6 | $query = $data->query; |
---|
7 | |
---|
8 | $qryStr = 'SELECT * FROM Tags'; |
---|
9 | if ($query) { |
---|
10 | $qryStr .= ' where text like "'.$query.'%"'; |
---|
11 | } |
---|
12 | $q = $db->query($qryStr); |
---|
13 | return $q->fetchAll(); |
---|
14 | } |
---|
15 | |
---|
16 | function getTags($data) { |
---|
17 | $db = new SQLiteDatabase('sql/imgorg.db'); |
---|
18 | $image = $data->image; |
---|
19 | |
---|
20 | $q = $db->query('SELECT t.text as text, t.id as id FROM Tags t INNER JOIN Images_Tags it ON t.id = it.tag_id WHERE it.image_id = "'.$image.'"'); |
---|
21 | return $q->fetchAll(); |
---|
22 | } |
---|
23 | } |
---|
Note: See
TracBrowser
for help on using the repository browser.