How to process html data into mysql db

misheck

I am using Tinymce wysiwig for entering new data into my database so I am sending the the text from the text area straight to Mysql DB and when I try to retrieve the data its coming out as raw html and its not being processed as html. This is because when its entered into the mysql its been converted by TinyMce to html special characters.

I need to filter the data so that it still remains with the same formatting like the boldness and head font styling etc.

How to filter the data from the $_POST['mytextarea'] to eneter it into my mysql DB?

djjjozsi

do not convert the html codes into its html entities when insert into the database.
When you retrieve from the database and wanted to insert back into the textarea then use the html entities (htmlspecialchars).

misheck

Thanks for the response, but when I the data its only striping the example ='test'&gt but its not formatting tags like <b> . I think I might need a reversal of htmlspecial chars I have also tried ■htmlspecialchars_decode() and I have been to the php manual but I still cant figure out my error.