json encode in php

Question

I am storing this {background:"default.jpg"} in the database in field of tables as i am taking the table fields data and makint the json by json_encode while encoding this json also get encoded and it is not valid json so how should i encode these json.

{"id_session":"c72b0581e7675b596a7651a7bb906438","gibid":"54","name":"Market Place","type":"S","num_owners":"0","inner_template":"","inner_data":"{background:\"default.jpg\"}","outer_template":"","o

it is adding the slashes how should i get return the valid json.

thanks.

echo json_decode('{background:"default.jpg"}',true); why its not returning the array ? — XMen
– XMen, Commented Dec 13, 2010 at 7:59

deceze · Accepted Answer · 2010-12-13 07:48:06Z

2

Don't store JSON in the database, store it in a neutral format, like key/value columns. Or:

Decode the JSON, merge it into the array to be encoded, then encode it.

$data = array('id' => ...);
$data['inner_data'] = json_decode($databaseJson, true);
json_encode($data);

answered Dec 13, 2010 at 7:48

deceze♦

525k89 gold badges807 silver badges954 bronze badges

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

7 Comments

XMen Over a year ago

echo json_decode('{background:"default.jpg"}',true); why its not returning the array ?

Mchl Over a year ago

Because the {background:"default.jpg"} is not a valid JSON. See jsonlint.com. Valid form is {"background":"default.jpg"}

XMen Over a year ago

Thanks Mchl , why should we not store json in database , and @deceze you are telling about neutral format in key and value what is it please explain ?

Mchl Over a year ago

There's nothing wrong in storing JSON in database. In fact so called 'document databases' use JSON or similar format. What deceze wanted to say, is that one of the ways to overcome your problem is to store this information in your database not JSON encoded.

deceze Over a year ago

@Mchl Yes, but you're forcing me to sidetrack there... ;) If by "document database" you mean something like MongoDB, I'd have to disagree, since you're not usually getting JSON back from such a DB system, but rather some native datatype of the adapter you're using. That the data is stored as JSON has no relevance. If you're talking about a "document schema" stored in an RDBMS, I'd partly agree and partly point out that there must be a better schema to use that fits an RDBMS better. In most cases I'd say there is something wrong with storing JSON in an RDBMS. That may just be me though. :)

|

enricog · Accepted Answer · 2010-12-13 07:48:52Z

0

So you have a JSON string in the database and then you get it out of it and do a json_ecnode on ir again? For php you are just encoding some string (thats why the backslashes on the quotations marks are coming from).

But to achieve what you actually want, you could to decode the JSON string from the database first and then encode it with the rest of your data again.

answered Dec 13, 2010 at 7:48

enricog

4,2955 gold badges37 silver badges56 bronze badges

2 Comments

XMen Over a year ago

echo json_decode('{background:"default.jpg"}',true); why its not returning the array ?

enricog Over a year ago

See Mchl s comment on deceze answer. He's right with his comment.

Syed Imran Ertaza · Accepted Answer · 2024-05-20 13:46:16Z

If we think that, this is your associative array bellow.

$data = array(
    "id_session" => "c72b0581e7675b596a7651a7bb906438",
    "gibid" => "54",
    "name" => "Market Place",
    "type" => "S",
    "num_owners" => "0",
    "inner_template" => "",
    "inner_data" => $databaseJson,
    "outer_template" => ""
);

And bellow is the string stored in a variable named $databaseJson which is added into the associative array $data in key inner_data.

$databaseJson = '{"background":"default.jpg"}';

Now if you encode the array with json_encode() built-in function like this,

$json = json_encode($data);
echo $json;

Then you will get the output with slashes like this.

{"id_session":"c72b0581e7675b596a7651a7bb906438","gibid":"54","name":"Market Place","type":"S","num_owners":"0","inner_template":"","inner_data":"{\"background\":\"default.jpg\"}","outer_template":""}

Because $databaseJson variable is a string which is the value of $data['inner_data']. So when we are encoding the $data array, it's adding the slashes.

So, as you want to get rid of this slashes, you need to decode $databaseJson with the built-in function json_decode() to make the variable as associative array. And the array will look like this.

array("background"=>"default.jpg")

Now if we pass this array as the value of the $data array with the key inner_data, it will not create the slashes.

This is the final code bellow:

$databaseJson = '{"background":"default.jpg"}';

$databaseData = json_decode($databaseJson, true);

$data = array(
    "id_session" => "c72b0581e7675b596a7651a7bb906438",
    "gibid" => "54",
    "name" => "Market Place",
    "type" => "S",
    "num_owners" => "0",
    "inner_template" => "",
    "inner_data" => $databaseData,
    "outer_template" => ""
);

$json = json_encode($data);

echo $json;

So the output of the above code is:

{"id_session":"c72b0581e7675b596a7651a7bb906438","gibid":"54","name":"Market Place","type":"S","num_owners":"0","inner_template":"","inner_data":{"background":"default.jpg"},"outer_template":""}

Collectives™ on Stack Overflow

json encode in php

3 Answers 3

7 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related