0

I have a simple insert program containing a RichTextEditor, which does nice formatting to the text and then stores it in the database.

When I store this in the database table it gets stored along with html tags.

But when I would want to do a select over the records from the same table, I get it in different format:

for example if from my richeditText, I had stored

<p>hello</p>

when I do a select I get it as

 &lt;p&gt;hello&lt;/p&gt;

how do I render this as html?

Martijn
  • 13,225
  • 3
  • 48
  • 58
shridatt
  • 896
  • 4
  • 15
  • 39

1 Answers1

0

The most serverside languages have builtin functions to do this kind of conversion,

with PHP: http://php.net/manual/en/function.htmlentities.php

with Javascript: Convert HTML Character Entities back to regular text using javascript

MySQL: is there a mysql function to decode html entities?

Community
  • 1
  • 1
Antonio Ragagnin
  • 2,278
  • 4
  • 24
  • 39