How to tell when query executed successfully in PHP PDO? [duplicate]

Question

How can I test to see if the following query executed successfully?

$STH = $this->_db->prepare("UPDATE UserCreds SET     VerificationString=:newVerificationString, ExpiryDate=:expiryDate      WHERE UserID = :userID;"); $STH->execute($params); 

I know I can use lastInsertId() when I'm adding new rows, but what about UPDATEs and SELECTs?

Answer 1

The execute returns true on success and false on failure.

From Docs:

Returns TRUE on success or FALSE on failure.

---

So you can make sure query ran successfully like:

if ($STH->execute($params)) {   // success } else {   // failure } 

Answer 2

execute() returns true/false based on success/failure of the query:

$status = $STH->execute($params);  if ($status) {    echo 'It worked!'; } else {    echo 'It failed!'; } 

One note: a select query which returns no rows is NOT a failure. It's a perfectly valid result that just happens to have NO results.