Querying PDO with OCI

Question

I have set up everything to work with PDO_OCI. I have made a connection too. But as soon as I try to fetch something it returns false or null always:

$selectBla = "SELECT bla,bla,bla
                                 FROM bla
                                 WHERE blabla = ?
                                 AND bla = ?";
$parameters = array($_POST['bla'], $_POST['bla']);
$query = $db->prepare($selectBla);
$query->execute($parameters);
$userRow = $query->fetch(PDO::FETCH_ASSOC);

Does anybody have a idea? Does it have to do with OCI_PDO?

Thanks in advance.

http://stackoverflow.com/questions/3726505/how-to-squeeze-error-message-out-of-pdo — Your Common Sense, Apr 03 '14 at 09:48
PDO does not display errors by default. That's true no matter the driver. — Álvaro González, Apr 03 '14 at 09:48
seems fine to me. maybe you don't have data... can we see some true data? — CodeBird, Apr 03 '14 at 09:48
Thanks this showed me some helpful errors `$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );` — Daan, Apr 03 '14 at 09:51

score 0 · Accepted Answer · answered May 28 '14 at 09:29

0

I added this line to see the error messages and I got one after that I easily solved the problem.

$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );

answered May 28 '14 at 09:29

Daan

12,099
6
34
51

Querying PDO with OCI

1 Answers1