The MySQLi Extension Function Summary
| 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 | 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 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 |
| 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 | 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() | 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 |
| 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 |
| 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.
English translation
You have asked to visit this site in English. For now, only the interface is translated, but not all the content yet.If you want to help me in translations, your contribution is welcome. All you need to do is register on the site, and send me a message asking me to add you to the group of translators, which will give you the opportunity to translate the pages you want. A link at the bottom of each translated page indicates that you are the translator, and has a link to your profile.
Thank you in advance.
Document created the 30/01/2003, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/php-rf-mysqli.summary.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
