Implemented rudimental search engine

[github/wallabag/wallabag.git] / inc / poche / Database.class.php

diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php
index 5b51b507abb62348fb2f8cfc92e5d528e22a233a..6aad16c11e16d3e0ac6f71d1a110cf42ecdfee45 100755 (executable)
--- a/inc/poche/Database.class.php
+++ b/inc/poche/Database.class.php
@@ -388,6 +388,14 @@ class Database {
     public function getLastId($column = '') {
         return $this->getHandle()->lastInsertId($column);
     }
+       
+       public function search($term){
+               $search = '%'.$term.'%';
+               $query = $this->getHandle()->prepare("SELECT * FROM entries WHERE content LIKE ?");
+               $query->execute(array($search));
+               $entries = $query->fetchAll();
+               return $entries;
+       }
 
     public function retrieveAllTags($user_id, $term = null) {
         $sql = "SELECT DISTINCT tags.*, count(entries.id) AS entriescount FROM tags