How to create a JSON array using PHP

Question

My JSON data looks like this:

[
    {
        "email":"[email protected]",
        "firstName":"test",
        "lastName":"test",
        "value":"[email protected]",
        "tokens":"[email protected]"
    },
    {
        ...
    }
]

and php data to create json file looks like this:

<?php
    session_start();
    include('connection.php');
    $userId = $_SESSION['sess_user_id'];
    $act = $_POST['action'];
    $sth = mysql_query("SELECT email, firstName, lastName, email AS value, email AS tokens FROM User");
    $rows = array();
    while($r = mysql_fetch_assoc($sth))
    {
        $rows[] = $r;
    }
    $fp = fopen('./test.json', 'w');
    fwrite($fp, json_encode($rows));
    fclose($fp);
?>

When a user is added to the database, it runs this php code:

$file = './test.json';
$data = json_decode(file_get_contents($file), true);
$newdata = array('email'=>$email, 'firstName' => $firstName, 'lastName'=>$lastName, 'value'=>$email, 'tokens'=>$email);
$data[] = $newdata;
file_put_contents($file, json_encode($data));

I want the my JSON file to look like this:

[
    {
        "email":"[email protected]",
        "firstName":"test",
        "lastName":"test",
        "value":"[email protected]",
        "tokens":[
            "[email protected]"
        ]
    }
]

I tried to figure this out, but I couldn't. Please help?

Why? [] means "array," and it doesn't look like email will have >1 value. — Matt Ball
– Matt Ball, Commented Dec 7, 2013 at 3:26

brandonscript · Accepted Answer · 2016-04-30 23:44:50Z

2

php handles arrays different than javascript (which differentiates between objects and arrays).

$newdata = array(
    'email'=>$email, 
    'firstName' => $firstName, 
    'lastName'=>$lastName, 
    'value'=>$email, 
    'tokens'=>array($email)
);

should do it.

edited Apr 30, 2016 at 23:44

answered Dec 7, 2013 at 3:40

brandonscript

73.7k35 gold badges178 silver badges240 bronze badges

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

Collectives™ on Stack Overflow

How to create a JSON array using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related