How to tell if PDO MySQL INSERT was successful with IGNORE

Question

I understand that I can simply if ($PDO->execute()) { //true } to see if a PDO INSERT was successful, but what if IGNORE is involved?

Eg.

INSERT IGNORE INTO MyTable SET DateTime = CAST(:dateTime AS DATETIME)

If the the record already exists, and so is ignored, will ->execute() return true or false?

I can't seem to find any documentation which tells me.

Answer 1

Try:

$stmt->execute();
$stmt->rowCount();

That will tell you how many rows were affected by the last query.

Answer 2

I thought this would garner me a quick answer, but it didn't, so I tested it myself:

If no records are altered as a result of the IGNORE statement, then ->execute() still returns true. It will only return false if there's an error.