php - How to access the fetched object property that is encapsulated within the SQL function count()?

Second option (that I do really prefer in my code) is to use alias onCOUNT()ed field:

SELECT COUNT(post_id) as tmp_value FROM posts
Copy code

Then you should access it as predefined alias states:$object->tmp_value.

In the end you should get something like this:

public function count(){
    global $db;
    $query = "SELECT COUNT(post_id) as tmp FROM posts";
    $result = $db->select($query);
    return $result[0]->tmp;
}
Copy code