Posted by J.O. Aho on 01/12/07 16:18

StreetGifts wrote:
> What would be the best advice for storing HTML data in to a MySQL database?
>
> I've tried using 'htmlspecialcharacters' and 'htmlentities' for converting
> before storing in to db, but when converting back, am always having issues
> displaying the single quote properly ( ' )
>
> I want to be able to save HTML tags & content in to db. Using 'TEXT' as
> field type.
>
> Am able to save, retrieve and display back to browser, but am having
> difficulties w/ the single ' quote issue

This is not a solve for your problem, but I would advice you to use double
quotes in html tags, even if single quotes are valid, there are browsers that
don't handle single quotes properly, but the same tags with double quotes
works fine.

--

//Aho

[Back to original message]