json into mysql5 by php5

Question

i'm trying to put json_encoded strings containing html tags into mysql5. the problem is that the data in mysql seems automatically unescaped all "s. data is fed by POST and i'm using standard mysql_query.

if i print any json string into browser it shows as correctly escaped, \". but when inserted into mysql all \"s became "s. naturally unescaped "s make string non-json. any solutions will be appreciated.

Please post the relevant code.

jwueller
– jwueller

2010-12-09 18:39:14 +00:00
Commented Dec 9, 2010 at 18:39 — jwueller
– jwueller, Commented Dec 9, 2010 at 18:39

jwueller · Accepted Answer · 2010-12-09 19:03:46Z

1

mysql_real_escape_string($s);

edited Dec 9, 2010 at 19:03

jwueller

31.1k5 gold badges69 silver badges71 bronze badges

answered Dec 9, 2010 at 18:42

Tyler Eaves

13.1k1 gold badge34 silver badges40 bronze badges

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

2 Comments

Javier Over a year ago

...or parameterized (prepared) statements

jwueller Over a year ago

You should probably add a link to the documentation and format that snippet as code. +1 for the (probably) helpful answer.

Collectives™ on Stack Overflow

json into mysql5 by php5

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related