Fetch json data using PHP

Question

I have a json file and I want to display it data using PHP. My below code gives me error,

$json = file_get_contents('data.json'); 
$data = json_decode($json,true);
$users = $data['devices'];
foreach($users as $user)
{
echo $user['id'];
echo $user['user'];
}

When I replace the 3rd LOC with $users = $data['user']; then it display some data with single alphabet i don't know in which order.

Data.json file contains the following data

{
"user":
    {
    "id":"#03B7F72C1A522631",
    "user":"[email protected]",
    "password":"123",
    "email":"[email protected]",
    "name":"m",
    "creationDate":1385048478,
    "compression":true,
    "imageProfile":"medium",
    "videoProfile":"medium",
    "blockAdvert":true,
    "blockTracking":true,
    "devices":[
        {
        "id":"#13C73379A7CC2310",
        "udid":"cGMtd2luNi4xLV",
        "user":"[email protected]",
        "creationDate":1385048478,
        "status":"active",
        }, 
        {
        "id":"#FE729556EDD9910D",
        "udid":"C1N1",
        "user":"[email protected]",
        "creationDate":1385291938,
        "status":"active",
        }]
    },
"status":
    {
    "version":"0.9.5.0",
    "command":"getuser",
    "opf":"json",
    "error":false,
    "code":0
    }
}

G.Mendes · Accepted Answer · 2013-11-25 12:56:28Z

4

I believe you skipped 1 node, try:

$users = $data['user']['devices'];

answered Nov 25, 2013 at 12:56

G.Mendes

1,2211 gold badge13 silver badges18 bronze badges

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

Comments

l-x · Accepted Answer · 2013-11-25 12:56:43Z

4

This should work;

$json = file_get_contents('data.json'); 
$data = json_decode($json,true);
$users = $data['user']['devices'];
foreach($users as $user) {
    echo $user['id'];
    echo $user['user'];
}

There is one key before 'devices'.

answered Nov 25, 2013 at 12:56

l-x

1,5699 silver badges17 bronze badges

Comments

srain · Accepted Answer · 2013-11-25 12:56:56Z

3

I think you may want do display all the devices info, you can change you code to:

$json = file_get_contents('data.json'); 
$data = json_decode($json,true);

// change the variable name to devices which is clearer.
$devices = $data['user']['devices'];
foreach ($devices as $device)
{
    echo $device['id'];
    echo $device['user'];
}

answered Nov 25, 2013 at 12:56

srain

9,1426 gold badges32 silver badges43 bronze badges

Comments

ddelnano · Accepted Answer · 2013-11-25 13:13:57Z

1

You are not accessing your json correctly. You need to access it like this.

$yourVariable = $data['users']['devices'];

Try that.

edited Nov 25, 2013 at 13:13

answered Nov 25, 2013 at 12:52

ddelnano

4695 silver badges19 bronze badges

4 Comments

l-x Over a year ago

OP wrote $data = json_decode($json,true); which returns an array instead of object.

ddelnano Over a year ago

docs.php.net/json_decode the documentation says that if the parameter $assoc is true it will turn objects into associative arrays. I am pretty sure this is false by default correct me if I am wrong.

ddelnano Over a year ago

phpriot.com/manual/php/function.json-decode this example shows an object is returned by default if the $assoc parameter is left out.

l-x Over a year ago

It defaults to false, but OP explicit wrote true

Collectives™ on Stack Overflow

Fetch json data using PHP

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related