<div>
You could try<br />
<br />
$field = str_replace(array(&quot;\n&quot;,&quot;\r<wbr />&quot;), array('\n','\r'), $field);<br />
<br />
nl2br replaces newlines into &lt;br/&gt;newlines, so therefor the newlines indeed wll not be actually removed to my knowledge.<br />
<br />
-r-
</div>


You could try

$field = str_replace(array("\n","\r"), array('\n','\r'), $field);

nl2br replaces newlines into <br/>newlines, so therefor the newlines indeed wll not be actually removed to my knowledge.

-r-

<div>
thanks, but it does not work..<br />
<br />
in mysql, I can see a long space at the carriage return position and it makes the data can only be shown in 2 line for a row of record..<br />
<br />
<br />
<br />

</div>


thanks, but it does not work..

in mysql, I can see a long space at the carriage return position and it makes the data can only be shown in 2 line for a row of record..





<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
I have a html form with a textarea for input. The data submitted would be sent to mysql db, I found that the textarea input cannot be stored properly to db if user press &quot;enter&quot; to make a new line...<br />
<br />
I would like to replace the carriage return (/n/r) with &nbsp;a space, but it does not work..I also tried the nl2br function, but the carriage return still exists...<br />
<br />
it messes up my csv file outputed by php.. so how can I remove the carriage return from the input?<br />
<br />
Thanks
</div>
</div>


Dear All,

I have a html form with a textarea for input. The data submitted would be sent to mysql db, I found that the textarea input cannot be stored properly to db if user press "enter" to make a new line...

I would like to replace the carriage return (/n/r) with  a space, but it does not work..I also tried the nl2br function, but the carriage return still exists...

it messes up my csv file outputed by php.. so how can I remove the carriage return from the input?

Thanks

storing textarea field into db without carriage return

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.