PHP_EOL or \r\n

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

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']);

By Djulia - February 2, 2018

Hi,

Did you test with nl2br?

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

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

Thanks,

Djulia

By ht1080z - February 3, 2018

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

By Djulia - February 4, 2018

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