Re: Escaping queries in php using InterBase
| From: | Patrik Wallstrom | Date: | Wed, 22 Aug 2001 12:34:48 +0000 |
| Subject: | Re: Escaping queries in php using InterBase | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11649@lists.php.net to get a copy of this message | ||
On Wed, 22 Aug 2001, Yves Glodt wrote:
> 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 '
[...]
I have always wondered why there is no mysql specifig quoting functions in
php. Here is what I use:
function myslashes($content = "") {
$content = str_replace("\\","\\\\",$content);
$content = str_replace("'","\\'",$content);
return $content;
}
I guess Interbase also uses backslash for quoting?
--
patrik wallstrom | f o o d f i g h t
tel: +46-8-6188428 | s t o c k h o l m
gsm: +46-709580442 | - - - - - - - - -