Detect mysql update/insertion failure due to violated unique constraint

by

Now that it’s the year 2015, there are very few reasons not to be using PHP’s PDO implementation.

The proper, modern, “OO” method for detecting and handling an insertion failure due to a key constraint violation is as follows:

try {
    //PDO query execution goes here.
}
catch (\PDOException $e) {
    if ($e->errorInfo[1] == 1062) {
        //The INSERT query failed due to a key constraint violation.
    }
}

The PDOException object has a lot more to say about the specific nature of the error, too (more detail than one could possibly ever want or need, seemingly).

More Related Contents:

  1. Disappears \ from db value [closed]
  2. What to put in database columns when creating registration/login system? (xampp)
  3. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  4. How to properly set up a PDO connection
  5. Query with multiple values in a column
  6. Preserve Line Breaks From TextArea
  7. Search with comma-separated value mysql
  8. How to do this in Laravel, subquery where in
  9. How can I loop through a MySQL result set more than once using the mysql_* functions?
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. mysql PDO how to bind LIKE
  12. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  13. WAMP Cannot access on local network 403 Forbidden
  14. Does mysql_real_escape_string() FULLY protect against SQL injection?
  15. How do I give each registered user their own url using PHP?
  16. MySQL “NOT IN” query 3 tables
  17. Recursive categories with a single query?
  18. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  19. LOAD DATA LOCAL INFILE forbidden in… PHP
  20. How get all values in a column using PHP?
  21. Warning: mysql_query(): 3 is not a valid MySQL-Link resource
  22. Getting time difference between two times in PHP [duplicate]
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Is there a way to show a WHERE clause just for one field in MySQL?
  25. MySQL Stored Procedure vs. complex query
  26. Finding free blocks of time in mysql and php?
  27. When should I close a database connection in PHP?
  28. Is a BLOB converted using the current/default charset in MySQL?
  29. php connection pooling mysql [duplicate]
  30. PHP/MySQL Pagination

Leave a Comment