Sending and fetching results feature complete

[speedfreak] / Server / application / models / category.php

diff --git a/Server/application/models/category.php b/Server/application/models/category.php
index f47f0e4..a5c0c20 100644 (file)
--- a/Server/application/models/category.php
+++ b/Server/application/models/category.php
@@ -28,4 +28,32 @@ class Category_Model extends Model {
             return false;
     }
 
+    /*
+     * Check if category exists
+     *
+     * @param string $category Category name (slug)
+     * @return bool True if exists and False otherwise
+     */
+    public function category_exists($category){
+       $results = $this->db->query("SELECT id FROM categories where slug = ?", $category);
+    if ($results->count()>0)
+            return true;
+        else
+            return false;
+    }
+
+    /*
+     * Get category id
+     *
+     * @param string $category Category name (slug)
+     * @return integer|bool Category id if successful or false
+     */
+    public function get_id($category){
+       $results = $this->db->query("SELECT id FROM categories where slug = ?", $category);
+    if ($results->count()>0)
+            return $results[0]->id;
+        else
+            return false;
+    }
+
 }
\ No newline at end of file