Count result array to string conversion error in codeigniter

Question

I am using this method in my model to get a count result from my database:

function members($group_id)
{
    $this->db->where('group_id',$group_id);
    $query = $this->db->query('SELECT COUNT(group_id) FROM member');    
    return $query;
 }

And in my controller there is this method:

   function total_members ()
   {
       $group_id = $this->input->post('group_id');
       $this->load->model('Member_model');
       $members = $this->Member_model->members($group_id);
       echo $members;
   }

And am getting this weird error which says:

Severity: 4096 Message: Object of class CI_DB_mysqli_result could not be converted to string Filename: controllers/Payment.php

in controller add print_r($members) and check output first of all — Abdulla Nilam
– Abdulla Nilam, Commented Sep 15, 2016 at 14:39

DFriend · Accepted Answer · 2016-09-15 15:14:25Z

1

You need to return a result set which requires another call. In this case I suggest row(). Try these revised functions.

function members($group_id)
{
    $this->db->where('group_id', $group_id);
    $query = $this->db->query('SELECT COUNT(group_id) as count FROM member');
    return $query->row();
}

function total_members()
{
    $group_id = $this->input->post('group_id');
    $this->load->model('Member_model');
    $members = $this->Member_model->members($group_id);
    if(isset($members))
    {
        echo $members->count;
    }
}

Learn about the different kinds of result sets here

answered Sep 15, 2016 at 15:14

DFriend

8,9741 gold badge16 silver badges26 bronze badges

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

Comments

parth · Accepted Answer · 2016-09-15 15:15:26Z

1

Try this

Model

function members($group_id) {
    return $this->db->get_where('member', array('group_id' => $group_id))->num_rows();
}

Controller

function total_members() {
    $group_id = $this->input->post('group_id');
    $this->load->model('member_model');
    $members = $this->member_model->members($group_id);
    print_r($members);
}

In codeigniter there is num_rows() to count the rows. For more information check the documentation .

edited Sep 15, 2016 at 15:15

answered Sep 15, 2016 at 15:10

parth

1,9203 gold badges22 silver badges32 bronze badges

1 Comment

DFriend Over a year ago

That will work but the query will return all the rows first. By using the sql function COUNT in query only one row (in this case) will be returned. A lot less resource intensive and likely much faster.

Collectives™ on Stack Overflow

Count result array to string conversion error in codeigniter

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related