Saving HTML into the Database / SQL

Question

when I save html code with php in the database, the html code looks like:

& lt ; b & gt ; (for <b>)

I know they are special characters. When I want to display it with echo, I have to decode it with:

html_entity_decode($test);

How can I save the html without specials chars so that I wouldn't need the html_entity_decode?

Thank you.

Use preg_replace to remove the special characters. See stackoverflow.com/questions/657643/… — Steven Liao
– Steven Liao, Commented Sep 5, 2013 at 8:41
Where is this HTML code coming from? There is no reason for the database layer to escape HTML special characters. — Brenton Alker
– Brenton Alker, Commented Sep 5, 2013 at 8:50

symcbean · Accepted Answer · 2013-09-05 09:03:29Z

1

when I save html code with php in the database....

No you seem to be saving HTML encoded HTML code. So given some HTML code you are currently encoding it as html (htmlspecialchars()), encoding it for insert (via mysql[i]_real_escape_string() or parameter binding) into the database and de-encoding it on retrieval - just skip the extra encoding.

answered Sep 5, 2013 at 9:03

symcbean

48.4k6 gold badges63 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving HTML into the Database / SQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related