Loop through this array

Question

I make an API request with PHP and the $data variable that comes back looks like the following:

[{
    "Id": 1,
    "Name": "AFC"
}, {
    "Id": 3,
    "Name": "RFC"
}, {
    "Id": 4,
    "Name": "CFC"
}, {
    "Id": 5,
    "Name": "LFC"
}, {
    "Id": 7,
    "Name": "MUFC"
}]

I want to know, how do I use a foreach loop to display a list of the titles?

http://stackoverflow.com/questions/2342371/jquery-loop-on-json-data-using-each — Harsha W, Apr 16 '17 at 06:35
If you get a JSON string (fragment you gave us is not fully valid), use `json_decode`. It would create a stdClass objects structure or assoc array, that's determined by the second function parameter. — Mateusz Sip, Apr 16 '17 at 06:36

sammysaglam · Accepted Answer · 2017-04-16T06:51:18.307

2

After the API request, your $data variable contains a JSON string.

Use json_decode to convert the string into an array, and the foreach loop construct to iterate over array:

$json_object = json_decode($data) ;

echo '<table>' ;
foreach ( $json_object as $child ) {

    echo '<tr>' ;
    echo '<td>' . $child -> Id. '</td>' ;
    echo '<td>' . $child -> Name . '</td>' ;
    echo '</tr>' ;

}
echo '</table>' ;

edited Apr 16 '17 at 06:51

answered Apr 16 '17 at 06:37

sammysaglam

433
4
9

this worked beautifully. Many thanks for taking the time to put this together. I will keep this in mind for all future json decodes :) – michaelmcgurk Apr 16 '17 at 06:56
1

my pleasure :) i am glad it worked – sammysaglam Apr 16 '17 at 06:57

score 1 · Answer 2 · answered Apr 16 '17 at 06:55

1

<?php 
foreach($data as $row){
echo $row["Id"];
echo "<br>";
echo $row["Name"];
}

answered Apr 16 '17 at 06:55

Osama

2,912
1
12
15

Loop through this array

2 Answers2