Can't display JSON nested arrays with HTML table and PHP

Question

I am trying to display the table that shows the latest vaccination data in each country. I managed to pull out the list of countries, but I could not display the nested arrays of the latest data, total vaccinated, and total vaccinations per hundred.

I want to display the array of total_vaccinations and total_vaccinations_per_hundred that contains the latest date value from date.

I am open to using jQuery and Javascript to make this work.

Here is the small section of the JSON data. The original data is here: https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/vaccinations/vaccinations.json

Small snipped of the HTML/PHP table


    <div class="container my-3 text-center">
      <h2 class="display-6">Vaccine Live Data</h2>
      <table class="table sortable" id="table" data-toggle="table">
        <thead class="table-dark">
          <tr>
            <th scope="col">Countries</th>
            <th scope="col">Last Updated</th>
            <th scope="col">Total vaccinated</th>
            <th scope="col">Total Vaccinated Per Hundred</th>

          </tr>
        </thead>

        <tbody>
          <?php
                        foreach($data as $key => $info){
                    ?>
            <tr>
              <th class="sorttable_nosort">
                <?php echo $info['country']; ?>
              </th>

              <td data-order='desc' data-field="firstdose" data-sortable="true">
                <?php foreach($info['data'] as $key => $value) {  echo $value['date'];
     } ?>
              </td>

            </tr>

            <?php } ?>
        </tbody>



      </table>
    </div>

The current table output: image here

Ruben · Accepted Answer · 2021-08-14 18:06:35Z

1

Try something like this, is not finished. but you can take an idea. Basically this script takes the last array of the country and display it, assuming that is the last updated. You can sort it with js table.

<div class="container my-3 text-center">
<h2 class="display-6">Vaccine Live Data</h2>
<table class="table sortable" id="table" data-toggle="table">
<thead class="table-dark">
    <tr>
    <th scope="col">Countries</th>
    <th scope="col">Last Updated</th>
    <th scope="col">Total vaccinated</th>
    <th scope="col">Total Vaccinated Per Hundred</th>
    <th scope="col">People Vaccinated Per Hundred</th>

    </tr>
</thead>

<tbody>
    <?php foreach($data as $key => $info){
        $last_array = end($info["data"]);
    ?>
    <tr>
        <td class="sorttable_nosort">
        <?php echo $info['country']; ?>
        </td>
        <td data-order='desc' data-field="firstdose" data-sortable="true">
            <?=$last_array["date"]?>
        </td>
        <td data-order='desc' data-field="firstdose" data-sortable="true">
            <?=$last_array["total_vaccinations"]?>
        </td>
        <td data-order='desc' data-field="firstdose" data-sortable="true">
            <?=$last_array["total_vaccinations_per_hundred"]?>
        </td>
        <td data-order='desc' data-field="firstdose" data-sortable="true">
            <?php
            if($last_array["people_vaccinated_per_hundred"]){
                echo $last_array["people_vaccinated_per_hundred"];
            }else{
                echo 'No data available';
            }
            ?>
        </td>

    </tr>

    <?php } ?>
</tbody>



</table>

edited Aug 14, 2021 at 18:06

answered Aug 14, 2021 at 0:07

Ruben

3092 silver badges15 bronze badges

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

3 Comments

Zee Over a year ago

Your code has worked great except I have encountered Warning: Undefined array key "people_vaccinated_per_hundred" for the arrays that do not have people_vaccinated_per_hundred. How do I insert the if statement for the array to display "Data not available" if an array doesn't contain people_vaccinated_per_hundred?

Zee Over a year ago

Unfortunately, the if-statement still shows the same error, however, I was able to solve it with the following code: <?php if (array_key_exists("people_vaccinated_per_hundred",$last_array)) { echo $last_array["people_vaccinated_per_hundred"]; } else { echo 'No dispone de datos'; } ?>

Ruben Over a year ago

que raro a mi si me funciona, podria ser la version de php. pero igual tu forma esta correcta!

Collectives™ on Stack Overflow

Can't display JSON nested arrays with HTML table and PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related