PHP json_encode extra quote before array square bracket

Question

I intend to generate JSON that's like this:

{ "stores": [{"Name":"abc","Phone","1234567"},{"Name":"def","Phone","1111111"}], "numResults": 2 }

My php code is like this:

       while($row = mysql_fetch_assoc($result)){
            $store[] = $row;
            $k++;
       }
       $obj['stores'] = json_encode($store);           
       $obj['numResult'] = $numResult;           
       echo stripslashes(json_encode($obj));

However the result seems to have an extra pair of double quotes around the square brackets:

{ "stores": "[{"Name":"abc","Phone","1234567"},{"Name":"def","Phone","1111111"}]", "numResults": 2 }

How can I remove them? (Or is what's actually showing suppose to be the correct JSON formatting?)

Thanks!

You remove them by not adding them ;)

hakre
– hakre

2011-11-26 20:32:20 +00:00
Commented Nov 26, 2011 at 20:32 — hakre
– hakre, Commented Nov 26, 2011 at 20:32

Jonathan M · Accepted Answer · 2011-11-26 20:30:54Z

3

Only convert to JSON one time, once you have the complete object the way you want it:

       while($row = mysql_fetch_assoc($result)){
            $store[] = $row;
            $k++;
       }
       $obj['stores'] = $store; // <---------Note change           
       $obj['numResult'] = $numResult;           
       $myJSONstring = json_encode($obj);

edited Nov 26, 2011 at 20:30

answered Nov 26, 2011 at 20:25

Jonathan M

17.5k9 gold badges61 silver badges95 bronze badges

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

Comments

anson · Accepted Answer · 2011-11-26 20:26:11Z

1

You wont need to json_encode twice. Create your $obj variable and json_encode that once it is completely created.

answered Nov 26, 2011 at 20:26

anson

4,1742 gold badges25 silver badges30 bronze badges

Comments

HungryDB · Accepted Answer · 2014-12-10 08:50:26Z

1

Simple way would be

$my_string = json_encode($my_json,JSON_FORCE_OBJECT);

answered Dec 10, 2014 at 8:50

HungryDB

5753 gold badges11 silver badges31 bronze badges

Collectives™ on Stack Overflow

PHP json_encode extra quote before array square bracket

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