how to print an array of objects in codeigniter- php?

Question

I am facing a problem to fetch array in codeigniter

$data['one']=$this->db->query($sql1);
$data['tho']=$this->db->query($sql2);
$data['three']=$this->db->query($sql3);

I am trying to do this following code I am getting error

Fatal error: Call to a member function result() on a non-object in

If I do var_dump($data['one']); I am getting the following displayed:

Array
(
 [0] => stdClass Object
 (
  [date] => 2013-09-28
 )
 [1] => stdClass Object
 (
  [date] => 1970-01-01
 )
 [2] => stdClass Object
 (
  [date] => 2013-09-28
 ) 
)

Vassilis Barzokas · Accepted Answer · 2013-03-31 21:42:08Z

2

You can do (in the controller) something like this foreach one of your arrays:

  foreach ($data['one']->result() as $row)
  {
        echo $row->date; //or whatever the query returns
  }

If you want to print it on the view you do it like this:

  foreach ($one->result() as $row)
  {
        echo $row->date; //or whatever the query returns
  }

See more in the official documentation about queries here

answered Mar 31, 2013 at 21:42

Vassilis Barzokas

3,2822 gold badges29 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

how to print an array of objects in codeigniter- php?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related