Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorials - PHP Connections and Query Execution

By: FYIcenter.com

A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors. Topics included in this collections:

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?

Please note that all answers and tutorials are based on MySQL 5.0 and PHP 5.0. Sometimes you may need to run previous tutorials in order to continue a later tutorial.

Continue with the next FAQ collection on how to manage tables and selecting data rows with PHP scripts.

(Continued on next topic...)