Mysql Functions in PHP
List of available MYSQL Functions in PHP
Explanation
Here a list of Mysql Functions are available. To make this function much clear you have to read Mysql tutorials first and then come back to this tutorial.
This tutorial will explain you how to execute Mysql PHP functions to perform mysql operation.
Table of Contents
mysql_affected_rows
mysql_change_user
mysql_client_encoding
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_db_name
mysql_db_query
mysql_drop_db
mysql_errno
mysql_error
mysql_escape_string
mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_object
mysql_fetch_row
mysql_field_flags
mysql_field_len
mysql_field_name
mysql_field_seek
mysql_field_table
mysql_field_type
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_pconnect
mysql_ping
mysql_query
mysql_real_escape_string
mysql_result
mysql_select_db
mysql_stat
mysql_tablename
mysql_thread_id
mysql_unbuffered_query
This tutorial will explain you how to execute Mysql PHP functions to perform mysql operation.
Table of Contents
mysql_affected_rows
Get number of affected rows in previous MySQL operation
mysql_change_user
Change logged in user of the active connection
mysql_client_encoding
Returns the name of the character set
mysql_close
Close MySQL connection
mysql_connect
Open a connection to a MySQL Server
mysql_create_db
Create a MySQL database
mysql_data_seek
Move internal result pointer
mysql_db_name
Get result data
mysql_db_query
Send a MySQL query
mysql_drop_db
Drop (delete) a MySQL database
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_escape_string
Escapes a string for use in a mysql_query.
mysql_fetch_array
Fetch a result row as an associative array, a numeric array, or both.
mysql_fetch_assoc
Fetch a result row as an associative array
mysql_fetch_field
Get column information from a result and return as an object
mysql_fetch_lengths
Get the length of each output in a result
mysql_fetch_object
Fetch a result row as an object
mysql_fetch_row
Get a result row as an enumerated array
mysql_field_flags
Get the flags associated with the specified field in a result
mysql_field_len
Returns the length of the specified field
mysql_field_name
Get the name of the specified field in a result
mysql_field_seek
Set result pointer to a specified field offset
mysql_field_table
Get name of the table the specified field is in
mysql_field_type
Get the type of the specified field in a result
mysql_free_result
Free result memory
mysql_get_client_info
Get MySQL client info
mysql_get_host_info
Get MySQL host info
mysql_get_proto_info
Get MySQL protocol info
mysql_get_server_info
Get MySQL server info
mysql_info
Get information about the most recent query
mysql_insert_id
Get the ID generated from the previous INSERT operation
mysql_list_dbs
List databases available on a MySQL server
mysql_list_fields
List MySQL table fields
mysql_list_processes
List MySQL processes
mysql_list_tables
List tables in a MySQL database
mysql_num_fields
Get number of fields in result
mysql_num_rows
Get number of rows in result
mysql_pconnect
Open a persistent connection to a MySQL server
mysql_ping
Ping a server connection or reconnect if there is no connection
mysql_query
Send a MySQL query
mysql_real_escape_string
Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection.
mysql_result
Get result data
mysql_select_db
Select a MySQL database
mysql_stat
Get current system status
mysql_tablename
Get table name of field
mysql_thread_id
Return the current thread ID
mysql_unbuffered_query
Send an SQL query to MySQL, without fetching and buffering the result rows
