/** * Get All Posts * * @return mixed */ public function getAllPosts() { $this->db->query("SELECT posts.*, categories.name FROM posts \n\t\t\tINNER JOIN categories\n\t\t\tON posts.category_id = categories.id\n\t\t\tORDER BY create_date DESC"); // Assign the result set $results = $this->db->resultSet(); return $results; }
function userPostCount($user_id) { $db = new Database(); $db->query("SELECT * FROM topics \n\t\t\t\t\t WHERE user_id=:user_id"); $db->bind('user_id', $user_id); $db->resultSet(); $topic_count = $db->rowCount(); $db->query("SELECT * FROM replies\n\t\t\t\t WHERE user_id=:user_id"); $db->bind('user_id', $user_id); $db->resultSet(); $reply_count = $db->rowCount(); return $topic_count + $reply_count; }
function getCategories() { $db = new Database(); $db->query("SELECT * FROM categories"); // Assign Result Set $results = $db->resultSet(); return $results; }