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.
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);
Add or adapt the following code into your model:
function some_model_function() { $this->db->from('table'); return $num_rows = $this->db->count_all_results(); }
Add or adapt the following code into your view:
if (isset($num_results)) { echo 'There are ' . $num_results . ' returned'; }
This...