Thanks for the reply.
I would imagine there are a lot of special html characters that would
need to be changed using regex. Therefore, spending my time making a
regex to find a replace each one of them isn't a good way to spend my
time or even if I did go that route I'm sure it's uses too much system
resources to search for and replace all the characters. The reason I
say that is what if a user does a search on the database and the
database is filled with all these special characters. Sure I could
htmlspecialchars() the string that is passed to the search and then run
the sql to the DB for the query. However, does htmlspecialchars()
account for all special characters? Then you have to account for the
extra space the htmlspecialchars() is going to put in your DB and other
issues that might arise from that.
Does anyone know the common practice for this? Or is it just
preference?
Thanks,
jay
On Aug 22, 2005, at 8:42 AM, Jay Blanchard wrote:
[snip]
I have a problem that I'm sure some of you have run into before,
therefore I hope you all know of an easy solution. Some of my users
are cutting and pasting text from Word into text fields that are being
saved into a database then from that database being displayed on a web
page. The problem occurs when some special characters are being used.
Double quotes, single quotes, and other characters like accents etc
have the special html code like "e; etc replacing the special
characters. What methods are being used to combat this issue? Is
there a solution out there to run text through some sort of filter
before submitting it to the database to look for these special
characters and then replacing them?
[/snip]
Start here http://www.php.net/htmlentities . You can also use any
number
of REGEX functions for replacing them http://www.php.net/regex
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php