Posted by StreetGifts on 01/12/07 16:30

Thanks ... issue I have is users are submitting HTML code with text and
simple words like "can't", "won't" and similar words are problematic -
thanks

"J.O. Aho" <user@example.net> wrote in message
news:50pqn8F1gllqfU1@mid.individual.net...
> 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]