Turning on mysql Extension on the PHP Engine in MySQL

Q

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

✍: FYIcenter.com

A

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

2017-07-30, 250👍, 0💬