How to parse JSON from file using PHP then extract as TABLE

Question

I'm just stucked with this. How could I read a json file using PHP.

I have file.json with the following data sample

[
    {
        "lastname": "John",
        "firstname": "Michael"
    },
    {
        "lastname": "Nick",
        "firstname": "Bright"
    },
    {
        "lastname": "Cruz",
        "firstname": "Manny"
    }
]

Can you share me a php code how to read file.json and extract it to html table?

<table>
<tr><td>Firstname</td><td>Lastname</td></tr>
</table>

Thank you in advance

Sorry, my question might be duplicate but the samples from the page you mention is different from my JSON file data structure. — LayoutPH
– LayoutPH, Commented Mar 5, 2015 at 3:35

Adrian Cid Almaguer · Accepted Answer · 2015-03-05 03:19:52Z

1

Check my json because in your code you have an extra comma in the firstname line.

Try this code:

<?php

$json =  '[
    {
        "lastname": "John",
        "firstname": "Michael"
    },
    {
        "lastname": "Nick",
        "firstname": "Bright"
    },
    {
        "lastname": "Cruz",
        "firstname": "Manny"
    }
]';

$obj = json_decode($json, true);

echo '<table>
<tr><td>Firstname</td><td>Lastname</td></tr>';

foreach($obj as $key => $value) {
    echo "<tr><td>{$value['firstname']}</td><td>{$value['lastname']}</td></tr>";
}   

echo '</table>';

?>

answered Mar 5, 2015 at 3:19

Adrian Cid Almaguer

7,79113 gold badges44 silver badges66 bronze badges

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

Comments

3 revs, 2 users 69% · Accepted Answer · 2015-03-05 03:29:18Z

1

You can decode Json String By json_decode();

<?php 

$jsonStr =  '[
    {
        "lastname": "John",
        "firstname": "Michael"
    },
    {
        "lastname": "Nick",
        "firstname": "Bright"
    },
    {
        "lastname": "Cruz",
        "firstname": "Manny"
    }
]';

$jsonObj = json_decode($jsonStr,true);

var_dump($jsonObj);

?>

edited Mar 5, 2015 at 3:29

community wiki

3 revs, 2 users 69%
Mehmet Ali Uysal

Collectives™ on Stack Overflow

How to parse JSON from file using PHP then extract as TABLE

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related