SQL injection & prepared statements
| From: | Gerard Samuel | Date: | Fri, 25 Jun 2004 14:30:43 +0000 |
| Subject: | SQL injection & prepared statements | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34957@lists.php.net to get a copy of this message | ||
Just looking for opinions on sql injection while using prepared statements.
I've read at the oci8 extention that content should not be "escaped"
---
Do not use magic_quotes_gpc or addslashes() and oci_bind_by_name()
simultaneously as no quoting is needed and any magically applied quotes will
be written into your database as oci_bind_by_name() is not able to
distinguish magically added quotings from those added intentionally.
---
I've also been told something similar to this from the author of the ODBTP php
extention (http://odbtp.sourceforge.net/).
So Im guessing that this is how "prepared" statements are done on other
databases.
After being trained to do it one way (always escaping "bad" content), Im being
shown to do it the other way, and Im looking for any suggestions you may
have.
Thanks.