Jump to content


New Line Characters In Sql

  • Please log in to reply
1 reply to this topic

#1 omerjerk

  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 30 November 2012 - 11:44 AM

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 ...???

#2 Barand

  • Moderators
  • Sen . ( ile || sei )
  • 17,839 posts

Posted 30 November 2012 - 12:00 PM

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.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received


|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users