Re: Help with escaping the # sign
| From: | Richard Lynch | Date: | Sat, 22 Sep 2001 02:35:05 +0000 |
| Subject: | Re: Help with escaping the # sign | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68250@lists.php.net to get a copy of this message | ||
It's a MySQL issue, probably.
Addslashes() should take care of it, I think...
If not, find out how MySQL escapes # and use http://php.net/str_replace
--
WARNING richard@zend.com address is an endangered species -- Use
ceo@l-i-e.com
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: John Holcomb <john_6932php@yahoo.com>
Newsgroups: php.general
To: <php-general@lists.php.net>
Sent: Tuesday, September 18, 2001 3:36 PM
Subject: Help with escaping the # sign
> I have a text input field in my form. I need the user
> to be able to enter something like: Hello, I need #
> help. After which they click on a submit button. The
> succeeding page then takes this text and tries to
> display it and tries to store "Hello, I need # help"
> in a varchar field in a mysql table column. The
> mysql database is truncating the # sign and the text
> succeeding the # sign. Also, absolutly no text is
> being diplayed on the succeeding web page. I've tried
> using addslashes() and I was warned against using
> htmlentities(). Also, I'm not sure if I'm dealing
> with 2 issues: A mysql issue and a html issue. Or, am
> I dealing with one issue: A mysql issue or an HTML
> issue.
>
> Thank you,
>
> John
>
> __________________________________________________
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Information/