Retaining paragraphs in MySQL

Anon

I'm inputting text that has multiple paragraphs into my MySQL database via a web form. However, when I retrieve the text it eliminates the paragraph breaks and just prints it out into one big paragraph.

Is there someway to retain those paragraph breaks without having to type the tags in my web form?

siwis

use:

$text = nl2br($text);

That will insert line breaks where new lines are started in your text box.

siwis

for true paragraphs (not line breaks) I do the following (assuming $text is the value of your paragraphs variable.

$text = nl2br($text);
$text = "$text";
$text = str_replace(" ", "", $text);

This effectively starts by turning \n newline characters into single line breaks, then it appends a paragraph tag to the start and an end para tag to the end, and then finally replaces all those lovely tags inserted by nl2br() into end para and start para tags.
Fortunately, most browsers will ignore an empty tag, plus as you are replacing your generated tags and not any manually inserted tags, your hand coded new line formatting will be retained. HTH