how to write a json file as a datasource in php?

Question

I have some data like this

"name": "abc",
"adr": "bcd",
"partners": {
            "101": {
                   "name": "xyz.com",
                   "prices": {
                            "1001": {
                            "description": "Single Room",
                            "amount": 125,
                            "from": "2012-10-12",
                            "to": "2012-10-13"
                            },
                            "1002": {
                            "description": "Double Room",
                            "amount": 139,
                            "from": "2012-10-12",
                            "to": "2012-10-13"
                        }
                    }

Now, I have to write a json with all this data and use it as a data source.

How can I do it ?

Create a PHP script containing the data you need (as array, objects, whatever), json_encode() that data to a string, and write that string to your file — Mark Baker, Jun 21 '15 at 10:39
Addition to answers below, use `blob` datatype for the field in your database. — BentCoder, Jun 21 '15 at 14:49

Jens A. Koch · Answer 1 · 2015-06-21T10:51:31.683

The data you posted is not valid JSON. It misses some surrounding and ending brackets.

Ok, let's fix that... and save it as data.json:

{
    "name": "abc",
    "adr": "bcd",
    "partners": {
        "101": {
            "name": "xyz.com",
            "prices": {
                "1001": {
                    "description": "SingleRoom",
                    "amount": 125,
                    "from": "2012-10-12",
                    "to": "2012-10-13"
                },
                "1002": {
                    "description": "DoubleRoom",
                    "amount": 139,
                    "from": "2012-10-12",
                    "to": "2012-10-13"
                }
            }
        }
    }
}

To access the JSON with PHP you can simply load the file and convert the JSON to an array.

<?php 
$jsonFile = "data.json"
$json = file_get_contents($jsonFile);
$data = json_decode($json, TRUE);

echo "<pre>";
print_r($data);
echo "</pre>";
?>

score 0 · Answer 2 · answered Jun 21 '15 at 10:51

A PHP Script to create a file containing this data as json

// the data you need 
$phpData = [
    "name" => "abc",
    "adr" => "bcd",
    "partners" => [
        "101" => [
            "name" => "xyz.com",
            "prices" => [
                "1001" => [
                    "description" => "Single Room",
                    "amount" => 125,
                    "from" => "2012-10-12",
                    "to" => "2012-10-13",
                ],
                "1002" => [
                    "description" => "Double Room",
                    "amount" => 139,
                    "from" => "2012-10-12",
                    "to" => "2012-10-13",
                ]
            ]
        ]
    ]
];

// json_encode() that data to a string
$jsonData = json_encode($phpData);
// write that string to your file
file_put_contents('myJsonFile.json', $jsonData);

And to use it as a datasource

$myData = json_decode(
    file_get_contents('myJsonFile.json')
);

how to write a json file as a datasource in php?

2 Answers2

Linked