Turning query errors to Exceptions in MySQLi [duplicate]

by

Some time ago I managed to sort this matter out. As it was pointed out in the other answer,

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

is a correct way to tell mysqli to throw exceptions.

Just make sure you don’t wrap every query in a try-catch. This is a very common misconception that as soon as you started using exceptions you should start throwing tries and catches left and right. Quite contrary, try-catch should be used warily. While 99% of your errors shouldn’t be handled in place, but rather by a site-wide error handler. You may read more on the topic from my article on PHP error reporting

More Related Contents:

  1. PHP create new array by value
  2. two person chat room
  3. Insert Mutiple Record into Database Using Php Mysql
  4. How to display errors for my MySQLi query? [duplicate]
  5. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  6. Bind multiple parameters into mysqli query
  7. Example of how to use bind_result vs get_result
  8. mysqli::query(): Couldn’t fetch mysqli
  9. Fatal error: Call to a member function fetch_assoc() on a non-object [duplicate]
  10. get array of rows with mysqli result
  11. How to start and end transaction in mysqli?
  12. How to install MySQLi on MacOS
  13. How do I iterate over the results in a MySQLi result set?
  14. PHP MySQLI Prevent SQL Injection [duplicate]
  15. The mysqli extension is missing. Please check your PHP configuration
  16. How to test if a MySQL query was successful in modifying database table data?
  17. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  18. PHP Commands Out of Sync error
  19. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  20. $stmt->execute() : How to know if db insert was successful?
  21. Using wildcards in prepared statement – MySQLi
  22. bind_param Number of variables doesn’t match number of parameters in prepared statement
  23. Fatal error: Call to a member function close() on a non-object. MySQLi issue
  24. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? [duplicate]
  25. PHP prepared statements and transactions in a loop [duplicate]
  26. Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
  27. Mysqli multiple row insert, simple multi insert query [duplicate]
  28. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]
  29. check if the query returns zero rows [duplicate]
  30. Single Result From SUM With MySQLi

Leave a Comment