PHPScriptor wrote:
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?
I run all text area through a filter that removes the carriage return [ preg_replace('/\r/','',$input) ] and save it in the database with any newline characters.
When calling data from the database, I can then use newline as a delimiter for explode generate an array where each element of the array is a distinct line of text - and then do whatever I want with the lines.
Effectively what I usually do is the same thing as nl2br - but since I do everything in DOMDocument I have to do it myself (create text nodes for each array element and create break nodes between them).
If I'm going to a pre field or back to a text area (IE to edit the data) then I don't have to do anything.
I do NOT recommend running nl2br before it goes into the database - as that means you may have to convert the breaks when re-using the data elsewhere, and the proper way to make a break depends upon the output type (IE <br> for html or <br /> for xhtml, etc.) - so keep the newline character in the database and convert to what you need when you call the data from the database.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
