CodeIgniter's row() is leading to error: Trying to get property of non-object

Question

I have a CodeIgniter script which returns rows from different tables.

Unfortunately, it gives me the error: Trying to get property of non-object.

This is my code. Where is a problem?

$this->db->select('*');
$this->db->from('orders');
$this->db->where('order_id',$order_id);
$array_keys_values = $this->db->get();
$row = $array_keys_values->row();

$this->db->select('*');
$this->db->from('pacients');
$this->db->where('pacient_account_id',$row->order_pacient_id);
$array_keys_values2 = $this->db->get();
$row2 = $array_keys_values2->row();

$this->db->select('*');
$this->db->from('doctors');
$this->db->where('doctor_account_id',$doctor_id);
$array_keys_values3 = $this->db->get();
$row3 = $array_keys_values3->row();

Do you have db_debug enabled in your database configuration? Seems like the $this->db->get() returns false and that might mean the generated query is invalid (no such table/column) or such. — complex857
– complex857, Commented Oct 28, 2012 at 15:42
The reason you're getting that error is because the result is returned as a two-dimensional array and not an object. See my answer below. — stealthyninja
– stealthyninja, Commented Oct 28, 2012 at 23:06

stealthyninja · Accepted Answer · 2012-10-28 16:55:56Z

Try

$this->db->select('*');
$this->db->from('orders');
$this->db->where('order_id',$order_id);
$array_keys_values = $this->db->get();    
if ($array_keys_values->num_rows() > 0) {
    foreach ($array_keys_values->result() as $row) {
       // now you can work with $row
    }
}

$this->db->select('*');
$this->db->from('pacients');
$this->db->where('pacient_account_id',$row->order_pacient_id);
$array_keys_values2 = $this->db->get();
if ($array_keys_values2->num_rows() > 0) {
    foreach ($array_keys_values2->result() as $row2) {
        // now you can work with $row2
    }
}

$this->db->select('*');
$this->db->from('doctors');
$this->db->where('doctor_account_id',$doctor_id);
$array_keys_values3 = $this->db->get();
if ($array_keys_values3->num_rows() > 0) {
    foreach ($array_keys_values3->result() as $row3) {
        // now you can work with $row3
    }
}

broswilli · Accepted Answer · 2012-10-29 14:31:37Z

0

No row was returned. Use an if statement with a num_rows() > 0 to check

answered Oct 29, 2012 at 14:31

broswilli

3172 silver badges5 bronze badges

Comments

mickmackusa · Accepted Answer · 2025-09-10 12:37:11Z

row() returns null when there are no rows in the result set. This is likely what is breaking your script.

If all three queries actually related, then perhaps us a LEFT JOIN to make just one trip to the database. Use aliases in the select if multiple tables use the exact same column name.

return $this->db
    ->select('
        o.order_id,
        o.name order_name,
        p.pacient_account_id,
        p.name pacient_name,
        d.doctor_account_id,
        d.name doctor_name
    ')
    ->from('orders o')
    ->join('pacients p', 'p.pacient_account_id = o.order_pacient_id', 'left')
    ->join('doctors d', 'd.doctor_account_id = o.order_doctor_id', 'left')
    ->where('o.order_id', $order_id)
    ->get()
    ->row();

This will return a flat object with 6 properties or null.

Collectives™ on Stack Overflow

CodeIgniter's row() is leading to error: Trying to get property of non-object

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related