Re: [PHP-DB] characters - URGENT!!!
["Selvin Sakal" <[EMAIL PROTECTED]>] > Hi, > i have a mysql database, can anyone tell me any characters that cannot > be entered into mysql (like !@#$%, etc). > > Also i have a string and i would like to remove html tags, characters > (like ~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i > want the string to be just left with words. Try the manual: http://php.net/manual/en/function.addslashes.php (for mysql) http://php.net/manual/en/function.strip-tags.php - Stig -- Stig Sæther Bakken <[EMAIL PROTECTED]> Fast Search & Transfer ASA, Trondheim, Norway -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] characters - URGENT!!!
i'm sure this is taken car od in the php string handling functions. couldn't you 'clean' them up prior to when you insert them ? steve > -Original Message- > From: Selvin Sakal [mailto:[EMAIL PROTECTED]] > Sent: 24 May 2001 12:44 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] characters - URGENT!!! > > > > Hi, > i have a mysql database, can anyone tell me any characters > that cannot be > entered into mysql (like !@#$%, etc). > > Also i have a string and i would like to remove html tags, > characters (like > ~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i > want the string > to be just left with words. > > any help would be helpful, > > Thanks > Selvin > > P.S. this is urgent i need this very quickly > __ > ___ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] characters - URGENT!!!
Hi, i have a mysql database, can anyone tell me any characters that cannot be entered into mysql (like !@#$%, etc). Also i have a string and i would like to remove html tags, characters (like ~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want the string to be just left with words. any help would be helpful, Thanks Selvin P.S. this is urgent i need this very quickly _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]