How can I parse JSON into a html table using PHP?

Question

I have to get a table in my website. And have to get the data for this table from "http://west.basketball.nl/db/json/stand.pl?szn_Naam=2014-2015&cmp_ID=373" I've tried a lot of thing but nothing works....

 <!DOCTYPE html>
  <html>
   <head>
    <script type="text/javascript" 
       src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
   </head>
   <body>
    <?php
    $json=file_get_contents("http://west.basketball.nl/db/json
    /stand.pl?szn_Naam=2014-2015&cmp_ID=373");
            $data =  json_decode($json);

        if (count($data)) {
            // Open the table
            echo "<table>";

            // Cycle through the array
            foreach ($data as $stand) {

                // Output a row
                echo "<tr>";
                echo "<td>$afko</td>";
                echo "<td>$positie</td>";
                echo "</tr>";
            }

            // Close the table
            echo "</table>";
        }
    ?>
  </body>
</html>

Sorry fellows... forgot to say but this is written in a .php file — Mike Lammers, Oct 06 '14 at 09:12
What does not work? Have you set `error_reporting` to `E_ALL` and `display_errors` to `on` in your dev environement? — TiMESPLiNTER, Oct 06 '14 at 09:15
I guess the problem is that url_fopen is set to disabled due to security reason. Add `error_reporting(E_ALL);` to the beginnig of your PHP script. And make sure in your .htaccess or php.ini that `display_errors` is set to `On` or have a view into the PHP log file after your request. — TiMESPLiNTER, Oct 06 '14 at 09:19
i dont know what a php.ini is and dont know what a .htaccess is so..... , i did add the error reporting but it still doesnt work. There is one error in the console, its about the drawing set of the html and how its not declared and about US-ASCCI or something? — Mike Lammers, Oct 06 '14 at 09:25
You don't see PHP errors on the client side error console because PHP is a server side thing. You have to look into the PHP error log on your webserver to figure that out. Or you create a `.htaccess` file in the folder where your script is and put the following line into it: `display_errors On`. — TiMESPLiNTER, Oct 06 '14 at 09:29
This thread has been answered here [Click here](https://stackoverflow.com/questions/4746079/how-to-create-a-html-table-from-a-php-array/47068295#47068295) — Delickate, Nov 02 '17 at 06:12

score 26 · Answer 1 · answered Apr 21 '16 at 05:34

If you want recursive way:

public static function jsonToDebug($jsonText = '')
{
    $arr = json_decode($jsonText, true);
    $html = "";
    if ($arr && is_array($arr)) {
        $html .= self::_arrayToHtmlTableRecursive($arr);
    }
    return $html;
}

private static function _arrayToHtmlTableRecursive($arr) {
    $str = "<table><tbody>";
    foreach ($arr as $key => $val) {
        $str .= "<tr>";
        $str .= "<td>$key</td>";
        $str .= "<td>";
        if (is_array($val)) {
            if (!empty($val)) {
                $str .= self::_arrayToHtmlTableRecursive($val);
            }
        } else {
            $str .= "<strong>$val</strong>";
        }
        $str .= "</td></tr>";
    }
    $str .= "</tbody></table>";

    return $str;
}

Then call echo YourClass::jsonToDebug($jsonText);

My test on http://sandbox.onlinephpfunctions.com/

Best answer, since it's 1) structure-agnostic and 2) code-efficient (recursive) — Isidro Moran, Oct 05 '16 at 21:29
Great! You could also change `$str .= "$val";` to `$str .= '' . var_export($val, true) . '';` to display falsey values, etc. — Syscall, Apr 05 '22 at 19:07

score 19 · Accepted Answer · answered Oct 06 '14 at 09:33

Ok first thing to do when getting data from an external source is to understand what is being returned.

So do

<?php
$json=file_get_contents("http://west.basketball.nl/db/json/stand.pl?szn_Naam=2014-2015&cmp_ID=373");
$data =  json_decode($json);

print_r($data);

Result:

So now you know you are dealing with an OBJECT and not scalar values or an array.

So try this code:-

<?php
    $json=file_get_contents("http://west.basketball.nl/db/json/stand.pl?szn_Naam=2014-2015&cmp_ID=373");
    $data =  json_decode($json);

    if (count($data->stand)) {
        // Open the table
        echo "<table>";

        // Cycle through the array
        foreach ($data->stand as $idx => $stand) {

            // Output a row
            echo "<tr>";
            echo "<td>$stand->afko</td>";
            echo "<td>$stand->positie</td>";
            echo "</tr>";
        }

        // Close the table
        echo "</table>";
    }
?>

Wow Thank a lot it finally works :D Do you know a way to make it sort bij the positions? 1.2.3.4.5.6.7.8.9.10.11 and so on so on — Mike Lammers, Oct 06 '14 at 09:36

score 2 · Answer 3 · answered Oct 06 '14 at 10:04

2

Why not try :

$data = json_decode($json, true);

answered Oct 06 '14 at 10:04

Nixus

31
1

1

Explanation: the second argument (true) tells json_decode() to return an associative array rather than object of the given data which can be more intuitive to work with if you're not into OO programming. – ChrisN Oct 11 '18 at 11:45

score 0 · Answer 4 · answered Oct 06 '14 at 09:23

I guess, the issue is with the variables you are using - $afko and $positie. Please try with the below code -

// Cycle through the array
foreach ($data as $stand) {
    // Output a row
    echo "<tr>";
    echo "<td> . $stand['afko'] . </td>";
    echo "<td> . $stand['positie'] . </td>";
    echo "</tr>";
}

score 0 · Answer 5 · answered Mar 14 '20 at 23:14

This code below can be useful for dynamically converting your entire table without having to define column names.

 echo "<table>";
        echo "<tr>";
        foreach(array_keys($your_array[0]) as $head){
            echo "<td>$head</td>";
        }
        echo "</tr>";

        foreach($your_array as $row){
            echo "<tr>";            
            foreach($row as $col){
                echo "<td>$col</td>";
            }
            echo "</tr>";
        }
        echo "</table>";

        return $posicoes;

How can I parse JSON into a html table using PHP?

5 Answers5

Linked

Related