Re: mysql - image storing
| From: | Jochem Maas | Date: | Wed, 19 Jan 2005 05:49:56 +0000 |
| Subject: | Re: mysql - image storing | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38219@lists.php.net to get a copy of this message | ||
Simon Rees wrote:
On Tuesday 18 January 2005 19:18, Jochem Maas wrote:did I mention I have been using firebird and the php-extension for the last year and a half ;-)I was always under the impression that single quotes (assuming you are delineating you args with single quotes) should (officially) be escaped with another single quote - although backslash also works:I think it depends on the database that you are using. Oracle and MS-SQL both require quotes to be escaped with another quote, MySQL uses backslashes. I seem to recall that two quotes is the standard... Of course it is even better to use bind vars and then you don't need to escape the quotes (or worry about sql injection attacks)...
cheers Simon