From 08a01f87f156fb0a89c032a806645291e6fd55dd Mon Sep 17 00:00:00 2001 From: Marien Fressinaud Date: Sun, 28 Oct 2012 01:17:15 +0200 Subject: Ajout informations dans la sidebar --- app/models/Entry.php | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'app/models') diff --git a/app/models/Entry.php b/app/models/Entry.php index 6fcc821f4..654286bd7 100755 --- a/app/models/Entry.php +++ b/app/models/Entry.php @@ -273,6 +273,15 @@ class EntryDAO extends Model_pdo { return $res[0]['count']; } + + public function countFavorites () { + $sql = 'SELECT COUNT(*) AS count FROM entry WHERE is_favorite=1'; + $stm = $this->bd->prepare ($sql); + $stm->execute (); + $res = $stm->fetchAll (PDO::FETCH_ASSOC); + + return $res[0]['count']; + } } class HelperEntry { -- cgit v1.2.3