Message: Trying to get property of non-object in Codeigniter

Question

I have this code in my Model page:

 public function getAll($researcherpk){
 $this->db->select('*');
 $this->db->from('research');
 $this->db->join('researcher', 'researcher = lastname');
 $this->db->where('researcherpk', $researcherpk); 
 return $this->db->get()->row_array();

But when I use it on my View Page

Age: <?php echo $data['age'];?>        // this work

<?php   foreach ($data as $v){ ?>          //this has an error

  <tr>
      <td><?php echo $v->title?></td>
      <td><?php echo $v->track_records?></td>
  </tr>
<?php } ?>

I get the error:

Message: Trying to get property of non-object

In my Controller page:

 public function researcher($researcherpk){

 $this->load->model('ResearchModel');

 $result['data'] = $this->ResearchModel->getAll($researcherpk);
 $this->load->view('researcher',$result);

 }

What do you think is the problem here? What is my alternative solution for it or changes?

Sorry, but how could i do this var_dump($data);?

Kino
– Kino

2014-03-12 14:26:59 +00:00
Commented Mar 12, 2014 at 14:26 — Kino
– Kino, Commented Mar 12, 2014 at 14:26
Never mind, I figured out was wrong! Check my answer :)

Albzi
– Albzi

2014-03-12 14:30:01 +00:00
Commented Mar 12, 2014 at 14:30 — Albzi
– Albzi, Commented Mar 12, 2014 at 14:30

Albzi · Accepted Answer · 2018-02-02 08:09:21Z

10

Change your return to:

return $this->db->get()->result_array();

Then try using $v['title'] and $v['track_records']

<?php foreach ($data as $v): ?>
  <tr>
    <td><?php echo $v['title']?></td>
    <td><?php echo $v['track_records']?></td>
  </tr>
<?php endforeach; ?>

Look at the codeigniter docs to learn more.

result_array():

This function returns the query result as a pure array

That is what you want.

You are mixing it with:

row_array():

This function returns a single result row. If your query has more than one row, it returns only the first row.

This is not what you want.

edited Feb 2, 2018 at 8:09

answered Mar 12, 2014 at 14:26

Albzi

15.6k6 gold badges49 silver badges67 bronze badges

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

2 Comments

gen_Eric Over a year ago

$data is not a multidimensional array.

Albzi Over a year ago

Thank you, I just looked more into it. I'll edit my answer @RocketHazmat

gen_Eric · Accepted Answer · 2014-03-12 14:32:21Z

2

You're calling row_array this means $data is an array of a single row. $data['age'] works, because age is a field in the row.

You can foreach($data as $v), but this will only loop over the fields in that particular row.

You can just do echo $data['title']. $data is not a multidimensional array.

If you want multiple rows, then use return $this->db->get()->result_array();. Then you can loop over the rows:

foreach ($data as $v){
    echo $v['age'];
    echo $v['title'];
}

answered Mar 12, 2014 at 14:32

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Comments

Daan · Accepted Answer · 2014-03-12 14:27:39Z

1

It is an array not an object so:

Change this:

  <td><?php echo $v->title?></td>
  <td><?php echo $v->track_records?></td>

To this:

  <td><?php echo $v['title']; ?></td>
  <td><?php echo $v['track_records']; ?></td>

answered Mar 12, 2014 at 14:27

Daan

12.3k6 gold badges36 silver badges51 bronze badges

Collectives™ on Stack Overflow

Message: Trying to get property of non-object in Codeigniter

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related