php create dynamic html table

Question

How can I create a new row for every 'record' parsed from the JSON file (I can create a tab separated string).
An additional difficulty is that some 'records' only contain data for the column 'Name' and others for all columns.

So my question is how to add a row dynamically to the table and fill the right column ?
(The key form the JSON file is the column header)

Example of JSON format:

{ 
"John":     {"status":"Wait" }, 
"Jennifer": {"status":"Active" }, 
"James":    {"status":"Active","age":56,"count":10,"progress":0.0029857,"bad":0} 
}

My JSON file:{ "John": { "status":"Wait" }, "Jennifer": { "status":"Active" }, "James": { "status":"Active", "age":56, "count":10, "progress":0.0029857, "bad":0 } } — John Doe
– John Doe, Commented Dec 4, 2010 at 12:42

01001111 · Accepted Answer · 2010-12-04 14:44:40Z

5

Something like this would work:

$data = json_decode($json_string);
$columns = array();

echo "<table><tbody>";
foreach ($data as $name => $values) {
    echo "<tr><td>$name</td>";
    foreach ($values as $k => $v) {
        echo "<td>$v</td>";
        $columns[$k] = $k;
    }
    echo "</tr>";
}
echo "</tbody><thead><tr><th>name</th>";
foreach ($columns as $column) {
    echo "<th>$column</th>";
}
echo "</thead></table>"

answered Dec 4, 2010 at 14:44

01001111

8365 silver badges5 bronze badges

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

3 Comments

John Doe Over a year ago

Thx, works great. Added ';' at the end of the 'echo "</thead></table>" '

John Doe Over a year ago

Is it possible to sort the 'name' column. I tried several possibilities using sort(), but no luck so far.

John Doe Over a year ago

That doesn't work. The name column isn't sorted. Also tried asort().

Collectives™ on Stack Overflow

php create dynamic html table

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