retrieving data from DB oop

Question

I'm using the codeigniter framework, I'm retrieving data from the database in the form of an array but when i try to use the foreach function to display the data i get an error

 Message: Object of class stdClass could not be converted to string

this is the array

Array  
(
[0] => stdClass Object
    (
        [id] => 1
        [title] => title
        [data] => data
    )


)

*The foreach is

foreach($data as $r) echo $r

Where's the code (the foreach)?

NullUserException
– NullUserException

2010-09-15 14:30:02 +00:00
Commented Sep 15, 2010 at 14:30 — NullUserException
– NullUserException, Commented Sep 15, 2010 at 14:30

Mischa · Accepted Answer · 2010-09-15 14:36:00Z

2

If you try it like this it should work:

<?php foreach($data as $r): ?>
    <?php echo $r->id; ?><br>
    <?php echo $r->title; ?><br>
    <?php echo $r->data; ?><br>
<?php endforeach; ?>

answered Sep 15, 2010 at 14:36

Mischa

43.4k9 gold badges101 silver badges111 bronze badges

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

10 Comments

Jan. Over a year ago

Oh my gosh! What purpose does this code have? I guess most of the users prefer not to put every single command inside <?php ?>. It's considered as bad coding style.

Mischa Over a year ago

This assumes you are in the view where you usually do most of your iterating over database records.

Jan. Over a year ago

IMHO this assumes way too much: Not every piece of code is meant to be outputted in HTML. And even if so, then why would you seperate the first line from the first echo? IT's more work for the interpreter and it's not easy readable for humans. Just my 2cents

andrei Over a year ago

thats perfect ! except you should use the shorthand <?php foreach() : ?> i think it makes it look nicer . but thanks

Pekka Over a year ago

@Jan using PHP code in HTML like this is totally acceptable IMO and I can't see how this is less future-oriented than using a full-blown templating system (that replicates what PHP does anyway) - as long as you stick to variables and simple control structures. PHP operations and calculations inside HTML is what's evil. (I am a happy user of template engines in many projects by the way, but they're not always needed.)

|

Jan. · Accepted Answer · 2010-09-15 14:36:24Z

2

Look close! You are putting the outter Array into the foreach loop. Every "$r" is then one Object with the properties id, title, data.

Try

foreach ($data as $k => $r) {
    echo $r->id;
}

answered Sep 15, 2010 at 14:36

Jan.

2,00516 silver badges17 bronze badges

Comments

Sjoerd · Accepted Answer · 2010-09-15 14:34:52Z

0

The problem is in echo $r. $r is of type stdClass, which can not be printed like that. Try print_r($r).

answered Sep 15, 2010 at 14:34

Sjoerd

75.9k16 gold badges140 silver badges180 bronze badges

Collectives™ on Stack Overflow

retrieving data from DB oop

3 Answers 3

10 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

10 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related