How To Turn on mysql Extension on the PHP Engine in MySQL?

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

 

⇒PHP Connections and Query Execution for MySQL

⇒⇒MySQL Database Tutorials