omerjerk Posted November 30, 2012 Share Posted November 30, 2012 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 ...??? Quote Link to comment https://forums.phpfreaks.com/topic/271399-new-line-characters-in-sql/ Share on other sites More sharing options...
Barand Posted November 30, 2012 Share Posted November 30, 2012 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. Quote Link to comment https://forums.phpfreaks.com/topic/271399-new-line-characters-in-sql/#findComment-1396420 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.