Escaping queries in php using InterBase

From: 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

« previous php.db (#11648) next »