Pull text from MySql database and split it in paragraph on website

Can I just insert formated text into database and retrieve it as that? Should formating ( like new line ) appear on website after pulled from dat开发者_运维技巧abase? I have tried it and it seems that is not case.

How to accomplish that?

Thanks

If you want it to be formatted as is inserted in the database you could output it to a <pre> tag to preserve formatting. If you just want to have the newline replaced by a html tag, you can do that easily:

<?php

//be on the safe side, as suggested by Christian Sciberras
$sanitized = htmlspecialchars($databaseContent, ENT_QUOTES);

echo str_replace(array("\r\n", "\n"), array("<br />", "<br />"), $sanitized);

Why?

I use str_replace() in this case to show you how it's done. I usually don't replace the new line with a break but with a </p><p> (and this is why I didn't go for a nl2br() solution) If you think you'd want paragraphs instead of line breaks, just change the replacement.

there is method in php that will convert all \n to <br> so you will have new lines in your html file

string nl2br ( string $string [, bool $is_xhtml = true ] )

$is_xhtml menans if your page is XHTML then new lines will be converted to <br/> otherwise just <br>

I hope this helps