Re:A guide to preventing SQL injection
by randallsquared on Tuesday September 15, 2009 @02:36PM
(#824445)
If you're using PDO, it's usually going to be easier to do:
$stmt = $dbh->prepare( 'SELECT foo, bar from fooBar where foo = ?' );
$stmt->execute($foo);
The only case where using named parameters is really useful is when there are so many parameters you're reduced to counting question marks.
$stmt = $dbh->prepare( 'SELECT foo, bar from fooBar where foo = :fooValue' ); $stmt->bind( ':fooValue', $foo ); $stmt->execute();