No error is thrown on inexistant table

Question

I must miss something but I have a very strange behaviour with PDO (MySQL).

$req = null;
try {
    $sql = 'INSERT INTO inexistant_table (idmember) VALUES(:idmember)';
    $req = $db->prepare($sql);
    $req->bindParam(':idmembre', $_SESSION['ID']);
    $req->execute();
}
catch (PDOException $e) {
    echo 'exception';
}

if( !$req ) {
    echo 'false';
}
echo 'success';

Then I don't get any error, it only prints 'success'. Any idea?

EDIT: $db->errorCode() returns 00000.

http://stackoverflow.com/questions/15990857/reference-frequently-asked-questions-about-pdo#15990858 — Your Common Sense, May 07 '14 at 18:59
You've made a typo: `VALUES(:idmember)` and using `(':idmembre',` change it to `(':idmember',` — Funk Forty Niner, May 07 '14 at 18:59
Use `$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);` right after the connection is opened — Funk Forty Niner, May 07 '14 at 19:01
^--« My work is done. No need to thank me. It's a "thankless" job anyway. — Funk Forty Niner, May 07 '14 at 19:02
Yes, it works. I don't get why that's not the default behaviour. Thank you, even if you don't accept it. :) — Arthur, May 07 '14 at 19:05

score 2 · Accepted Answer · edited May 23 '17 at 12:20

2

The outcome is explained as such,

Exceptions are not enabled - no "exception"

To enable exceptions, as per Fred -ii-'s comment, thanks! ;-)

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

(Also see Reference - frequently asked questions about PDO)

The wrong value is being checked - no "false"

The $req variable represents the prepared statement object, not the result of such executing such a statement. Compare with the following that checks the result.

$result = $req->execute();
// ..
if (!$result) { /* fail! */ }

edited May 23 '17 at 12:20

Community

1
1

answered May 07 '14 at 19:05

user2864740

60,010
15
145
220

1

Thanks for the mention. I will +1 and get OP to accept as the correct answer just so we can close this. – Funk Forty Niner May 07 '14 at 19:10
Thanks for pointing out the other bug. Going to close this when SO let me. – Arthur May 07 '14 at 19:10

No error is thrown on inexistant table

1 Answers1

Exceptions are not enabled - no "exception"

The wrong value is being checked - no "false"