PHP index array for JSON

Question

Looking for some help.. Don't know the best approach to this issue... I'm pushing a new reference onto an array but the "true" value is being inserted with quotes, which fails my json format.

 while( $row = mysqli_fetch_assoc($res) ) { 
    if($row['id']=="2"){
    $row['children']= 'true';
    }
    $data[] = $row;
}
echo json_encode( $data);

Outputs

[{"id":"2","name":"john","text":"john","parent_id":"0","children":"true"}]

When i need...

{"id":"2","name":"john","text":"john","parent_id":"0","children":true}]

How would i go about removing the qoutes or inserting it correctly first.??

JSON data is passed as a STRING so "children":"true" is correct! It will be usable when you get to your javascript and convert it to a javascript object — RiggsFolly
– RiggsFolly, Commented Sep 18, 2016 at 20:55
'true' is a string, true is a boolean. You want a boolean. — doug65536
– doug65536, Commented Sep 18, 2016 at 20:56
@Howzieky You shouldn't use str_replace because it is an unreliable hack. If you put a string in the array, json_encode puts a string in the JSON, if you put a boolean in the array, it puts a boolean in the JSON. Instead of screwing around with the JSON string, just provide json_encode with values that are the correct type to begin with. — doug65536
– doug65536, Commented Sep 18, 2016 at 21:17

jakub wrona · Accepted Answer · 2016-09-18 20:58:29Z

1

If you want the 'children' to be boolean then set it to boolean.

while( $row = mysqli_fetch_assoc($res) ) { if($row['id']=="2"){ $row['children'] = true; } $data[] = $row; } echo json_encode( $data);

answered Sep 18, 2016 at 20:58

jakub wrona

2,25219 silver badges19 bronze badges

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

1 Comment

Leo505 Over a year ago

Oh yeh! Duh!! Feel so stupid now... Thanks Jakub and others for their quick response.. Much appreciated!

Collectives™ on Stack Overflow

PHP index array for JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related