Using PDO with INSERT (PHP)

I've got

$sql = $db->prepare("INSERT INTO `aliases` (`alias`, `domain`, `added`, `enabled`) VALUES (:alias, :domain, :added, :enabled)");
$sql->bindValue(':alias', $alias);
$sql->bindValue(':domain', $domain);
$sql->bindValue(':added', time());
$sql->bindValue(':enabled', 1);
$sql->exe开发者_JAVA百科cute();
//how do I test if it was added or #1062 - Duplicate entry '...' for key 'alias'

I assume that's correct.

My question is: How do I test if it was added successfully?

---

You can check the return value of $sql->execute(), like this:

if ($sql->execute()) {
    // Query succeeded.
} else {
    // Query failed.
    $errorcode = $sql->errorCode();
}

For more information, see the documentation for PDOStatement (the class of prepared statements).

---

See the docs about PDO Error handling and this comment

By default you have to check the return of execute. Details can then be found in errorinfo() and errorcode()

if ($sql->execute === false) {    //check return, false on error
     var_dump($sql->errorinfo();  //array containing information on error
     die()
}

But I would recommened using PDO::ERRMODE_EXCEPTION so that a PDOException is thrown on error. This makes your code a bit neater. The basic information is provided by the exception's __toString() but further information can be found (using an exception's normal methods, see link to docs above).

$db = new PDO( /* your connection string */ );
$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
try {
    $sql = $db->prepare("INSERT INTO `aliases` (`alias`, `domain`, `added`, `enabled`) VALUES (:alias, :domain, :added, :enabled)");
    $sql->execute();
}

catch(PDOException $e) {
    echo $e;             //basic information is provided due to Exception::__toString()
    die();
}

---

if ($stmt->errorCode() == "00000")  {
  // Query succeeded.   
} else {
  // Query failed.
  echo "Error: " . $stmt->errorCode();
}