Why does MySQL database return backslashes for forward slashes

Question

I entered urls into a MySQL db and when I log it out as json /php I get this:

http:\/\/www.etc....

How can I fix this?

score 4 · Answer 1 · answered Jul 08 '13 at 04:12

4

JSON escapes / as \/ - this is because older browser JavaScript need to use eval to parse it, and many old browsers would use </ to mark the end of a JavaScript block. Therefore, \/ makes it safe.

answered Jul 08 '13 at 04:12

Niet the Dark Absol

320,036
81
464
592

Thanks. How do I fix it so I can get the no-forward-slashes version? How do I parse it? – marciokoko Jul 08 '13 at 14:57
You would need to pass `JSON_UNESCAPED_SLASHES` as the second argument to `json_encode`. Note that it shouldn't matter, really, since if you're using `json_encode` then the decoding context will remove the backslashes anyway. – Niet the Dark Absol Jul 08 '13 at 16:50

score 2 · Answer 2 · edited May 23 '17 at 10:25

2

This has nothing to do with MySQL, but is the JSON-encoding of your slashes.

See also: JSON: why are forward slashes escaped?

edited May 23 '17 at 10:25

Community

1
1

answered Jul 08 '13 at 04:11

Brad

159,648
54
349
530

Why does MySQL database return backslashes for forward slashes

2 Answers2