PHP to nested object JSON output

Question

Currently I have the below JSON as my out put from my php function (also below). However, I need the initial brackets for name list to change from [] to {}. I see this kind of output with actual APIs but I cannot figure out how to make this happen. Any suggestions? JSON Output file:

    {
    "nameList": [
            {
                "id": 1,
                "Name": "Test",
                "Amount": 0,
                "Location": "Test"
            }
    ]
}

PHP Code:

$json = json_encode(array("nameList" => array($MySQL->ReturnDataArray("*","names","WHERE Location = '". $Location ."'")), JSON_PRETTY_PRINT);
        file_put_contents('/assets/server/output.json', $json);

A plugin that I am trying to use only grabs objects with the {} brackets. — DreadedSlug
– DreadedSlug, Commented Sep 14, 2018 at 20:40
what do you want to do if nameList has multiple objects in there — noone
– noone, Commented Sep 14, 2018 at 20:41
Can you show what you want the output to be like? You say you've seen it from other APIs, but that doesn't seem likely since you want invalid JSON. — Barmar
– Barmar, Commented Sep 14, 2018 at 20:52

dev-null-dweller · Accepted Answer · 2018-09-14 20:49:11Z

1

You are explicitly wrapping your data in array:

$data = $MySQL->ReturnDataArray("*","names","WHERE Location = '". $Location ."'");
$json = json_encode(array("nameList" => array($data), JSON_PRETTY_PRINT); // inside []
$json = json_encode(array("nameList" => $data, JSON_PRETTY_PRINT); // without []

answered Sep 14, 2018 at 20:49

dev-null-dweller

29.5k3 gold badges68 silver badges87 bronze badges

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

Comments

steven · Accepted Answer · 2018-09-14 20:50:39Z

0

Please use JSON_FORCE_OBJECT to achieve this

json_encode($foo, JSON_FORCE_OBJECT)

or in your case

json_encode($foo, JSON_FORCE_OBJECT | JSON_PRETTY_PRINT)

But listen to the comments. It is not really a good idea. An array should be an array.

But maybe you want something else.... Lets split your commands:

$step1 = $MySQL->ReturnDataArray("*","names","WHERE Location = '". $Location ."'");

$step2 = array($step1);

$step3 = array("nameList" => $step2);

$step4 = json_encode($step3, JSON_PRETTY_PRINT);

Maybe you want to remove step2!!! So try it like this:

$step1 = $MySQL->ReturnDataArray("*","names","WHERE Location = '". $Location ."'");

//$step2 = array($step1);

$step3 = array("nameList" => $step1);

$step4 = json_encode($step3, JSON_PRETTY_PRINT);

edited Sep 14, 2018 at 20:50

answered Sep 14, 2018 at 20:41

steven

4,8952 gold badges31 silver badges61 bronze badges

6 Comments

DreadedSlug Over a year ago

Using force object changes the array completely to: {"nameList":{"0":{"id":1,"Name":"Test","Amount":0,"Location":"Test"}}}, how would you get the secondary "0" out of there. Also, if an array should be an array then why do companies like rottentomato output it with {} instead of []

steven Over a year ago

Yes, an Object has always an index. You want an Object? You need an index!

steven Over a year ago

@DreadedSlug Or do you want to remove the array because you have always one result?

DreadedSlug Over a year ago

How would you remove the index or change the index?

Barmar Over a year ago

@DreadedSlug Objects are always of the form { "key": value, "key": value, ...}. You can't have {} delimiters without key:value pairs inside.

|

Collectives™ on Stack Overflow

PHP to nested object JSON output

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related