reverse mysql_real_escape_string

Question

I have a peice of data that is large and will probably contain quotes and double quotes.

I'm using mysql_real_escape_string() to store it safely.

When I pull it out to look at it, all the quotes are escaped. I tried using str_replace to just get rid of all the quotes, but that turns \r\n's into rn. :(

How can I reverse it so the data comes back out the way it went in?

Answer 1

I meant to get rid of the backslashes, not the quotes.

Answer 2

Do you use magic quotes?

Note: If magic_quotes_gpc is enabled, first apply stripslashes() to the data. Using this function [mysql_real_escape_string] on data which has already been escaped will escape the data twice.

Answer 3

Try:

http://www.php.net/stripslashes