From 5bea1a4d310e468d6ea1b71de36bdb4a53b8c57a Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= <nicolas.loeuillet@gmail.com>
Date: Fri, 6 Dec 2013 13:02:15 +0100
Subject: [add] function to get tags by entry

---
 inc/poche/Database.class.php | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'inc/poche')

diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php
index c233eda1..86907e52 100644
--- a/inc/poche/Database.class.php
+++ b/inc/poche/Database.class.php
@@ -249,4 +249,15 @@ class Database {
     public function getLastId($column = '') {
         return $this->getHandle()->lastInsertId($column);
     }
+
+    public function retrieveTagsByEntry($entry_id) {
+        $sql        = 
+            "SELECT * FROM tags
+            LEFT JOIN tags_entries ON tags_entries.tag_id=tags.id
+            WHERE tags_entries.entry_id = ?";
+        $query      = $this->executeQuery($sql, array($entry_id));
+        $tags    = $query->fetchAll();
+
+        return $tags;
+    }
 }
-- 
cgit v1.2.3