HTML tags in database

[mikawhat]

Hi ppl,
I'm using WYSIWYG editor to add some contents into database. When i add the contents in the database they are displayed the same way as when i write them in the editor, however i want them to be displayed with html tags. e.g i don't want them saved in the db as 'text' but as '<p>text</p>'. How can i do that?
$text = htmlspecialchars($text) before adding contents into the db should be working?

[thorpe]

All input is saved as is unless you strip characters out. How is the html getting in your data?

[mikawhat]

is saved exactly as it is (without tags) and it is also displayed as it is.

[thorpe]

however i want them to be displayed with html tags

What html tags? Maybe [man]nl2br[/man] is what your looking for? Otherwise, you'll need to be clearer in your explination.

PS; You use nl2br when displaying data, not when saving it.

[mikawhat]

ok, is like that... when i save the data, in the db they are displayed as 'Sample text'. In the page when i call those data they are also displayed as 'Sample text'. What i want, is to save them in the db as '<p>Sample text</p>', and display them in a page again as 'Sample text'. I want to do that because of the styling i'm using for <p>..

[thorpe]

Look. Its simple. Strings are saves AS IS to the database.

<?php
  // connect
  $str = "<p>here is a paragraph</p>";
  if (mysql_query("INSERT INTO tbl VALUES ('$str')")) {
    echo "success";
  }
?>

This saves the string <p>here is a paragraph</p> into the database.

Once again I ask.... where are these html tags coming from? Maybe you want something like...?

"INSERT INTO tbl VALUES ('<p>$str</p>)"

Really... I have no idea what your talking about.

[mikawhat]

i'm using WYSIWYG editor which is actually a textarea, just like this textarea you are posting here. You can't see any tags, but there are right? so, can i save the text with the tags in the database?

[thorpe]

Ahhh.... now I see. hehe.

How are you saving the data now?

What happens if you echo the posted vars firstly to see if the html is still there? Seems strange any WYSIWYG editor would strip the html out of the POST.