Replacing text from json objects to php

Question

Here's the json I have that is pulling data from a 3rd party page.
http://freerdarts.com/api/tues_standings_api_2019.php

I am formatting the data into a table like this.

<table class="tbl_container" id="standings">
  <thead>
    <tr>
      <th>TEAM</th>
      <th>WIN %</th>
      <th>GAMES</th>
      <th>WON</th>
    </tr>
  </thead>
  <tbody>
    <?php
      foreach($standings as $row):
      ?>
    <tr>
      <td><?=$row['team'];?></td>
      <td><?=$row['win%'];?></td>
      <td><?=$row['games'];?></td>
      <td><?=$row['wins'];?></td>
    </tr>
    <?php endforeach;?>
  </tbody>
</table>

So under the first td 'team' it inserts the 10 teams, but I want to be able to replace the data with player names instead of the 'Team 01' or 'Team 02' etc...For each one, it pulls I need to substitute for a person name.

Could you edit your question and include an minimal example of the JSON payload, since the external site i.e. freerdarts.com and the link might break over time. — Igor
– Igor, Commented Sep 19, 2019 at 8:30

Lukasz Formela · Accepted Answer · 2019-09-19 09:17:30Z

1

You probably need to define players like this:

$players = [
   '01' => [
       'name1',
       'name2',
       'name3',
   ],
   '02' => [
       'name1',
       'name2',
       'name3',
   ],
];

Then read the array as follows:

<tbody>
    <?php 
        foreach($standings as $row):
        $team_number = explode(' ', $row['team'])[1]; 
        ?>
        <tr>
           <td><?=implode(',', $players[$team_number]);?></td>
           <td><?=$row['win%'];?></td>
           <td><?=$row['games'];?></td>
           <td><?=$row['wins'];?></td>
        </tr>
    <?php endforeach;?>
</tbody>

edited Sep 19, 2019 at 9:17

answered Sep 19, 2019 at 8:29

Lukasz Formela

4475 silver badges18 bronze badges

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

2 Comments

KJThaDon Over a year ago

Thanks LucaThemes. I have tried to implement the array, but I must be missing something here. Please see here tehplayground.com/OWRTTm82SCI7lyb1

Lukasz Formela Over a year ago

@KJThaDon it's my fault, sorry. I have updated my answer. You can't echo an array directly, it has to be converted to a string first. implode() function will merge all array elements into one string, putting a comma in between them (or any character you prefer). If there is only one name per team like in your example, no comma will be displayed.

Collectives™ on Stack Overflow

Replacing text from json objects to php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related