string replace before adding to MySQL

[mattwidge]

I'm trying to add a <textarea> to a MySQL database.

The <textarea> has multiple lines, so I want to replace \r\n with <p></p>

Here's the <textarea> formatting script:

$entry = $_POST['entry'];
$entry = "<p>".$entry."</p>";
$entry = str_replace("\r\n", "<p></p>", $entry); 

It returns, "**line 1**\r\n**another line**"

[NogDog]

At a guess, the browser is only sending "\n" as the newline, not "\r\n". Also, you probably want to transpose the order to "</p><p>". You could use a regexp to handle any case, including multiple consecutive newlines:

$html = "<p>" . preg_replace('/[\r\n]+/', "</p>\n<p>", $text) . "</p>"; 

[mattwidge]

Still didn't work.

I typed this into the textarea:
text
text

it returned:
Text\r\nText

I check in the DB & it says:
<p>Text\r\nText</p>

[NogDog]

Works for me:

<?php
$text = "text
text

text";

$html = "<p>" . preg_replace('/[\r\n]+/', "</p>\n<p>", $text) . "</p>";
?>
<pre><?php
echo htmlspecialchars($html);
?></pre>

Output:

<p>text</p>
<p>text</p>
<p>text</p>

[mattwidge]

By typing:
Test

Test

It displays:
<p>Test\r\n\r\nTest</p>

the DB:
&lt;p&gt;Test\r\n\r\nTest&lt;/p&gt;

[mattwidge]

I took out the htmlspecialchars() bit & the &lt; &gt; bit is fixed, now it's just the \r\n part.

[NogDog]

I have no idea from the code and descriptions provided how it would happen, but what you are showing us seems to indicate that you do not have carriage return and newline characters in there, but literally back-slash, "r", back-slash, "n" -- which is not the same thing as an actual carriage return and newline which are represented in PHP by "\r\n" when within double quotes.

[dk_zero-cool]

Don't know why you want to replace line break with a P tag since the P tag makes a double line break.

But if you want a P tag, you will need to wrap it around the text.
Something like this.

    $mystr = str_replace("\r", "", $mystr);
    $mystr = preg_replace("/((.*)+)\n/", "<p>$1</p>", $mystr);