Line Breaks (\r\n) & MySQL

[kevinkorb]

When I post a string from a textbox, I then clean it for mysql...

When I output the string to an update textarea, it actually comes out \r\n instead of the line breaks.

i.e.

$_POST['myTextArea'];
$clean = mysqli_real_escape_string($_POST['myTextArea']);

mysqli_query("INSERT INTO myTable (myVal) VALUES ('$clean');");

When getting the data back out

Say I entered in..

test1
test2
test3

my textbox populates

test1\r\ntest2\r\ntest3\r\n

when I do a stripslashes on it it outputs

test1rntest2rntest3rn

How do I get the database to recognize the breaks and not literal text?  Or how do I get the data out as planned?

Thanks.

[Jessica]

don't do stripslashes, use nl2br and then stripslashes.

[kevinkorb]

I'm trying to output it back into a textarea to look exactly like it did originally... With the nl2br it will be

test1<br>test2<br>test3

[wildteen88]

mysqli_real_escape_string shouldn't effect it, as \r and \n are invisible characters. Somewhere in your script it is causing this. What happens when you run nl2br on the string does it convert the \r\n in to a HTML line break ([nobbc]<br />[/nobbc])?