reverse mysql_real_escape_string

Question

I have a piece 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?

Useful question.

kta
– kta

2018-03-23 06:08:03 +00:00
Commented Mar 23, 2018 at 6:08 — kta
– kta, Commented Mar 23, 2018 at 6:08

jonathan · Accepted Answer · 2012-06-01 07:03:08Z

10

Who says?

$keyword = "TEST'TEST";

$result1 = mysql_real_escape_string($keyword);
echo $result1 --> TEST\'TEST

$result2 = nl2br(stripslashes($result));
echo $result2 --> TEST'TEST

answered Jun 1, 2012 at 7:03

jonathan

1011 silver badge2 bronze badges

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

1 Comment

Waqar Alamgir Over a year ago

After escaping string, your string can become "TEST \r\n \'TEST", in that case nl2br will not work. So I did something like this: stripslashes(str_replace('\r\n' , '<br/>' , nl2br( "TEST \r\n \'TEST")))

OIS · Accepted Answer · 2009-07-23 11:29:59Z

7

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.

answered Jul 23, 2009 at 11:29

OIS

10.1k3 gold badges35 silver badges41 bronze badges

Comments

Muhwu · Accepted Answer · 2016-08-04 14:18:14Z

If you actually want to reverse that because of how your data is formatted, this is a solution I came up with:

function mysql_unreal_escape_string($string) {
    $characters = array('x00', 'n', 'r', '\\', '\'', '"','x1a');
    $o_chars = array("\x00", "\n", "\r", "\\", "'", "\"", "\x1a");
    for ($i = 0; $i < strlen($string); $i++) {
        if (substr($string, $i, 1) == '\\') {
            foreach ($characters as $index => $char) {
                if ($i <= strlen($string) - strlen($char) && substr($string, $i + 1, strlen($char)) == $char) {
                    $string = substr_replace($string, $o_chars[$index], $i, strlen($char) + 1);
                    break;
                }
            }
        }
    }
    return $string;
}

Collectives™ on Stack Overflow

reverse mysql_real_escape_string

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related