How to convert a PHP array into json string

Question

I have a PHP array built with a while loop. I do successfully convert it to JSON string, however the output is not what I want and need some help to get it right:

My current code:

while(!$sql_query->EOF){
     $data[] = array(
                'id'                => $id, 
                'name'              => $name,
                'title'             => $title
                );
$sql_query-> MoveNext(); }

echo json_encode($data);

The output I get with my code is this:

[
   {
     "id":"1",
     "name":"Nick",
     "title":"Office"
   },
   {
     "id":"2",
     "name":"Amy",
     "title":"Home"
   }
]

However, I need the outcome to be:

{
  "data": [
    [
      "1",
      "Nick",
      "Office"
    ],
    [
      "2",
      "Amy",
      "Home"
    ]
  ]
}

I tired paying around with array_values() but no success so far.

Can somebody suggest the right approach here?

Nigel Ren · Accepted Answer · 2019-11-25 12:25:22Z

4

When building your array, don't add the keys to the values, this will allow the encoding to use array notation, then add the "data" key as part of the encode...

$data = [];
while(!$sql_query->EOF){
    $data[] = [ $id, $name,$title];
    $sql_query-> MoveNext(); 
}

echo json_encode(["data" => $data]);

answered Nov 25, 2019 at 12:25

Nigel Ren

57.2k11 gold badges49 silver badges59 bronze badges

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

Comments

Terry Lennox · Accepted Answer · 2019-11-25 12:24:53Z

2

If you do something like:

$result = (object)["data" => $data];
echo json_encode($data);

this will give you the output you require.

answered Nov 25, 2019 at 12:24

Terry Lennox

30.9k5 gold badges36 silver badges45 bronze badges

Comments

Eugene · Accepted Answer · 2019-11-25 12:25:18Z

2

First of all you have to modify you array

$newData = [];
foreach($data as $item) {
    $newData[] = array_values($item);
}

and then create new array

echo json_encode(["data"=>$newData])

answered Nov 25, 2019 at 12:25

Eugene

1,7303 gold badges16 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to convert a PHP array into json string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related