grabbing html data from sql database and displaying as html

[code937]

Hey guys,

Im making a stupidly simple CMS and i guess the best way to save data for each page is within an sql database. The only thing is, from past experience, when you echo data from a database it usually just echos the text (i.e. <font color="#FFFFFF" >Hello</font> instead of echoing Hello in white.

Anywho, if you think im going the wrong way about it please prod me in the right directions.

Cheers

[coffear]

If the output is valid HTML then you will get the desired output. As long of course as you have not used something like html_entities.

[Markus]

You're definitely right about the sql part! They're a godsend.

Anyways, it sounds like you are, indeed, using something like:

$str = "<b>html<i>html</i></b>";
$strSafe = htmlentites($str)
//enter $strSafe into DB
//or likewise with htmlspecialchars()
//you can reverse these functions with decoding
//i.e
//pull data from mysql
$res = mysql_query("query_to_do");
while($x = mysql_fetch_array($res)){
  echo html_entity_decode($x['row_name']);
   // or if you use htmlspecialchars() :
  echo htmlspecialchars_decode($x['row_name']);
}
 

Hope this helps.

Note: When decoding with htmlentities() remember it's html_entity_decode

:)

[code937]

markusn00b, thanking you kindly! useful post and i think its exacly the bit of code i asked for, ill test it in a bit :)

Thanks !!!!!

[Markus]

markusn00b, thanking you kindly! useful post and i think its exacly the bit of code i asked for, ill test it in a bit :)

Thanks !!!!!

Absolutely no problem code937.

S'what we're here for.

Post back if you need more help!

-markus