22.9.3.8. The MySQLi Extension Function Summary

Table 22.45. Summary of mysqli methods

OOP Interface	Procedural Interface	Alias (Do not use)	Description
mysqli Class
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::client_encoding	`mysqli_character_set_name`	`mysqli_client_encoding`	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. Available only with mysqlnd.
`mysqli::get_client_info`	`mysqli_get_client_info`	N/A	Returns the MySQL client version as a string
`mysqli::get_client_stats`	`mysqli_get_client_stats`	N/A	Returns client per-process statistics. Available only with mysqlnd.
`mysqli::get_cache_stats`	`mysqli_get_cache_stats`	N/A	Returns client Zval cache statistics. Available only with mysqlnd.
`mysqli::get_server_info`	`mysqli_get_server_info`	N/A	NOT DOCUMENTED
`mysqli::get_warnings`	`mysqli_get_warnings`	N/A	NOT DOCUMENTED
`mysqli::init`	`mysqli_init`	N/A	Initializes MySQLi and returns a resource for use with mysqli_real_connect. [Not called on an object, as it returns a $mysqli object.]
`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::set_local_infile_default`	`mysqli_set_local_infile_default`	N/A	Unsets user defined handler for load local infile command
`mysqli::set_local_infile_handler`	`mysqli_set_local_infile_handler`	N/A	Set callback function for LOAD DATA LOCAL INFILE command
`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 withmysqli_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

Table 22.46. Summary of mysqli_stmt methods

OOP Interface	Procedural Interface	Alias (Do not use)	Description
MySQL_STMT
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`	`mysqli_param_count`	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`	`mysqli_bind_param`	Binds variables to a prepared statement as parameters
`mysqli_stmt::bind_result`	`mysqli_stmt_bind_result`	`mysqli_bind_result`	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`	`mysqli_fetch`	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. Available only with mysqlnd.
`mysqli_stmt::get_warnings`	`mysqli_stmt_get_warnings`	N/A	NOT DOCUMENTED
$mysqli_stmt::more_results()	mysqli_stmt_more_results()	N/A	NOT DOCUMENTED Available only with mysqlnd.
$mysqli_stmt::next_result()	mysqli_stmt_next_result()	N/A	NOT DOCUMENTED Available only with mysqlnd.
`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`	`mysqli_get_metadata`	Returns result set metadata from a prepared statement
`mysqli_stmt::send_long_data`	`mysqli_stmt_send_long_data`	`mysqli_send_long_data`	Send data in blocks
`mysqli_stmt::store_result`	`mysqli_stmt_store_result`	N/A	Transfers a result set from a prepared statement

Table 22.47. Summary of mysqli_result methods

OOP Interface	Procedural Interface	Alias (Do not use)	Description
mysqli_result
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. Available only with 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_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

Table 22.48. Summary of mysqli_driver methods

OOP Interface	Procedural Interface	Alias (Do not use)	Description
MySQL_Driver
Properties
N/A
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

Note

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