How to handle error for duplicate entries?

by

To check for this specific error, you need to find the error code. It is 1062 for duplicate key. Then use the result from errno() to compare with:

mysqli_query('INSERT INTO ...');
if (mysqli_errno() == 1062) {
    print 'no way!';
}

A note on programming style
You should always seek to avoid the use of magic numbers (I know, I was the one to introduce it in this answer). Instead, you could assign the known error code (1062) to a constant (e.g. MYSQLI_CODE_DUPLICATE_KEY). This will make your code easier to maintain as the condition in the if statement is still readable in a few months when the meaning of 1062 has faded from memory 🙂

More Related Contents:

  1. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  2. Outputting all PHP errors to database not error_log
  3. Can I detect and handle MySQL Warnings with PHP?
  4. How do I ensure I caught all errors from MySQLi::multi_query?
  5. PHP DateTime supported formats
  6. Can I call a PHP function in a JavaScript click handler?
  7. How to create a chat program using php and mysqli for chatting [closed]
  8. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  9. Can I store images in MySQL [duplicate]
  10. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  11. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  12. Why is using a mysql prepared statement more secure than using the common escape functions?
  13. localhost vs. 127.0.0.1 in mysql_connect()
  14. iPhone emoticons insert into MySQL but become blank value
  15. Inserting into MySQL from PHP (jQuery/AJAX)
  16. Selecting all columns that start with XXX using a wildcard?
  17. How to delete mysql row after time passes?
  18. Echo menu tree with recursive function
  19. How to select multiple rows from mysql with one query and use them in php
  20. php run once and insert twice in mysql database
  21. Laravel nested relationships
  22. getting the value of an extra pivot table column laravel
  23. php sample script for pagination [closed]
  24. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  25. Create PHP array from MySQL column
  26. UNION syntax in Cakephp
  27. How do I format numbers to have only two decimal places?
  28. How do i search from serialize field in mysql database?
  29. Group mysql results by category and display them into groups under each category
  30. PHP & mySQL: When exactly to use htmlentities?

Leave a Comment