Can I detect and handle MySQL Warnings with PHP?

by

For warnings to be “flagged” to PHP natively would require changes to the mysql/mysqli driver, which is obviously beyond the scope of this question. Instead you’re going to have to basically check every query you make on the database for warnings:

$warningCountResult = mysql_query("SELECT @@warning_count");
if ($warningCountResult) {
    $warningCount = mysql_fetch_row($warningCountResult );
    if ($warningCount[0] > 0) {
        //Have warnings
        $warningDetailResult = mysql_query("SHOW WARNINGS");
        if ($warningDetailResult ) {
            while ($warning = mysql_fetch_assoc($warningDetailResult) {
                //Process it
            }
        }
    }//Else no warnings
}

Obviously this is going to be hideously expensive to apply en-mass, so you might need to carefully think about when and how warnings may arise (which may lead you to refactor to eliminate them).

For reference, MySQL SHOW WARNINGS

Of course, you could dispense with the initial query for the SELECT @@warning_count, which would save you a query per execution, but I included it for pedantic completeness.

More Related Contents:

  1. Reference – What does this error mean in PHP?
  2. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  3. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  4. Outputting all PHP errors to database not error_log
  5. How to handle error for duplicate entries?
  6. How do I ensure I caught all errors from MySQLi::multi_query?
  7. How to use mysqli prepared statements?
  8. How do I get PHP errors to display?
  9. PHP MySQL Google Chart JSON – Complete Example [closed]
  10. pdo prepared statements with wildcards
  11. I cannot get my login form to connect interact properly with mySQL database [closed]
  12. Do I have to guard against SQL injection if I used a dropdown?
  13. Best way to check if mysql_query returned any results?
  14. mysql_fetch_array return only one row
  15. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  16. a better approach than storing mysql password in plain text in config file?
  17. Selecting a float in MySQL
  18. mysql query result in php variable
  19. mysql_real_escape_string is undefined
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. How do detect that transaction has already been started?
  22. CakePHP Database connection “Mysql” is missing, or could not be created
  23. How to get primary key of table?
  24. MySQL Alter Table Add Field Before or After a field already present
  25. Simple way to read single record from MySQL
  26. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. using the browser prompt to download a file
  29. How can I use DATE() in Doctrine 2 DQL?
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment