With PDO, how can I make sure that an UPDATE statement was successful?

Viewed 28405

It seems that for an INSERT statement, one can use if (isset($connect->lastInsertId())) in order to check whether the INSERT statement was successful. (Please correct me if I'm wrong.)

But for an UPDATE statement, how can I know if it was successful?

For example, I have basic one like that:

$statement=$connect->prepare("UPDATE users SET premium='1' WHERE userid=?");
$statement->execute(array($id));

Thanks a lot in advance. Regards

2 Answers
Related