MySQueaL Resources

resources for mysql admins and developers who are squealing for help

From Dual

Vendor Independent and Neutral MySQL Consulting in Europe.

Connection Functions

These are PHP API functions related to connecting to MySQL.

• mysql_change_user( )

  This PHP API function can be used to change the username for a MySQL connection.

• mysql_close( )

  This PHP API function closes the current or last MySQL connection, or a given MySQL connection.

• mysql_connect( )

  Use this PHP function to start a MySQL connection.

• mysql_pconnect( )

  This PHP API function may be used to open a persistent connection to MySQL.

• mysql_thread_id( )

  This PHP API function returns the MySQL thread identification number for the current MySQL connection.

Data Retrieval Functions

These are PHP API functions related to retrieving data from MySQL.

• mysql_fetch_array( )

  This PHP API function returns an array containing a row of data from a MySQL query results set.

• mysql_fetch_assoc( )

  This PHP API function returns an associative array containing a row of data from a results set generated by a query executed in MySQL.

• mysql_fetch_field( )

  This PHP API function returns an object containing information about a field from a results set from MySQL.

• mysql_fetch_lengths( )

  This PHP API function returns an array containing the length of each field of a results set from a MySQL query.

• mysql_fetch_object( )

  This PHP API function returns a row of data as an object from a given results set from MySQL.

• mysql_fetch_row( )

  This PHP API function returns an array containing a row of data from a given results set from MySQL.

• mysql_query( )

  Use this PHP API function to execute an given SQL statement in MySQL.

• mysql_result( )

  This PHP API function returns the data from one field of a row from the results of a MySQL query.

• mysql_unbuffered_query( )

  Use this PHP function to execute a MySQL statement given without buffering the results so that you can retrieve the data from MySQL without having to wait for the results set to be completed.

Information Functions

These PHP API functions are used to retrieve information about the MySQL server and client.

• mysql_get_host_info( )

  This PHP API function returns information on the host for the current connection to MySQL.

• mysql_get_proto_info( )

  This PHP API function returns the protocol version for the current connection to MySQL.

• mysql_get_server_info( )

  This PHP API function returns the MySQL server version for the current connection to MySQL.

• mysql_info( )

  This PHP API function returns information on the last query for the current connection to MySQL.

• mysql_tablename( )

  This PHP funtion returns the table name for a particular MySQL table in the results set given by the PHP function, mysql_list_tables( ).

Miscellaneous Functions

These are miscellaneous PHP API functions. Basically, these are PHP functions related to MySQL we have not yet classified in particular group yet.

• mysql_affected_rows( )

  This PHP API function returns the number of rows in MySQL that were affected by a previous SQL statement that modified rows of data in a MySQL table for the current MySQL session.

• mysql_client_encoding( )

  This PHP API function returns the name of the default character set for the current MySQL connection or, if the connection identification number is supplied, for that particular MySQL connection.

• mysql_create_db( )

  Use this PHP function to create a database in MySQL for the current connection.

• mysql_data_seek( )

  Use this PHP function in conjunction with the mysql_fetch_row( ) PHP function to change the current MySQL row being fetched to the one specified in the second argument of this function.

• mysql_db_name( )

  This PHP API function returns the name of the database from the results of the mysql_list_dbs( ) PHP function, which returns a pointer to a MySQL results set containing the names of databases for a MySQL server.

• mysql_db_query( )

  This PHP API function can be used to query the MySQL database given, for the current MySQL connection (unless another is specified), and to execute the SQL statement given as the second argument.

• mysql_drop_db( )

  Use this PHP function to delete the MySQL database given from the MySQL server.

• mysql_errno( )

  This PHP API function returns the MySQL error code number for the last MySQL statement issued by the current connection.

• mysql_error( )

  This PHP API function returns the MySQL generated error message for the last MySQL statement issued.

• mysql_escape_string( )

  This PHP API function returns the string given with special characters preceded by backslashes so that they are protected from being interpreted by the MySQL interpreter.

• mysql_field_flags( )

  This PHP API function returns the field flags for a field of a given results set from MySQL.

• mysql_field_len( )

  This PHP API function returns the length from a field of a given MySQL results set.

• mysql_field_name( )

  This PHP API function returns the name of a field from a given MySQL results set.

• mysql_field_seek( )

  Use this PHP API function to change the pointer to a different field from a given results set from MySQL.

• mysql_field_table( )

  This PHP API function returns the name of the MySQL table that contains a particular field from the MySQL results set given.

• mysql_field_type( )

  This PHP API function returns the MySQL column datatype for a field from the MySQL results set given.

• mysql_free_result( )

  Use this PHP API function to free the memory containing the MySQL results set given.

• mysql_get_client_info( )

  This PHP API function returns the library version of the MySQL client for the current connection to MySQL.

• mysql_insert_id( )

  This PHP API function returns the identification number of the primary key of the last record inserted into a MySQL table using INSERT for the current connection, provided the related MySQL column utilizes AUTO_INCREMENT and the value was not manually set.

• mysql_list_dbs( )

  This PHP API function returns a pointer to a results set containing the names of MySQL databases hosted by the MySQL server.

• mysql_list_fields( )

  This PHP API function returns a results set containing information about the columns of a MySQL table given for a MySQL database specified.

• mysql_list_processes( )

  This PHP API function returns a results set from MySQL containing information on the server threads for the current MySQL connection: the connection identifier, the hostname, the MySQL database name, and the command.

• mysql_list_tables( )

  This PHP API functions returns a results set containing a list of tables for the MySQL database given.

• mysql_num_fields( )

  This PHP API function returns the number from fields of the given results set from MySQL.

• mysql_num_rows( )

  This PHP API function returns the number of rows in the results set given, generated by issuing a SELECT statement in MySQL.

• mysql_ping( )

  Use this PHP function to determine if the current MySQL connection is still open.

• mysql_real_escape_string( )

  This returns the string given to PHP with special characters preceded by backslashes so that they are protected from being interpreted by the MySQL interpreter.

• mysql_select_db( )

  This PHP API function sets the MySQL database to be used by the current MySQL connection, but it can also be used to set the MySQL database for another MySQL connection by supplying it as a second argument.

• mysql_set_charset( )

  This PHP API function sets the default character set for the current connection to MySQL, or for a MySQL connection given with the function.

• mysql_stat( )

  This PHP API function returns the status of the server for the current MySQL connection, but it can also be used to get the status for another MySQL connection.

Return to MySQL Documentation page of our MySQL Documentation