loop through JSON string in php

Question

I have a json string derived from MySQL query using GROUP_CONCAT (which returns STRING).

Here's JSON string as field portfolios:

[
  {name:"Branch GBD_1.pdf", img_path:"1333752771.pdf"},
  {name:"Doc.pdf", img_path:"2020107119.pdf"},
  {name:"COK.pdf", img_path:"264860069.pdf"}
]

Now in php, I tried to decode the field and loop through it, but I am not being able to.

foreach($records as $r)
{
    $varArray = json_decode($r['portfolios'], true);
    foreach($varArray as $que)
    {
        echo $que['name'].' '.$que['img_path'];
        echo '<br/>';
    }           
}

How do I break or convert the variable into loop-able object?

Hasan Khan · Accepted Answer · 2018-05-09 11:46:53Z

3

$varArray is not an array because your json string is not valid json. The keys need to be wrapped in doublequotes.

[
  {"name":"Branch GBD_1.pdf", "img_path":"1333752771.pdf"},
  {"name":"Doc.pdf", "img_path":"2020107119.pdf"},
  {"name":"COK.pdf", "img_path":"264860069.pdf"}
]

edited May 9, 2018 at 11:46

Hasan Khan

7331 gold badge8 silver badges15 bronze badges

answered May 9, 2018 at 11:42

James

1,1239 silver badges13 bronze badges

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

1 Comment

Azima Over a year ago

Thanks a lot... that worked. some resources confused me with the quotes..

Collectives™ on Stack Overflow

loop through JSON string in php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related