Subject | PHP and apostrophe-related question |
---|---|
Author | evan@exclusivebooks.com |
Post date | 2003-11-07T08:27:40Z |
Hi
I am having trouble querying Firebird for data that may contain apostrophes
from PHP. I think the problem may be with the PHP interbase functions, and
wonder if anyone has any experience of doing this?
Escaping the apostrophe with a backslash at the PHP level doesn't help
(Firebird doesn't recognize the escape sequence).
I have eventually managed to enclose the literal containing the apostrophe
in double quotes at the PHP level, but now Firebird thinks I'm trying to
compare two columns.
Surely this must be a common problem with a simple solution. Does anyone
know what it is?
PS: I have asked on the PHP-DB list, but the response has been poor so far.
Any help is appreciated.
Thanks
Evan Morris
evan@...
+27 11 792 2777 (t)
+27 11 792 2711 (f)
---------------------------------
Is /usr/bin/perl related to /osama/bin/ladin?
I am having trouble querying Firebird for data that may contain apostrophes
from PHP. I think the problem may be with the PHP interbase functions, and
wonder if anyone has any experience of doing this?
Escaping the apostrophe with a backslash at the PHP level doesn't help
(Firebird doesn't recognize the escape sequence).
I have eventually managed to enclose the literal containing the apostrophe
in double quotes at the PHP level, but now Firebird thinks I'm trying to
compare two columns.
Surely this must be a common problem with a simple solution. Does anyone
know what it is?
PS: I have asked on the PHP-DB list, but the response has been poor so far.
Any help is appreciated.
Thanks
Evan Morris
evan@...
+27 11 792 2777 (t)
+27 11 792 2711 (f)
---------------------------------
Is /usr/bin/perl related to /osama/bin/ladin?