The MySQLi Extension Function Summary

**Summary of mysqli methods**
mysqli Class
OOP Interface	Procedural Interface	Alias (Do not use)	Description
Properties
$mysqli::affected_rows	mysqli_affected_rows	N/A	Gets the number of affected rows in a previous MySQL operation
$mysqli::client_info	mysqli_get_client_info	N/A	Returns the MySQL client version as a string
$mysqli::client_version	mysqli_get_client_version	N/A	Returns MySQL client version info as an integer
$mysqli::connect_errno	mysqli_connect_errno	N/A	Returns the error code from last connect call
$mysqli::connect_error	mysqli_connect_error	N/A	Returns a string description of the last connect error
$mysqli::errno	mysqli_errno	N/A	Returns the error code for the most recent function call
$mysqli::error	mysqli_error	N/A	Returns a string description of the last error
$mysqli::field_count	mysqli_field_count	N/A	Returns the number of columns for the most recent query
$mysqli::host_info	mysqli_get_host_info	N/A	Returns a string representing the type of connection used
$mysqli::protocol_version	mysqli_get_proto_info	N/A	Returns the version of the MySQL protocol used
$mysqli::server_info	mysqli_get_server_info	N/A	Returns the version of the MySQL server
$mysqli::server_version	mysqli_get_server_version	N/A	Returns the version of the MySQL server as an integer
$mysqli::info	mysqli_info	N/A	Retrieves information about the most recently executed query
$mysqli::insert_id	mysqli_insert_id	N/A	Returns the auto generated id used in the last query
$mysqli::sqlstate	mysqli_sqlstate	N/A	Returns the SQLSTATE error from previous MySQL operation
$mysqli::warning_count	mysqli_warning_count	N/A	Returns the number of warnings from the last query for the given link
Methods
mysqli::autocommit	mysqli_autocommit	N/A	Turns on or off auto-committing database modifications
mysqli::change_user	mysqli_change_user	N/A	Changes the user of the specified database connection
mysqli::character_set_name	mysqli_character_set_name	N/A	Returns the default character set for the database connection
mysqli::close	mysqli_close	N/A	Closes a previously opened database connection
mysqli::commit	mysqli_commit	N/A	Commits the current transaction
mysqli::__construct	mysqli_connect	N/A	Open a new connection to the MySQL server [Note: static (i.e. class) method]
mysqli::debug	mysqli_debug	N/A	Performs debugging operations
mysqli::dump_debug_info	mysqli_dump_debug_info	N/A	Dump debugging information into the log
mysqli::get_charset	mysqli_get_charset	N/A	Returns a character set object
mysqli::get_connection_stats	mysqli_get_connection_stats	N/A	Returns client connection statistics. mysqlnd でのみ使用可能です。
mysqli::get_client_info	mysqli_get_client_info	N/A	Returns the MySQL client version as a string
N/A	mysqli_get_client_stats	N/A	Returns client per-process statistics. mysqlnd でのみ使用可能です。
mysqli::get_server_info	mysqli_get_server_info	N/A	Returns a string representing the version of the MySQL server that the MySQLi extension is connected to
mysqli::get_warnings	mysqli_get_warnings	N/A	NOT DOCUMENTED
mysqli::init	mysqli_init	N/A	Initializes MySQLi and returns an object for use with mysqli_real_connect.
mysqli::kill	mysqli_kill	N/A	Asks the server to kill a MySQL thread
mysqli::more_results	mysqli_more_results	N/A	Check if there are any more query results from a multi query
mysqli::multi_query	mysqli_multi_query	N/A	Performs a query on the database
mysqli::next_result	mysqli_next_result	N/A	Prepare next result from multi_query
mysqli::options	mysqli_options	mysqli_set_opt	Set options
mysqli::ping	mysqli_ping	N/A	Pings a server connection, or tries to reconnect if the connection has gone down
mysqli::prepare	mysqli_prepare	N/A	Prepare an SQL statement for execution
mysqli::query	mysqli_query	N/A	Performs a query on the database
mysqli::real_connect	mysqli_real_connect	N/A	Opens a connection to a mysql server
mysqli::real_escape_string, mysqli::escape_string	mysqli_real_escape_string	mysqli_escape_string	Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection
mysqli::real_query	mysqli_real_query	N/A	Execute an SQL query
mysqli::refresh	mysqli_refresh	N/A	Flushes tables or caches, or resets the replication server information
mysqli::rollback	mysqli_rollback	N/A	Rolls back current transaction
mysqli::select_db	mysqli_select_db	N/A	Selects the default database for database queries
mysqli::set_charset	mysqli_set_charset	N/A	Sets the default client character set
mysqli::ssl_set	mysqli_ssl_set	N/A	Used for establishing secure connections using SSL
mysqli::stat	mysqli_stat	N/A	Gets the current system status
mysqli::stmt_init	mysqli_stmt_init	N/A	Initializes a statement and returns an object for use with mysqli_stmt_prepare
mysqli::store_result	mysqli_store_result	N/A	Transfers a result set from the last query
mysqli::thread_id	mysqli_thread_id	N/A	Returns the thread ID for the current connection
mysqli::thread_safe	mysqli_thread_safe	N/A	Returns whether thread safety is given or not
mysqli::use_result	mysqli_use_result	N/A	Initiate a result set retrieval

**Summary of mysqli_stmt methods**
MySQL_STMT
OOP Interface	Procedural Interface	Alias (Do not use)	Description
Properties
$mysqli_stmt::affected_rows	mysqli_stmt_affected_rows	N/A	Returns the total number of rows changed, deleted, or inserted by the last executed statement
$mysqli_stmt::errno	mysqli_stmt_errno	N/A	Returns the error code for the most recent statement call
$mysqli_stmt::error	mysqli_stmt_error	N/A	Returns a string description for last statement error
$mysqli_stmt::field_count	mysqli_stmt_field_count	N/A	Returns the number of field in the given statement - not documented
$mysqli_stmt::insert_id	mysqli_stmt_insert_id	N/A	Get the ID generated from the previous INSERT operation
$mysqli_stmt::num_rows	mysqli_stmt_num_rows	N/A	Return the number of rows in statements result set
$mysqli_stmt::param_count	mysqli_stmt_param_count	N/A	Returns the number of parameter for the given statement
$mysqli_stmt::sqlstate	mysqli_stmt_sqlstate	N/A	Returns SQLSTATE error from previous statement operation
Methods
mysqli_stmt::attr_get	mysqli_stmt_attr_get	N/A	Used to get the current value of a statement attribute
mysqli_stmt::attr_set	mysqli_stmt_attr_set	N/A	Used to modify the behavior of a prepared statement
mysqli_stmt::bind_param	mysqli_stmt_bind_param	N/A	Binds variables to a prepared statement as parameters
mysqli_stmt::bind_result	mysqli_stmt_bind_result	N/A	Binds variables to a prepared statement for result storage
mysqli_stmt::close	mysqli_stmt_close	N/A	Closes a prepared statement
mysqli_stmt::data_seek	mysqli_stmt_data_seek	N/A	Seeks to an arbitrary row in statement result set
mysqli_stmt::execute	mysqli_stmt_execute	mysqli_execute	Executes a prepared Query
mysqli_stmt::fetch	mysqli_stmt_fetch	N/A	Fetch results from a prepared statement into the bound variables
mysqli_stmt::free_result	mysqli_stmt_free_result	N/A	Frees stored result memory for the given statement handle
mysqli_stmt::get_result	mysqli_stmt_get_result	N/A	Gets a result set from a prepared statement. mysqlnd でのみ使用可能です。
mysqli_stmt::get_warnings	mysqli_stmt_get_warnings	N/A	NOT DOCUMENTED
mysqli_stmt::more_results	mysqli_stmt_more_results	N/A	Checks if there are more query results from a multiple query
mysqli_stmt::next_result	mysqli_stmt_next_result	N/A	Reads the next result from a multiple query
mysqli_stmt::num_rows	mysqli_stmt_num_rows	N/A	See also property $mysqli_stmt::num_rows
mysqli_stmt::prepare	mysqli_stmt_prepare	N/A	Prepare an SQL statement for execution
mysqli_stmt::reset	mysqli_stmt_reset	N/A	Resets a prepared statement
mysqli_stmt::result_metadata	mysqli_stmt_result_metadata	N/A	Returns result set metadata from a prepared statement
mysqli_stmt::send_long_data	mysqli_stmt_send_long_data	N/A	Send data in blocks
mysqli_stmt::store_result	mysqli_stmt_store_result	N/A	Transfers a result set from a prepared statement

**Summary of mysqli_result methods**
mysqli_result
OOP Interface	Procedural Interface	Alias (Do not use)	Description
Properties
$mysqli_result::current_field	mysqli_field_tell	N/A	Get current field offset of a result pointer
$mysqli_result::field_count	mysqli_num_fields	N/A	Get the number of fields in a result
$mysqli_result::lengths	mysqli_fetch_lengths	N/A	Returns the lengths of the columns of the current row in the result set
$mysqli_result::num_rows	mysqli_num_rows	N/A	Gets the number of rows in a result
Methods
mysqli_result::data_seek	mysqli_data_seek	N/A	Adjusts the result pointer to an arbitrary row in the result
mysqli_result::fetch_all	mysqli_fetch_all	N/A	Fetches all result rows and returns the result set as an associative array, a numeric array, or both. mysqlnd でのみ使用可能です。
mysqli_result::fetch_array	mysqli_fetch_array	N/A	Fetch a result row as an associative, a numeric array, or both
mysqli_result::fetch_assoc	mysqli_fetch_assoc	N/A	Fetch a result row as an associative array
mysqli_result::fetch_column	mysqli_fetch_column	N/A	Fetch a single column from the next row of a result set
mysqli_result::fetch_field_direct	mysqli_fetch_field_direct	N/A	Fetch meta-data for a single field
mysqli_result::fetch_field	mysqli_fetch_field	N/A	Returns the next field in the result set
mysqli_result::fetch_fields	mysqli_fetch_fields	N/A	Returns an array of objects representing the fields in a result set
mysqli_result::fetch_object	mysqli_fetch_object	N/A	Returns the current row of a result set as an object
mysqli_result::fetch_row	mysqli_fetch_row	N/A	Get a result row as an enumerated array
mysqli_result::field_seek	mysqli_field_seek	N/A	Set result pointer to a specified field offset
mysqli_result::free, mysqli_result::close, mysqli_result::free_result	mysqli_free_result	N/A	Frees the memory associated with a result

**Summary of mysqli_driver methods**
MySQL_Driver
OOP Interface	Procedural Interface	Alias (Do not use)	Description
Properties
$mysqli_driver::mysqli_report	mysqli_report	N/A	Sets mysqli error reporting mode
Methods
mysqli_driver::embedded_server_end	mysqli_embedded_server_end	N/A	NOT DOCUMENTED
mysqli_driver::embedded_server_start	mysqli_embedded_server_start	N/A	NOT DOCUMENTED

注意:
Alias functions are provided for backward compatibility purposes only. Do not use them in new projects.