Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Turning on mysql Extension on the PHP Engine

By: FYIcenter.com

(Continued from previous topic...)

How To Turn on mysql Extension on the PHP Engine?

The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check the PHP configuration file, \php\php.ini, to make sure the extension=php_mysql.dll is not commented out.

The MySQL API offers a number of functions to allow you to work with MySQL server. Some commonly used MySQL functions are:

• mysql_connect -- Open a connection to a MySQL Server
• mysql_get_client_info -- Get MySQL client info
• mysql_get_host_info -- Get MySQL host info
• mysql_get_server_info -- Get MySQL server info
• mysql_close -- Close MySQL connection
• mysql_list_dbs -- List databases available on a MySQL server
• mysql_fetch_object -- Fetch a result row as an object
• mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
• mysql_query -- Send a MySQL query
• mysql_errno -- Returns the numerical value of the error message from previous MySQL operation
• mysql_error -- Returns the text of the error message from previous MySQL operation
• mysql_select_db -- Select a MySQL database
• mysql_num_rows -- Returns the number of rows selected in a result set object returned from SELECT statement
• mysql_affected_rows -- Returns the number of rows affected by the last INSERT, UPDATE or DELETE statement
• mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
• mysql_free_result -- Free result memory
• mysql_list_tables -- List tables in a MySQL database
• mysql_list_fields -- List MySQL table fields

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