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

PHP Topics


Ask Questions

Ask Question