Re: textarea new line to mysql database

Yes, I thought about that. But then you have a problem when you're going to 'edit' that data back in a form. Then you get "first line<br />second line" in your textarea. Manoj Sterex wrote: > > Well, instead of storing the text from the textarea directly into the db, > validate it and wrap it with <br /> tags (replace \n) and then store it. > This way you needn't use nl2br every time you retrieve the text from db. > > -Sterex > > > On Fri, May 15, 2009 at 7:42 PM, Stuart <stuttle@gmail.com> wrote: > >> 2009/5/15 PHPScriptor <contact@phpscriptor.com>: >> > >> > Hello, >> > >> > How do you guys handle this "problem". >> > >> > Just a form with a textarea. When I use enters in the textarea it's >> saved >> to >> > the db like this: >> > >> > database: >> > "first line >> > second line" >> > >> > when I edit the value in the form: >> > "first line >> > second line" >> > >> > when I output the value to html: >> > "first linesecond line" (unless I use nl2br()) >> > >> > Is there a way that I could save it to the db that will work for db, >> output >> > and edit without using any other function like nl2br? >> >> What's your problem with using nl2br? This is the reason it exists!! >> >> Store the raw data in the database, and run nl2br on it when you >> display it. I don't see a "problem". >> >> -Stuart >> >> -- >> http://stut.net/ >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > ----- visit my website at http://www.phpscriptor.com/ http://www.phpscriptor.com/ -- View this message in context: http://www.nabble.com/textarea-new-line-to-mysql-database-tp23560478p23560882.html Sent from the PHP - General mailing list archive at Nabble.com.