PDO Prepare statement not processing parameters
Posted
by Danten
on Stack Overflow
See other posts from Stack Overflow
or by Danten
Published on 2010-03-12T17:27:56Z
Indexed on
2010/03/12
17:37 UTC
Read the original article
Hit count: 196
I've exhausted all efforts at what appears to be a trivial problem, but gotten nowhere.
There is a simple Prepare statement:
$qry = $core->db->prepare("SELECT * FROM users WHERE email = '?'");
$qry->execute(array('[email protected]'));
However, no rows are returned. Running the query with the parameters hardcoded into the query results in a successful selection of one row. I've tryed many different methods of doing the prepare, but even it this most simple form it isn't working.
The PDO object is stored in a singleton called Core. PDO is using the mysql driver.
© Stack Overflow or respective owner