How to Parse a Json File With PHP

How can I parse a JSON file with PHP?

To iterate over a multidimensional array, you can use RecursiveArrayIterator

$jsonIterator = new RecursiveIteratorIterator(
    new RecursiveArrayIterator(json_decode($json, TRUE)),
    RecursiveIteratorIterator::SELF_FIRST);

foreach ($jsonIterator as $key => $val) {
    if(is_array($val)) {
        echo "$key:\n";
    } else {
        echo "$key => $val\n";
    }
}

Output:

John:
status => Wait
Jennifer:
status => Active
James:
status => Active
age => 56
count => 10
progress => 0.0029857
bad => 0

run on codepad

Get data from JSON file with PHP

Get the content of the JSON file using file_get_contents():

$str = file_get_contents('http://example.com/example.json/');

Now decode the JSON using json_decode():

$json = json_decode($str, true); // decode the JSON into an associative array

You have an associative array containing all the information. To figure out how to access the values you need, you can do the following:

echo '<pre>' . print_r($json, true) . '</pre>';

This will print out the contents of the array in a nice readable format. Note that the second parameter is set to true in order to let print_r() know that the output should be returned (rather than just printed to screen). Then, you access the elements you want, like so:

$temperatureMin = $json['daily']['data'][0]['temperatureMin'];
$temperatureMax = $json['daily']['data'][0]['temperatureMax'];

Or loop through the array however you wish:

foreach ($json['daily']['data'] as $field => $value) {
    // Use $field and $value here
}

Demo!

How can i parse this json file in php?

You can use simple foreach loop like this.

Code

<?php

$json = '{"Files":[{"name":"Tester","Dir":true,"path":"/stor/ok"},{"name":"self","Dir":true,"path":"/stor/nok"}]}';
$json = json_decode($json, true);

?>
<!DOCTYPE html>
<html>
<body>
    <table border="1">
        <tr><td>name</td><td>Dir</td><td>path</td></tr>
        <?php foreach ($json["Files"] as $k => $v): ?>
            <tr>
                <td><?php echo htmlspecialchars($v["name"]); ?></td>
                <td><?php echo htmlspecialchars($v["Dir"]); ?></td>
                <td><?php echo htmlspecialchars($v["path"]); ?></td>
            </tr>
        <?php endforeach; ?>
    </table>
</body>
</html>

Result

screenshot result

Parsing JSON File to array in PHP

<?php
  $string = file_get_contents("./PHP/JSON/clicks.json");
  $json_a = json_decode($string);
  $cx = $json_a->cX;
  $cy = $json_a->cY;
?>

I hope this help you.

Get data from JSON file in php

$obj = json_decode($json,true);
$data = $obj->data->gps;

returns data in a form of array, not object. Remove the 2nd argument from json decode and everything should work.

make it

$obj = json_decode($json);
$data = $obj->data->gps;

Trying to parse this json file and store it in php

If you want to use this as an Array you will have to cast it into it like:

$json_data = (array) json_decode($json);

This will get all Fields from JSON into an PHP Array:

Array ( [Data] => Array ( [0] => stdClass Object ( [id] => 21 [name] => Parle G [item_code] => PG4 ) [1] => stdClass Object ( [id] => 22 [name] => Dark Fentasy [item_code] => DF ) ) )

Alternativ you can casting the data into an Object, so you will have to access fields like $json_data->Data[0]->name

$json_data = (object) json_decode($json);

Read more in the json_decode Documentation: http://php.net/manual/en/function.json-decode.php

How to extract and access data from JSON with PHP?

Intro

First off you have a string. JSON is not an array, an object, or a data structure. JSON is a text-based serialization format - so a fancy string, but still just a string. Decode it in PHP by using json_decode().

 $data = json_decode($json);

Therein you might find:

scalars: strings, ints, floats, and bools
nulls (a special type of its own)
compound types: objects and arrays.

These are the things that can be encoded in JSON. Or more accurately, these are PHP's versions of the things that can be encoded in JSON.

There's nothing special about them. They are not "JSON objects" or "JSON arrays." You've decoded the JSON - you now have basic everyday PHP types.

Objects will be instances of stdClass, a built-in class which is just a generic thing that's not important here.

Accessing object properties

You access the properties of one of these objects the same way you would for the public non-static properties of any other object, e.g. $object->property.

$json = '
{
    "type": "donut",
    "name": "Cake"
}';

$yummy = json_decode($json);

echo $yummy->type; //donut

Accessing array elements

You access the elements of one of these arrays the same way you would for any other array, e.g. $array[0].

$json = '
[
    "Glazed",
    "Chocolate with Sprinkles",
    "Maple"
]';

$toppings = json_decode($json);

echo $toppings[1]; //Chocolate with Sprinkles

Iterate over it with foreach.

foreach ($toppings as $topping) {
    echo $topping, "\n";
}

Glazed

Chocolate with Sprinkles

Maple

Or mess about with any of the bazillion built-in array functions.

Accessing nested items

The properties of objects and the elements of arrays might be more objects and/or arrays - you can simply continue to access their properties and members as usual, e.g. $object->array[0]->etc.

$json = '
{
    "type": "donut",
    "name": "Cake",
    "toppings": [
        { "id": "5002", "type": "Glazed" },
        { "id": "5006", "type": "Chocolate with Sprinkles" },
        { "id": "5004", "type": "Maple" }
    ]
}';

$yummy = json_decode($json);

echo $yummy->toppings[2]->id; //5004

Passing `true` as the second argument to json_decode()

When you do this, instead of objects you'll get associative arrays - arrays with strings for keys. Again you access the elements thereof as usual, e.g. $array['key'].

$json = '
{
    "type": "donut",
    "name": "Cake",
    "toppings": [
        { "id": "5002", "type": "Glazed" },
        { "id": "5006", "type": "Chocolate with Sprinkles" },
        { "id": "5004", "type": "Maple" }
    ]
}';

$yummy = json_decode($json, true);

echo $yummy['toppings'][2]['type']; //Maple

Accessing associative array items

When decoding a JSON object to an associative PHP array, you can iterate both keys and values using the foreach (array_expression as $key => $value) syntax, eg

$json = '
{
    "foo": "foo value",
    "bar": "bar value",
    "baz": "baz value"
}';

$assoc = json_decode($json, true);
foreach ($assoc as $key => $value) {
    echo "The value of key '$key' is '$value'", PHP_EOL;
}

Prints

The value of key 'foo' is 'foo value'

The value of key 'bar' is 'bar value'

The value of key 'baz' is 'baz value'

Don't know how the data is structured

Read the documentation for whatever it is you're getting the JSON from.

Look at the JSON - where you see curly brackets {} expect an object, where you see square brackets [] expect an array.

Hit the decoded data with a print_r():

$json = '
{
    "type": "donut",
    "name": "Cake",
    "toppings": [
        { "id": "5002", "type": "Glazed" },
        { "id": "5006", "type": "Chocolate with Sprinkles" },
        { "id": "5004", "type": "Maple" }
    ]
}';

$yummy = json_decode($json);

print_r($yummy);

and check the output:

stdClass Object
(
    [type] => donut
    [name] => Cake
    [toppings] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 5002
                    [type] => Glazed
                )

            [1] => stdClass Object
                (
                    [id] => 5006
                    [type] => Chocolate with Sprinkles
                )

            [2] => stdClass Object
                (
                    [id] => 5004
                    [type] => Maple
                )

        )

)

It'll tell you where you have objects, where you have arrays, along with the names and values of their members.

If you can only get so far into it before you get lost - go that far and hit that with print_r():

print_r($yummy->toppings[0]);

stdClass Object
(
    [id] => 5002
    [type] => Glazed
)

Take a look at it in this handy interactive JSON explorer.

Break the problem down into pieces that are easier to wrap your head around.

`json_decode()` returns `null`

This happens because either:

The JSON consists entirely of just that, null.
The JSON is invalid - check the result of json_last_error_msg or put it through something like JSONLint.
It contains elements nested more than 512 levels deep. This default max depth can be overridden by passing an integer as the third argument to json_decode().

If you need to change the max depth you're probably solving the wrong problem. Find out why you're getting such deeply nested data (e.g. the service you're querying that's generating the JSON has a bug) and get that to not happen.

Object property name contains a special character

Sometimes you'll have an object property name that contains something like a hyphen - or at sign @ which can't be used in a literal identifier. Instead you can use a string literal within curly braces to address it.

$json = '{"@attributes":{"answer":42}}';
$thing = json_decode($json);

echo $thing->{'@attributes'}->answer; //42

If you have an integer as property see: How to access object properties with names like integers? as reference.

Someone put JSON in your JSON

It's ridiculous but it happens - there's JSON encoded as a string within your JSON. Decode, access the string as usual, decode that, and eventually get to what you need.

$json = '
{
    "type": "donut",
    "name": "Cake",
    "toppings": "[{ \"type\": \"Glazed\" }, { \"type\": \"Maple\" }]"
}';

$yummy = json_decode($json);
$toppings = json_decode($yummy->toppings);

echo $toppings[0]->type; //Glazed

Data doesn't fit in memory

If your JSON is too large for json_decode() to handle at once things start to get tricky. See:

Processing large JSON files in PHP
How to properly iterate through a big json file

How to sort it

See: Reference: all basic ways to sort arrays and data in PHP.

Parse JSON file using PHP/Laravel

You can use json_decode to parse a json data.

mixed json_decode ( string $json [, bool $assoc ] )

For example:

$rooms = json_decode($yourJsonHere, true);

var_dump($rooms);

foreach($rooms as $name => $data) {
    var_dump($name, $data['calID'], $data['availMsg']); // $name is the Name of Room
}

How to Parse a Json File With PHP

How can I parse a JSON file with PHP?

Get data from JSON file with PHP

How can i parse this json file in php?

Code

Result

Parsing JSON File to array in PHP

Get data from JSON file in php

Trying to parse this json file and store it in php

How to extract and access data from JSON with PHP?

Intro

Accessing object properties

Accessing array elements

Accessing nested items

Passing `true` as the second argument to json_decode()

Accessing associative array items

Don't know how the data is structured

`json_decode()` returns `null`

Object property name contains a special character

Someone put JSON in your JSON

Data doesn't fit in memory

How to sort it

Parse JSON file using PHP/Laravel

Related Topics

Leave a reply

How can I parse a JSON file with PHP?

Get data from JSON file with PHP

How can i parse this json file in php?

Code

Result

Parsing JSON File to array in PHP

Get data from JSON file in php

Trying to parse this json file and store it in php

How to extract and access data from JSON with PHP?

Intro

Accessing object properties

Accessing array elements

Accessing nested items

Passing true as the second argument to json_decode()

Accessing associative array items

Don't know how the data is structured

json_decode() returns null

Object property name contains a special character

Someone put JSON in your JSON

Data doesn't fit in memory

How to sort it

Parse JSON file using PHP/Laravel

Related Topics

Leave a reply

Passing `true` as the second argument to json_decode()

`json_decode()` returns `null`