mysql_real_escape_string

[owner]

Hello,

 

I was using mysql_real_escape_string to filter out some of the data being put into the database, and I was able to submit html at first, and everything was working great (or I thought lol).  Then suddenly, I wasn't able to submit html, and every time i have the word don't or something like that, I was getting the \ on all of the '  So, now that mysql_real_escape_string is actually working, how do I allow some of my html, and let words that use ' and are legit to go through?

 

Thanks in advance,

-Owner

[trq]

mysql_real_escape_string will have no effect on preventing html, I'm a little lost as to what your question/problem actually is.

 

Also, note that if you are getting backslashes saved in your database after applying mysql_real_escape_strring it would appear that you have magic_quotes_gpc enabled. Make sure to use stripslashes prior to mysql_real_escape_string, the backslashes should not actually be getting saved to your database.

[owner]

well, on my site I have been using mysql_real_escape_string to filter all of my data. but recently something happened, and if I use mysql_real_escape_string it wont let me add my html.  and I have no idea what would trigger this to not work anymore lol

[owner]

turned out to be an error with either the session or the cache.  Restarted the browser and it works again lol