Codeigniter get_where查询

Question

public function countTasks(){
    $q = $this->db->get_where('tasks', array('task_status' => 1));
    return $this->db->count_all_results();
}

This is the function I have in my model that counts all rows in my 'tasks' table where the column 'task_status' is equal to 1. It basically returns an integer that I use for my pagination. The query is not working as it doesn't return any data even though I know I have 4 rows that match that requirement in my table.

I was gonna use the returned value for my pagination. Please help. Thanks

Answer 1

Try

return $q->num_rows();

Or

$this->db->where('task_status', '1');
$query = $this->db->get('tasks');

return $query->num_rows();