php sending text to/from sql

Junior WebHelper Joined: 09 Jul 2002 Posts: 3

hi, i scanned the boards but couldnt find an answer to this.

i have my php connected to a sql db to retrieve items of text.
in my database i have text items that are nicely spaced out with returns for new lines etc.
when i retrieve this using my php script it prints out as a long string (because html doesnt recognise returns).

is there a function, or a script, that i can run on my text to replace the returns with <br> or whatever?
Either when inputting the text (using a php form) or retrieving the text from the database, or even both if needed.

it's probably really simple, i tried looking through the script for a BB but couldnt find it. I also have a problem with ' . Are there any other characters i need to be wary of?

Thanks in advance.

Posted: Tue Jul 09, 2002 8:00 am (21 years, 9 months ago)

use nl2br() function.

nl2br()
(PHP 3, PHP 4 )

nl2br -- Converts newlines to HTML line breaks
Description

string nl2br (string string)

Returns string with '<BR>' inserted before all newlines.

Team Member Joined: 06 Jan 2002 Posts: 2564

Note: in the newer versions of PHP, it will return an XHTML compliant tag (ie: <br />).

Junior WebHelper Joined: 09 Jul 2002 Posts: 3

Thanks a lot for the help, I'll give it a go Very Happy