Jump to content


Photo

New Line Characters In Sql


  • Please log in to reply
1 reply to this topic

#1 omerjerk

omerjerk

    Newbie

  • New Members
  • Pip
  • 6 posts

Posted 30 November 2012 - 06: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

Barand

    Sen . ( ile || sei )

  • Gurus
  • 14,224 posts
  • LocationCheshire, UK

Posted 30 November 2012 - 07:00 AM

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.

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
|baaSelect| generate js and php code for dynamic linked dropdowns

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com