how to convert json to string

Question

how do i convert a json object to a string

i want to insert a json object to a mysql DB

the output of json_encode is a string! what json object are you talking about? — bcosca, Jul 31 '10 at 10:53

score 26 · Answer 1 · answered Jul 31 '10 at 10:42

26

You might be interested in json_encode().

On the other hand if you already got something json encoded then it already is a string and you can simply store it as-is in the database.

answered Jul 31 '10 at 10:42

VolkerK

Old post but, can you tell me why I get these `\n` instead of `new line` in my string? I need to `json_encode($data)` to store to Redis (as string). And later `json_decode($string)` to get my values from a json.. – nclsvh Jan 13 '16 at 19:43
1

That's just how a linebreak is encoded in JSON (and javascript). When it gets parsed the `\n` "becomes" a linebreak again, see https://jsfiddle.net/tafodvn5/ – VolkerK Jan 14 '16 at 00:15
Yep, found out the hard way late at night :p Anyway thanks for the reply! – nclsvh Jan 14 '16 at 11:38

score 10 · Answer 2 · answered Oct 29 '17 at 09:56

10

JSON itself is a string. People use json_encode() and json_decode() to convert objects/arrays of PHP to string and back to objects/arrays.

answered Oct 29 '17 at 09:56

Ramesh Seera

2

JSON is not a string. https://stackoverflow.com/questions/54122999/is-json-a-string/54123061 – Mihai Galan Feb 14 '22 at 02:42
@MihaiGalan That answer is misleading. JSON is a format, but its data is stored in a string. – Chuck Le Butt Feb 06 '23 at 18:34

score -2 · Answer 3 · answered Mar 30 '21 at 11:01

-2

$array = json_decode($json,true); $string = implode(",",$array);

Now you can save this string in db as text.

answered Mar 30 '21 at 11:01

Affan Qureshi

1

This isn't really adding anything to the question that's not yet been added. Also, please use code formatting to make code more readable. – Simon S. Mar 30 '21 at 11:27

3 Answers3