Add Object to Array while looping

Question

One of my PDO statements returns an array. For JSON encoding I want to cast this array to an Object and append it to another array.

     while($row = $sth->fetch()){
            foreach($row as $key=>$value){ 
                    $r = (object) $row;
                    $recordArray[] = $r;
            }
    }

    $json->record = $recordArray;
    echo json_encode($json);

$recordArray seems to stay empty but it doesn't if I write $recordArray[] = "test" in the loop. So there must be something wrong with my Object $r but I can't spot the mistake. Any help is appreciated.

andrew · Accepted Answer · 2014-12-12 15:44:37Z

2

Here is an easier way

echo json_encode(array('record'=>$sth->fetchAll(PDO::FETCH_OBJ)));

answered Dec 12, 2014 at 15:44

andrew

9,6039 gold badges36 silver badges62 bronze badges

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

4 Comments

user1255102 Over a year ago

It doesn't work in my case. If I do a var_dump($sth->fetchAll(PDO::FETCH_OBJ));I get an array containing 194 objects (stdClass). But if I do the json_encode with the content of the var_dump I get a blank page.

andrew Over a year ago

I just tested this and it woks fine, are you outputting anything else to the page? try right click, view source, you should see the json string

user1255102 Over a year ago

Still can't spot the error. Guess there must be something wrong with my server. Thanks a lot for the shorter statement anyways.

andrew Over a year ago

try adding error_reporting(E_ALL); ini_set("display_errors", 1); at the top of your php script and see if you're getting any errors

cybersoft · Accepted Answer · 2014-12-12 15:42:22Z

0

Your foreach is wrong: in body you use object on which you iterate. May be you mean this?

$records = [];
while($row = $sth->fetch()) {
    $current = [];
    foreach($row as $key => $value) {
        $current[$key] = $value;
    }
    $records[] = $current;
}

answered Dec 12, 2014 at 15:42

cybersoft

1,50314 silver badges31 bronze badges

Comments

Funk Forty Niner · Accepted Answer · 2014-12-12 15:45:21Z

0

If I understood, you want to loop over $row and add every object within $row to $recordArray.

Then you should do this:

while($row = $sth->fetch()){
    foreach($row as $value){ 
        $recordArray[] = $value;
    }
}

edited Dec 12, 2014 at 15:45

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Dec 12, 2014 at 15:43

Gabriel

849 bronze badges

Collectives™ on Stack Overflow

Add Object to Array while looping

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related