Implemented rudimental search engine

3 files changed, 18 insertions, 3 deletions

diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php
index 5b51b507..6aad16c1 100755
--- 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
diff --git a/inc/poche/Poche.class.php b/inc/poche/Poche.class.php
index b1143d0b..74a185bd 100755
--- a/inc/poche/Poche.class.php
+++ b/inc/poche/Poche.class.php
@@ -603,6 +603,14 @@ class Poche
                     'tags' => $tags,
                 );
                 break;
+                                
+                        case 'search':
+                                if (isset($_POST['search'])){
+                                        $search = $_POST['search'];
+                                        $tpl_vars['entries'] = $this->store->search($search);
+                                        $tpl_vars['nb_results'] = count($tpl_vars['entries']);
+                                }
+                                break;
             case 'view':
                 $entry = $this->store->retrieveOneById($id, $this->user->getId());
                 if ($entry != NULL) {
@@ -772,8 +780,7 @@ class Poche
         $this->emptyCache();
         
         Tools::redirect('?view=config');
-    }
-
+    }   
     /**
      * get credentials from differents sources
      * it redirects the user to the $referer link
diff --git a/inc/poche/global.inc.php b/inc/poche/global.inc.php
index d22b0588..15091387 100644
--- a/inc/poche/global.inc.php
+++ b/inc/poche/global.inc.php
@@ -38,7 +38,7 @@ if (! file_exists(ROOT . '/vendor/autoload.php')) {
     require_once ROOT . '/vendor/autoload.php';
 }
 
-# system configuration; database credentials et cetera
+# system configuration; database credentials et caetera
 if (! file_exists(INCLUDES . '/poche/config.inc.php')) {
     Poche::$configFileAvailable = false;
 } else {