Display multiple entries from JSON with PHP

Question

I need some help with my code, I am noob with JSON and PHP, but I`m learning

[
  {
 "eventId": 213,
"balls": [
  {
    "ball": 26,
    "id": 1
  },
  {
    "ball": 31,
    "id": 2
  }
]
  },
  {
"eventId": 212,
"balls": [
  {
    "ball": 22,
    "id": 1
      },
  {
    "ball": 33,
    "id": 2
  }
]
}
]

I have this JSON and this part of php code:

<table>
<?php
$url = 'external-link'; 

$data = file_get_contents($url);
$json_post = json_decode($data,true);
?>
    <table>
        <tbody>
        <?php foreach ($json_post as $event) : ?>
        <tr>
            <td><?php echo $event['eventId']; ?></td>
            <td><?php foreach ($json_post as $ball) : ?> <?php echo $ball['balls'][0]['ball']; ?> <?php endforeach; ?></td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>

I have a wrong display of this code, but not how I want to be:

 213 | 26 31 

 212 | 22 33

Any help would be appreciated,thanks

Loop though $event rather than $ball

Andrii H.
– Andrii H.

2018-12-07 19:08:08 +00:00
Commented Dec 7, 2018 at 19:08 — Andrii H.
– Andrii H., Commented Dec 7, 2018 at 19:08

Vectorial Graphics · Accepted Answer · 2018-12-07 20:05:17Z

2

You need to make your inner foreach loop over the current event...

<td><?php foreach ($event['balls'] as $ball) : ?> <?php echo $ball['ball']; ?> <?php endforeach; ?></td>

In case not all elements have this data, you can use the following...

    <td><?php if(isset($event['balls'])):
        foreach ($event['balls'] as $ball) : 
               echo $ball['ball']; 
        endforeach; 
        endif;?></td>

Full code:

$url = "url";
$data = file_get_contents($url);
$json_post = json_decode($data,true);
?>
    <table>
        <tbody>
        <?php foreach ($json_post as $event) : ?>
        <tr>
            <td><?php echo $event['eventId']; ?></td>
            <td><?php if(isset($event['balls'])):
                foreach ($event['balls'] as $ball) : 
                       echo $ball['ball'].' '; 
                endforeach; 
                endif;?></td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>

edited Dec 7, 2018 at 20:05

Vectorial Graphics

658 bronze badges

answered Dec 7, 2018 at 19:11

Nigel Ren

57.2k11 gold badges49 silver badges59 bronze badges

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

4 Comments

Vectorial Graphics Over a year ago

Undefined index: balls and Invalid argument supplied for foreach(), not sure how what to fix

Vectorial Graphics Over a year ago

yes, I have extracted a part from the main JSON, it looks exactly...please have a look at my code: <table> <?php $url = 'url'; $data = file_get_contents($url); $json_post = json_decode($data,true); ?> <table><tr> <td><?php foreach ($event['balls'] as $ball) : ?> <?php echo $ball['ball']; ?> <?php endforeach; ?></td></tr> </table>

Nigel Ren Over a year ago

I've updated it to the full code I'm using. I think there were a few tags missing in your version (</td> etc)

Vectorial Graphics Over a year ago

Thank you Nigel for your time, you've been very helpful. Finally, it worked. Many thanks again!

Collectives™ on Stack Overflow

Display multiple entries from JSON with PHP

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related