Function

Description

mysql_affected_rows

Get number of affected rows in previous MySQL operation

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

Retrieves database name from the call to mysql_list_dbs

mysql_db_query

Selects a database and executes a query on it

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 in the last query

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 an SQL statement

mysql_result

Get result data

mysql_select_db

Select a MySQL database

mysql_set_charset

Sets the client character set

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.

Share Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest Share on Stumbleupon Share on Tumblr Share on Reddit Share on Diggit