diff options
Diffstat (limited to 'includes/model/Category.php')
-rwxr-xr-x[-rw-r--r--] | includes/model/Category.php | 156 |
1 files changed, 78 insertions, 78 deletions
diff --git a/includes/model/Category.php b/includes/model/Category.php index e8cbe60..37ad4f8 100644..100755 --- a/includes/model/Category.php +++ b/includes/model/Category.php @@ -1,78 +1,78 @@ -<?php - -include_once 'Thread.php'; - -class Category -{ - public $id; - public $name; - public $description; - public $thread_count = 0; - public $post_count = 0; - - // If an invalid id was passed into the constructor, the database will not have - // returned a result, but the object will not be null. - // We need to keep track of whether or not this object has a value. - private $has_value = false; - - public function __construct($id) - { - $sql = "SELECT cat_name, cat_description, cat_thread_count, cat_post_count FROM categories WHERE cat_id = ?;"; - $result = Database::get()->query($sql, "i", $id); - - if (empty($result)) { - return; - } - - $this->id = $id; - $this->name = $result[0]['cat_name']; - $this->description = $result[0]['cat_description']; - $this->thread_count = $result[0]['cat_thread_count']; - $this->post_count = $result[0]['cat_post_count']; - - $this->has_value = true; - } - - // Returns true if this object was successfully fetched from the database - public function has_value() - { - return $this->has_value; - } - - public static function get_all_categories(): array - { - $sql = "SELECT cat_id FROM categories ORDER BY cat_id;"; - $result = Database::get()->query($sql); - - $categories = array(); - - foreach ($result as $row) { - $category = new Category($row['cat_id']); - array_push($categories, $category); - } - - return $categories; - } - - public function get_threads(): array - { - $sql = "SELECT thread_id FROM threads WHERE thread_category = ? ORDER BY thread_date_lastpost DESC"; - $result = Database::get()->query($sql, "i", $this->id); - $threads = array(); - - foreach ($result as $row) { - $thread = new Thread($row['thread_id']); - if ($thread->has_value()) - array_push($threads, $thread); - } - - return $threads; - } - - public function get_latest_thread(): Thread - { - $sql = "SELECT thread_id FROM threads WHERE thread_category = ? ORDER BY thread_date_lastpost DESC LIMIT 1"; - $result = Database::get()->query($sql, "i", $this->id); - return new Thread($result[0]['thread_id']); - } -} +<?php
+
+include_once 'Thread.php';
+
+class Category
+{
+ public $id;
+ public $name;
+ public $description;
+ public $thread_count = 0;
+ public $post_count = 0;
+
+ // If an invalid id was passed into the constructor, the database will not have
+ // returned a result, but the object will not be null.
+ // We need to keep track of whether or not this object has a value.
+ private $has_value = false;
+
+ public function __construct($id)
+ {
+ $sql = "SELECT cat_name, cat_description, cat_thread_count, cat_post_count FROM categories WHERE cat_id = ?;";
+ $result = Database::get()->query($sql, "i", $id);
+
+ if (empty($result)) {
+ return;
+ }
+
+ $this->id = $id;
+ $this->name = $result[0]['cat_name'];
+ $this->description = $result[0]['cat_description'];
+ $this->thread_count = $result[0]['cat_thread_count'];
+ $this->post_count = $result[0]['cat_post_count'];
+
+ $this->has_value = true;
+ }
+
+ // Returns true if this object was successfully fetched from the database
+ public function has_value()
+ {
+ return $this->has_value;
+ }
+
+ public static function get_all_categories(): array
+ {
+ $sql = "SELECT cat_id FROM categories ORDER BY cat_id;";
+ $result = Database::get()->query($sql);
+
+ $categories = array();
+
+ foreach ($result as $row) {
+ $category = new Category($row['cat_id']);
+ array_push($categories, $category);
+ }
+
+ return $categories;
+ }
+
+ public function get_threads(): array
+ {
+ $sql = "SELECT thread_id FROM threads WHERE thread_category = ? ORDER BY thread_date_lastpost DESC";
+ $result = Database::get()->query($sql, "i", $this->id);
+ $threads = array();
+
+ foreach ($result as $row) {
+ $thread = new Thread($row['thread_id']);
+ if ($thread->has_value())
+ array_push($threads, $thread);
+ }
+
+ return $threads;
+ }
+
+ public function get_latest_thread(): Thread
+ {
+ $sql = "SELECT thread_id FROM threads WHERE thread_category = ? ORDER BY thread_date_lastpost DESC LIMIT 1";
+ $result = Database::get()->query($sql, "i", $this->id);
+ return new Thread($result[0]['thread_id']);
+ }
+}
|