Escaping queries in php using InterBase
| From: | Yves Glodt | Date: | Wed, 22 Aug 2001 12:32:24 +0000 |
| Subject: | Escaping queries in php using InterBase | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11648@lists.php.net to get a copy of this message | ||
Hello,
I'm in trouble with my current project which uses Interbase as backend.
(php.ini: magic_quotes_sybase = On)
When I insert a string containing a ', like Beverly D'Angelo,
php saves it with two '
When I insert it with two ', it gets saved with four '
Short: php multiplies all the ' by factor 2.
e.g.:
Select after inserting the string:
Beverly D''Angelo
Select after first update
Beverly D''''Angelo
Select after second update
Beverly D''''''''Angelo
Select after third update
Beverly
D''''''''''''''''Angelo
What can I do?
I do not want to write an ugly function to handle this, isn't there
something php/ib-native
thank you,
yves