Accessing JSON array data in PHP

Question

I am trying to get some data from an external API. From the JSON data I want to retrieve some data as marked in the image.

I can access the "teams" data by using this code -

foreach( $data->data as $info ) {
            echo '<li class="team-1">'. $info->teams[0].'</li>';
            echo '<li class="team-2">'. $info->teams[1].'</li>';
 };

But when I try to access data more deep from array of objects it doesn't work & gives me error -

foreach( $info->sites as $site) {
        foreach( $site->odds as $odd) {
            echo $odd->h2h[0];
        }
}

So my question is what is the best way to loop through the data to access these arrays. I am using this code in Wordpress but I think it will be same as PHP.

Based on the structure you have you should be able to use $site->odds->h2h[0] and $site->odds->h2h[1] — Nick
– Nick, Commented Oct 4, 2018 at 0:23

Roberto Maldonado · Accepted Answer · 2018-10-04 00:27:23Z

1

You should access h2h directly from odds, since it's not an array, but an object

foreach( $info->sites as $site) {
        echo $site->odds->h2h[0];
}

answered Oct 4, 2018 at 0:27

Roberto Maldonado

1,59614 silver badges27 bronze badges

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

Comments

Los · Accepted Answer · 2018-10-04 00:35:38Z

0

It looks like odds is an object rather than an array.

If h2h will always be the only property in odds then you can try:

foreach( $info->sites as $site) {
    echo $site->odds->h2h[0];
}

Alternatively, if h2h will not always be the only property in odds, then you may want to try casting it into an array:

foreach( $info->sites as $site) {
    foreach( (array)$site->odds as $odd) {
        echo $odd[0];
    }
}

edited Oct 4, 2018 at 0:35

answered Oct 4, 2018 at 0:21

Los

13 bronze badges

Comments

HU is Sebastian · Accepted Answer · 2018-10-04 08:41:10Z

0

You get this json from an external api and convert it using json_decode, right? If that is so, just use the second parameter "$assoc" and set it to true to not get an object, but an associative array that you can use like this:

$info = json_decode($api_answer,true);
if(isset($info['sites']['odds'])){
     foreach($info['sites']['odds'] as $odd){
        echo $odd['h2h'][0]
     }
}

answered Oct 4, 2018 at 8:41

HU is Sebastian

1011 bronze badge

Collectives™ on Stack Overflow

Accessing JSON array data in PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related