PHP Manual
Function Reference
Database Extensions
Vendor Specific Database Extensions
MySQL
Overview of the MySQL PHP drivers
MySQLi
Mysql_xdevapi
MySQL (Original)
Mysqlnd
Warning::__construct
Introduction
MySQL
PHP Manual
Original MySQL API
Table of Contents
Introduction
Installing/Configuring
Requirements
Installation
Runtime Configuration
Resource Types
Changelog
Predefined Constants
Examples
MySQL extension overview example
MySQL Functions
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