PDO mysql: How to know if insert was successful

Question

I'm using PDO to insert a record (mysql and php)

$stmt->bindParam(':field1', $field1, PDO::PARAM_STR);
$stmt->bindParam(':field2', $field2, PDO::PARAM_STR);
$stmt->execute();

Is there a way to know if it inserted successfully, for example if the record was not inserted because it was a duplicate?

Edit: of course I can look at the database, but I mean programmatic feedback.

Answer 1

execute() returns true on success. There is also PDOStatement->errorCode() which you can check for errors.

Answer 2

Try looking at the return value of execute, which is TRUE on success, and FALSE on failure.

Answer 3

You should check whether the statement executed successfully as others have said. You can also use PDOStatement::rowCount() to get the number of rows affected by a query:

PDOStatement::rowCount() returns the number of rows affected by the last DELETE, INSERT, or UPDATE statement executed by the corresponding PDOStatement object.

If the last SQL statement executed by the associated PDOStatement was a SELECT statement, some databases may return the number of rows returned by that statement. However, this behaviour is not guaranteed for all databases and should not be relied on for portable applications.

http://www.php.net/manual/en/pdostatement.rowcount.php