How to avoid to display this error in PHP?

by

Adding this “@” is a most stupid thing a developer can do ever.
You are confusing the error message with the error itself. You have to fix the error, not the message.

To fix this one, you have to use IGNORE keyword in your query

INSERT IGNORE INTO ...

Quite ironically, you actually should remove the die() statement, but only to replace it with way more reliable and safe trigger_error(), so, the code should be

$result = mysql_query($query) or trigger_error(mysql_error()." in ".$query);

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. How Secure Is This Login System? (Using Cookies In PHP)
  3. Commands out of sync; you can’t run this command now
  4. Get table column names in MySQL?
  5. PHP code to convert a MySQL query to CSV [closed]
  6. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  7. Use bound parameter multiple times
  8. The holy grail of cleaning input and output in php?
  9. MySQL: Select Random Entry, but Weight Towards Certain Entries
  10. Multiple mysql INSERT statements in one query php [duplicate]
  11. how safe are PDO prepared statements
  12. How to join three table by laravel eloquent model
  13. Secure files for download
  14. Hiding true database object ID in url’s
  15. Mysql No connection could be made because the target machine actively refused it
  16. How to connect to MySQL database in PHP using mysqli extension?
  17. MySQL – Access denied for user [duplicate]
  18. Calling stored procedure with Out parameter using PDO
  19. When *not* to use prepared statements?
  20. org.json.JSONException: Value
  21. PHP Check for NULL
  22. How to display an BLOB image stored in MySql database?
  23. How to store .pdf files into MySQL as BLOBs using PHP?
  24. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  25. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  26. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  27. PHP 7 RC3: How to install missing MySQL PDO
  28. mysql_connect VS mysql_pconnect [closed]
  29. mysql_fetch_array skipping first row
  30. 500 Internal Server Error?

Leave a Comment