Jump to content

New Line Characters In Sql


omerjerk

Recommended Posts

I have a text field in a form like this ... <textarea rows="10" cols="150" name="content"></textarea>

 

I am using PHP to store the entered text into the MySql database ...

It is working fine but when I echo the value from the MySQL database onto the webpage , all the text comes up in a single line ...

Means if I entered 3 lines in the text area and save it to database , then by echo from they arey are not coming into three separate lines ...

 

How get rid of this problem ...???

Link to comment
https://forums.phpfreaks.com/topic/271399-new-line-characters-in-sql/
Share on other sites

Whitespace is ignored in HTML output. You have to explicly add the <br> by using nl2br

 

echo nl2br($textfield);

 

If you are redisplaying in a textarea (for editing) you don't need the nl2br, the line breaks should work on their own.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.