Codeigniter number of rows in controller

Question

I have a model where I select the proper data from database as below:

<?php
    class vacancies extends CI_Model{

        function vacancies()
        {
            $query = $this->db->query("SELECT * FROM ecc_vacancies_vac WHERE active_vac = 1 AND end_vac >= CURDATE() ORDER BY date_vac DESC");

            if($query->num_rows() >= 1){
                foreach($query->result() as $row){
                    $data[] = $row;
                }
                return $data;
            }
        }

    }

and a controller to handle this data before sending to view as below:

function index()
{
    //check if there any available vacancies

    $this->load->model('vacancies');
    $data['vacancies'] = $this->vacancies->vacancies();
    // then i load the views here 
 }

What I need to do, is to know the total number of returned rows here in the controller so I can send the number to the view to use it later.

When using active records I used to use this line of code:

$data['num_rows'] = $$data['vacancies']->num_rows();

How can I define it in my case?

I don't get it, you are retrieving that same number already in your code? ( if( $query->num_rows() >= 1){ ) — Esailija
– Esailija, Commented Jun 20, 2012 at 21:29
your question is how to count the size of an array? google 'php size of array' ;) — danp
– danp, Commented Jun 20, 2012 at 21:33
also, that line of code, do you understand what it was doing? — danp
– danp, Commented Jun 20, 2012 at 21:34

sankari · Accepted Answer · 2012-06-20 21:32:26Z

3

PHP to the rescue. Since your model method returns an array, you get the total number rows by a simple count() call.

So, for example,

$this->load->model('vacancies');
$data['vacancies'] = $this->vacancies->vacancies();
$data['number_of_vacancies'] = count($data['vacancies']);

answered Jun 20, 2012 at 21:32

sankari

4767 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Robert · Accepted Answer · 2012-06-20 21:33:55Z

2

The num-rows(); only works if you're still working on your "query part" in your model. It reffers to the DB object. You already returned the data. Try this:

 $data['num_rows'] = count($data['vacancies']);

answered Jun 20, 2012 at 21:33

Robert

1,9051 gold badge17 silver badges24 bronze badges

Comments

Nick Jennings · Accepted Answer · 2012-06-20 21:36:02Z

2

You are returning an array from the model, so in the controller you can use PHP's count() function:

$data['num_rows'] = count($data['vacancies']);

There's also a problem with your model, the function will not return an array if there are no results, which could cause problems if you treat it like an array later on. You should add an initialization for $data before the if statement, and then always return even an empty array:

function vacancies()
{
    $query = $this->db->query("SELECT * FROM ecc_vacancies_vac WHERE active_vac = 1 AND end_vac >= CURDATE() ORDER BY date_vac DESC");

    $data = array();
    if ($query->num_rows() >= 1){
        foreach ($query->result() as $row){
            $data[] = $row;
        }
    }
    return $data;
}

edited Jun 20, 2012 at 21:36

answered Jun 20, 2012 at 21:29

Nick Jennings

4,1016 gold badges33 silver badges49 bronze badges

Comments

Koen · Accepted Answer · 2016-01-12 19:30:59Z

1

To help you out:

if($query->num_rows()!==0){
   return $query->result_array();
}else{
   return 0;
}

Return 0 and make an if else statement in the view

if($result!=0){
   // No results found
}else{
   // Do something
}

answered Jan 12, 2016 at 19:30

Koen

1401 silver badge10 bronze badges

Collectives™ on Stack Overflow

Codeigniter number of rows in controller

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related