PHP Database::resultSet Examples

Example #1

File: Post.php Project: GojkoC/Simple_Blog

 /**
  * 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;
 }

Example #2

File: db_helper.php Project: newschooldrew/projects

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;
}

Example #3

File: db_helper.php Project: saptharsh/Technology-Forum

function getCategories()
{
    $db = new Database();
    $db->query("SELECT * FROM categories");
    // Assign Result Set
    $results = $db->resultSet();
    return $results;
}