Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Requirements for Using MySQL in PHP

By: FYIcenter.com

(Continued from previous topic...)

What Do You Need to Connect PHP to MySQL?

If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API extensions:

  • mysql - This is the standard MySQL API extension. It does not support the improved authentication protocol used in MySQL 5.0, nor does it support prepared statements or multiple statements.
  • mysqli - Stands for "MySQL, Improved". This extension is available only in PHP 5. It is intended for use with MySQL 4.1.1 and later. This extension fully supports the authentication protocol used in MySQL 5.0, as well as the Prepared Statements and Multiple Statements APIs. In addition, this extension provides an advanced, object-oriented programming interface.

"mysql" API extension will be used in this tutorial collection.

(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:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: