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

Forum

 

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

By ht1080z - February 2, 2018 - edited: February 2, 2018

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

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

Thank you Djulia for your tips and support on this, sorry for not getting back to you sooner (still not getting forum email notifications).

My problem is when I try to output from MySQL cmsb textbox field where previously I stored from textarea with \r\n

Example (in Greek): Θέλω για ύφασμα το / 644c, (πουά μπλε)\r\nΌπως λέω σε όλες τις εκτυπωσεις

In my case the str_ireplace worked like I posted before.

Thank you again,
Karls