Store HTML code in the database?

Question

I’m developing a script retrieving codes HTML from a form, and then store in the database. However I would like to store the code in the base as it was inserted into the form, with the tags, style, classes, etc...

OBJECTIVE :

• For example, if I store the code

  <div style='color:red;'>Meu texto</div>

When reading this information (with PHP for example : echo $informacoes_da_base) would like to get as a result "My text" in red.

PROBLEM :

• Tags are being interpreted as soon as they arrive at the base. Ex. : &lqt;code &lql;

• When reading the information in base ex.: echo $informacoes_da_base I get on the screen unwanted characters.

I did some research on mysql_escape_string and html_entity_decode but I cannot achieve the desired results.

echo html_entity_decode($infos_da_base);

echo mysql_escape_string($infos_da_base);

CODE :

if(isset($_POST['enregistrer'])){

  Configuration::updateValue('DESCRIPTION_TIME_DELIVERY', $_POST['description']);

}

<form>
   <textarea style="width: 200px;">
       <code style='color: red;'>codigo html aqui</code>
   </textarea>
</form>

Answer 1

Use htmlentities() to encode this character and then the tags will look like this: </img> this coding is: <img/>, That’s just saving it in the comic book. At the time of returning this data if you are going to throw them directly into the DOM then you do not need to pass function to decodes because the browser already does this, now if you are going to put it inside some input or textarea pass before in function html_entity_decode() to return the original characters.

Summary:

<?php
$a = htmlentities('<img/>'); //Retorno "&lt;/img&gt;"
$b = html_entity_decode($a); //Retorno "<img/>"