How to count the number of articles using Codeigniter as an example?

Question

MySQL

Unable to count the number of articles in CI. I write in the model

public function get_count_comments($id)
        {       
                $query = $this->db->get_where('comments');
                echo $query->num_rows();
        }

In the controller

$data['count_comments'] = $this->comment_model->get_count_comments($id);

I get the output Where is my mistake? Thank you. "count_comments":null

Answer 1

If you need to assign the result to a variable, as you do here:
then the get_count_comments($id) method should return a result.
So instead of echo writereturn $query->num_rows();