How do I convert a JSON object to a string?
I want to insert a JSON object into a mysql DB.
-
5Exactly what is a "json object" in php?VolkerK– VolkerK2010-07-31 10:42:32 +00:00Commented Jul 31, 2010 at 10:42
-
7the output of json_encode is a string! what json object are you talking about?bcosca– bcosca2010-07-31 10:53:32 +00:00Commented Jul 31, 2010 at 10:53
-
Are you facing any problem with the PHP part or with the MySQL part? What have you tried to resolve the problem? Where are you stuck?Nico Haase– Nico Haase2024-05-22 12:58:06 +00:00Commented May 22, 2024 at 12:58
-
JSON is a serialization format, so it's a string already. JSON (the format) is sometimes confused with JavaScript (the language), thus the use of the incorrect term "JSON object", but it's unclear what that can possibly mean in the context of PHP.Álvaro González– Álvaro González2024-05-22 13:07:10 +00:00Commented May 22, 2024 at 13:07
Add a comment
|
2 Answers
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.
3 Comments
nclsvh
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..
VolkerK
That's just how a linebreak is encoded in JSON (and javascript). When it gets parsed the
\n "becomes" a linebreak again, see jsfiddle.net/tafodvn5nclsvh
Yep, found out the hard way late at night :p Anyway thanks for the reply!
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.
2 Comments
Mihai Galan
JSON is not a string. stackoverflow.com/questions/54122999/is-json-a-string/54123061
Chuck Le Butt
@MihaiGalan That answer is misleading. JSON is a format, but its data is stored in a string.