Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Retrieving Execution Error Message

By: FYIcenter.com

(Continued from previous topic...)

How To Get MySQL Statement Execution Errors?

When you execute a MySQL statement with mysql_query(), and the statement failed, mysql_query() will return the Boolean value FALSE. This is good enough to tell that there is something wrong with that statement. But if you want to know more about the cause of the failure, you can use mysql_errno() and mysql_error() get the error number and error message. The tutorial exercise below shows you an improved version of the previous PHP script:

<?php
  $con = mysql_connect('localhost:8888', 'guest', 'pub');
  $sql = 'CREATE DATABASE fyicenter';
  if (mysql_query($sql, $con)) {
    print("Database fyicenter created.\n");
  } else {
    print("Database creation failed with error:\n");
    print(mysql_errno($con).": ".mysql_error($con)."\n");
  }
  mysql_close($con); 
?>

If you run this script, you will get something like this:

Database creation failed with error:
1044: Access denied for user 'guest'@'%' to database 'fyicenter'

(Continued on next topic...)

  1. How To Install PHP on Windows?
  2. How To Verify Your PHP Installation?
  3. What Do You Need to Connect PHP to MySQL?
  4. How To Turn on mysql Extension on the PHP Engine?
  5. How To Connect to a MySQL Server with Default Port Number?
  6. How To Connect to a MySQL Server with a Port Number?
  7. How To Connect to MySQL Server with User Accounts?
  8. How To Access MySQL Servers through Firewalls?
  9. How To Get Some Basic Information Back from MySQL Servers?
  10. How To Close MySQL Connection Objects?
  11. How To Get a List of Databases from MySQL Servers?
  12. How To Create a New Database?
  13. What Happens If You Do Not Have Privileges to Create Database?
  14. How To Get MySQL Statement Execution Errors?
  15. How To Drop an Existing Database?
  16. How To Select an Exiting Database?
  17. Can You Select Someone Else Database?
  18. How To Execute a SQL Statement?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...