On Jul 16, 2009, at 12:00 PM, Troy Oltmanns wrote:
Hey guys and gals,
I have a little tricky situation so I will explain as best as I can.
I've got a form that loads and saves product data to mysql. In some
fields
like the heading and subhead we use special characters like Omega,
Registered Trademark, and Ampersand. When putting the data in I will
encode
them as Ω, etc. Once saved, all is good, everything goes ok
and will
display correctly in the user interface. However, if I go back to
edit that
product, in the html input element, it will actually display the
character
rather than the entity code (although when checking the source, the
html
entity is coded correctly). Then when it is saved, it saves as the
illegal
character and will serve up a few funky characters in the user
interface and
in the database.
I have the code stripping out tags and I tried to use the
mysql_real_escape_string to no avail.
Anyone have experience with this kind of thing?
PHP Version 5.1.6*MySQL 5.0.19*
------------
Govinda
govinda.webdnatalk@xxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
