Line break problem

[tanfwc]

Hi,

After trying to search for solution, I can't seem to resolve this. Hope someone can guide me while I learn PHP

$comment variable will be fill in by sql query. The result return is

Test Comment 3\r\nTest Comment 3\r\nTest Comment 3\r\nTest Comment 3
str_replace("\r\n", "<br />", $comment)

Thank you in advance

[NogDog]

And the problem/question is?....

[tanfwc]

Oh, sorry. How to replace \r\n with <br /> after getting the record from sql?

[NogDog]

You could just use the nl2br() function (http://php.net/nl2br).

[Neoboffin]

This would make $comment become the new $comment.
$comment = str_replace("\r\n", "<br />", $comment);

[tanfwc]

Thanks for the headup...but strange, it still return the same result...

[tanfwc]

This would make $comment become the new $comment.
I did try to print the new variable, it always return the same result query from the DB

[Neoboffin]

Can you show some of your script because what you trying to do should work.

[tanfwc]

while( $row = mysql_fetch_array( $result )) {
$comment = $row["tablename"];
$test = str_replace("\r\n", "<br />", $comment);
echo $test;
}

Is this enough?

[Neoboffin]

That should work. If not, try just having this:

$test = str_replace("\n", "<br />", $comment);

[tanfwc]

this is killing me...it still return the same result...tks for the help anyway

[NogDog]

Are you sure it's "\r\n" and not just "\n" in the DB? Have you tried using the nl2br() function which already exists in PHP? Have you looked at the "view source" screen of your browser to see exactly what has been output?

If you do not want to use nl2br(), I'd recommend this:

$test = preg_replace('/\r?\n/', "<br />\n", $comment);

[tanfwc]

Tks lot NogDog..but i try, still fail...

anyway, I manage to fix the problem.

$test = str_replace("\\r\\n", "<br />", $comment);

NogDog, I am very sure in the db, it is \r\n

I'm still wondering why I need to do double \?

[NogDog]

That suggests to me that what is in the DB is literally a sequence of backslash, "r", backslash, "n" instead of a carriage-return character followed by a newline character.