I want to save html-formatted text to database, but when I do that it is don’t save html-symbols like < / > ‘ and others This is how I read article from database for editing:
<p class="Title">Англійський варіант:</p> <textarea name="EN" cols="90" rows="20" value="<?php echo htmlentities($articleArr['EN'], ENT_QUOTES, "UTF-8"); ?>" ></textarea>
after this generates such html-code:
<p class="Title">Англійський варіант:</p> <textarea name="EN" cols="90" rows="20" value="<p class='Title'> привыт </p>" ></textarea>
So, I expect that this text will appear in my text field, in html-code of this page it is, but in text area is no.
In database I save it as:
<p class="Title"> Hello </p>
So how can I do the follow:
- Read from database html-formattedtext.
- Show it in textarea element.
- Edit and save it back to database.
Help me please, how can I save such texts properly, Thanx!
Advertisement
Answer
Try using htmlspecialchars()
on the string to put into the DB, and then, when pulling it back out, use htmlspecialchars_decode()
. Might make a difference.