[SOLVED] how do i keep line breaks with this code

[ricmetal]

hey,

how do i keep line breaks using these code lines?

 

inserting intot the db

$var = mysql_real_escape_string($prevar);

 

outputting from the db

$var = stripslashes($varFromDb);
$var2 = htmlspecialchars($var, ENT_QUOTES);

 

?

 

thanks

[Mr.Shawn]

Perhaps you can try this method

 

str_replace('<br>', '<br>', $var);

[Mark Baker]

Insert the code into the DB without trying to change line breaks.

 

When you subsequently retrieve it from the DB, and want to display it, use the nl2br() function

[Mr.Shawn]

So if we use the nl2br() function, the function itself will change \n to <br>?

[Yesideez]

Correct but not <br> but to <br />

[ricmetal]

Insert the code into the DB without trying to change line breaks.

 

When you subsequently retrieve it from the DB, and want to display it, use the nl2br() function

 

when i insert the data to the db without changing line breaks the db is populated with a <br>

 

when retreiving, the <br> stays and doesnt perform a line break, when using the nl2br() function

 

@mr shawn

i never get those chars to replace in the first place

[irkevin]

can you post the actual code you have plz?

[Mr.Shawn]

@ricmetal

 

that method would only work after you had use htmlspecialchars() function. It is just to replace the special chars back to tags.

[ricmetal]

@ricmetal

 

that method would only work after you had use htmlspecialchars() function. It is just to replace the special chars back to tags.

 

but after htmlspecialchars, the special chars are changed to tags...and the tags aren't rendered. i dont know why.

 

please help

 

[ricmetal]

okay, i got it.

it works fine with using nl2br after using the htmlspecialchars.

 

ps. i failed to see that i was fetching some data to insert to the db from innerHtml, so the br tag was appearing in the db on those data fields.

 

[MadnessRed]

okay, i got it.

it works fine with using nl2br after using the htmlspecialchars.

 

ps. i failed to see that i was fetching some data to insert to the db from innerHtml, so the br tag was appearing in the db on those data fields.

 

 

becuase < is changed to < so you will see the tags