Notes
mysqli
Mysqli
PHP Manual

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

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

Summary of mysqli_driver methods
MySQL_Driver
OOP Interface | Procedural Interface | Alias (Do not use) | Description
--- | --- | --- | ---
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.