Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

5 posts by 2 authors in: Forums > CMS Builder
Last Post: February 13

By ht1080z - February 2 - edited: February 2

Hi,

I'm trying to remove the \r\n from the string that I inserted to textbox field (from textarea element) into MySQL.

No I cannot remove it displaying again from MySQL to HTML. There is so many solution out there but nothing works.

I tried with:

$orderNotes = str_replace("\r\n",' ', $orderRecord['notes']);
or
$orderNotes = trim(preg_replace( '/\s+/', ' ', trim($orderRecord['notes'])));
or
$orderNotes = str_replace(array("\r\n", "\r", "\n"), "", $orderRecord['notes']);
or
$orderNotes = trim(preg_replace('/\s\s+/', ' ', $orderRecord['notes']));

but my string is continue to echo out with \r\n. Nothing works....!

How can I remove this (or change to <br/>) or better how can I insert to MySQL without it?

Please advise,
Karls

PS: I found a solution, the only thing that works:

$orderNotes = str_ireplace(array("\r\n",'\r\n'),'<br />', $orderRecord['notes']);

Hi,

Did you test with nl2br?

$orderNotes = nl2br($orderRecord['notes']);

http://php.net/manual/en/function.nl2br.php

Thanks,

Djulia

Hi Djulia,

Thanks for your suggestion! Yes, I tried it but with no luck, only the below code worked in my case:

$orderNotes = str_ireplace(array("\r\n",'\r\n'),'<br />', $orderRecord['notes']);

Any hint how can I remove the newline \r\n that in the $POST from textarea (or change to <br/>) before inserting to MySQL?

Dear iTools team,

I didn't getting notification emails from the forum anymore. How can I opt-in again?

Karls

Hi

Can you test this (in my_form.php)?

<form method="post" action="?">  
<textarea name="comment"><?php echo htmlspecialchars(@$_REQUEST["comment"]); ?></textarea><br />
<input type="submit" name="submit" value="Submit">
</form>

<?php
echo nl2br2(@$_REQUEST["comment"]);

function nl2br2($string) {
    $string = str_replace(array("\r\n", "\r", "\n"), "<br />", $string);
    return $string;
}
?>

Otherwise, can you give an example of text?

Thanks,

Djulia