/** * Get the most popular blog posts in a blog from DB * @param num the number of blog posts to get * @return array with blog post objects */ private function getPopularBlogPostsDB($num) { $sql = 'SELECT * FROM `blog_post` WHERE '; $params = array(); if ($this->course_id != 0) {//course blog $sql .= '`course_id` = ?d ORDER BY `views` DESC LIMIT ?d'; $params[] = $this->course_id; } else {//user blog $sql .= '`course_id` = ?d AND `user_id` = ?d ORDER BY `views` DESC LIMIT ?d'; $params[] = 0; $params[] = $this->user_id; } $params[] = $num; $result = Database::get()->queryArray($sql, $params); $ret = array(); if (is_array($result)) { $ret = BlogPost::loadFromPDOArr($result); } return $ret; }