Ajout informations dans la sidebar

1 files changed, 9 insertions, 0 deletions

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 {