pSQL() filters out all html data to database? how to insert html data to database custom table

[JoelWebsites]

pSQL() filters out all html data to database...how should html data be added or updated to custom tables? Please advice thanks.

Example
 

$qur = 'UPDATE '._DB_PREFIX_.'html_content SET data_html = "'.pSQL($data_html).'" WHERE id_shop = "'.(int)$id_shop.'";';
$results = Db::getInstance()->Execute($qur);

 

How do we properly cast variables (containing html)  in our module before we submit the module to the addons store?

 

Edited January 27, 2019 by JoelWebsites (see edit history)

[tdsoft]

you can try to

pSQL(htmlentities($data_html))

Edited January 28, 2019 by tdsoft (see edit history)

[pswork]

Quote

 

you can try to

pSQL(htmlentities($data_html))

 

Ok. But when I get data from Database back to show in content how to translate it to HTML back in normal view?

[Gneston]

function pSQL($string, $htmlOK = false) 

defaults into removing html. Just call it with pSQL($data_html, true) and it should work.