CodeIgniter 2 Cookbook

Counting the number of returned results with count_all_results()

It's useful to count the number of results returned—often bugs can arise if a section of code which expects to have at least one row is passed zero rows. Without handling the eventuality of a zero result, an application may become unpredictably unstable and may give away hints to a malicious user about the architecture of the app. Ensuring correct handling of zero results is what we're going to focus on here.

How to do it...

1. Add or adapt the following code into your controller:

   $this->load->model('Some_model');
   $data['num_results'] = $this->Some_model->some_model_function();
   $this->load->view('some_view', $data);

2. Add or adapt the following code into your model:

   function some_model_function() ...