English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية
The PHP MySQLi function allows access to the MySQLi database server. PHP can be used with MySQLi 4.1.13or higher version.
The mysqli extension is in PHP 5introduced in version .0.0, while the MySQLi native driver is already included in PHP 5.3in version .0.
Version-Indicates the earliest PHP version that supports this function.
| Number | Function name | Function description | Version |
|---|---|---|---|
| 1 | mysqli_affected_rows() | It returns the number of rows affected by the last SELECT, INSERT, UPDATE, REPLACE, or DELETE query. | 4 |
| 2 | mysqli_autocommit() | Open or close automatic submission of database modifications. | 4.3.0 |
| 3 | mysqli_begin_transaction() | It is used to start a MySQL transaction. | 4.3.0 |
| 4 | mysqli_change_user() | It is used to change the current/The user for the given database connection. | 4.3.0 |
| 5 | mysqli_character_set_name() | It is used to retrieve the default character set of the current database. | 4.3.0 |
| 6 | mysqli_close() | Used to close the MySQLi connection. | 4 |
| 7 | mysqli_commit() | It is used to save database modifications. | 5 |
| 8 | mysqli_connect() | Open a connection to the MySQLi server. | 4 |
| 9 | mysqli_connect_errno() | It returns the error code from the last connection. | 5 |
| 10 | mysqli_connect_error() | It returns the description of the error from the last connection. | 5 |
| 11 | mysqli_debug() | Used for debugging operations. | 5 |
| 12 | mysqli_dump_debug_info() | Used to dump debug information to the log. | 5 |
| 13 | mysqli_errno() | It returns the last error code of the latest statement. | 4 |
| 14 | mysqli_error() | It returns the last error description of the latest statement. | 4 |
| 15 | mysqli_error_list() | It returns the error list from the last statement. | 4 |
| 16 | mysqli_field_count() | It returns the number of columns of the most recent query./Field count. | 5 |
| 17 | mysqli_get_charset() | It returns a charset object. | 4 |
| 18 | mysqli_get_client_info() | It returns the MySQL client library version. | 5 |
| 19 | mysqli_get_client_stats() | It returns statistical information about each process of the client. | 5 |
| 20 | mysqli_get_client_version() | It returns the MySQLi client library version. | 5.1.0 |
| 21 | mysqli_get_connection_stats() | It returns statistical information about the client connection. | 5 |
| 22 | mysqli_get_host_info() | It returns the hostname and connection type of the MySQLi server. | 5 |
| 23 | mysqli_get_proto_info() | It returns MySQLi protocol version information | 5 |
| 24 | mysqli_get_server_info() | It returns MySQLi server information. | 5 |
| 25 | mysqli_get_server_version() | It returns the MySQLi server version. | 5 |
| 26 | mysqli_get_warnings() | It returns the error generated by the last query executed. | 5 |
| 27 | mysqli_info() | It returns information about the query recently executed. | 5 |
| 28 | mysqli_init() | It returns an object used with mysqli_real_connect(). | 5 |
| 29 | mysqli_insert_id() | It returns the ID of the last query. | 5 |
| 30 | mysqli_kill() | This function requests the server to kill the process-The MySQLi thread specified by the id parameter. | 5 |
| 31 | mysqli_more_results() | This function checks if there are more results from the multiple queries. | 5 |
| 32 | mysqli_multi_query() | It used to separate the query from the database with a semicolon. | 5 |
| 33 | mysqli_next_result() | It prepares the next result set for mysqli_multi_query(). | 5 |
| 34 | mysqli_options() | It is used to set connection options and change connection settings. | 5 |
| 35 | mysqli_ping() | It is used to ping the server connection and reconnect to the server if the connection is disconnected. | 5 |
| 36 | mysqli_prepare() | It performs a MySQL prepared query (with parameter markers) on the database. | 5 |
| 37 | mysqli_query() | It performs a query on the database. | 5 |
| 38 | mysqli_real_connect() | This function opens a new connection to the MySQL server. | 5 |
| 39 | mysqli_real_escape_string() | This function escapes special characters in the SQL statement string. | 5 |
| 40 | mysqli_real_query() | This function executes an SQL query. | 5 |
| 41 | mysqli_refresh() | This function refreshes the table or cache, or resets the replication server information. | 5 |
| 42 | mysqli_rollback() | This function rolls back the current transaction of the specified database connection. | 5 |
| 43 | mysqli_select_db() | This function changes the default database. | 5 |
| 44 | mysqli_set_charset() | This function sets the default character set. | 5 |
| 45 | mysqli_sqlstate() | This function returns the last SQLSTATE error code of the last error. | 5 |
| 46 | mysqli_ssl_set() | This function creates an SSL connection. | 5 |
| 47 | mysqli_stat() | This function returns the current system status. | 5 |
| 48 | mysqli_stmt_init() | This function initializes a statement and returns an object suitable for mysqli_stmt_prepare(). | 5 |
| 49 | mysqli_thread__id() | This function returns the current connection thread ID. | 5 |
| 50 | mysqli_thread_safe() | This function is used to verify whether the client library is compiled as thread-safe (thread-safe). | 5 |
| 51 | mysqli_use_result() | It initializes the retrieval of the result set from the query executed by the last mysqli_real_query(). | 5 |
| 52 | mysqli_warning_count() | It returns the number of errors generated by the last query executed. | 5 |
| 53 | mysqli_data_seek() | It is used to move the internal result pointer. | 4 |
| 54 | mysqli_fetch_all() | It is used to get all result rows and return the result set as an associative array | 4 |
| 55 | mysqli_fetch_array() | It is used to get the result row as an associative array | 5 |
| 56 | mysqli_fetch_assoc() | It is used to get the result row as an associative array. | 5.3 |
| 57 | mysqli_fetch_field() | It is used to return the next column in the result set as an object. | 4 |
| 58 | mysqli_fetch_field_direct() | It returns the specified column in the form of an object./Definition information of field (as an integer parameter). | 4 |
| 59 | mysqli_fetch_fields() | It is used to return an array of objects. | 4 |
| 60 | mysqli_fetch_lengths() | It is used to return the length of the field in the result. | 4 |
| 61 | mysqli_fetch_object() | It returns an object. | 5 |
| 62 | mysqli_fetch_row() | It returns the content of the current row of the result in the form of a string array. | 5 |
| 63 | mysqli_field_seek() | This function sets the column cursor to the given column offset. | 5 |
| 64 | mysqli_field_tell() | It returns the position of the cursor for the returned field. | 5 |
| 65 | mysqli_free_result() | It releases the memory associated with the result. | 5 |
| 66 | mysqli_num_fields() | It returns the number of fields in the result set. | 5 |
| 67 | mysqli_num_rows() | It returns the number of rows in the result set. | 5 |
| 68 | mysqli_stmt_sqlstate() | It returns SQLSTATE error from the last statement. | 5 |
| 69 | mysqli_stmt_affected_rows() | It returns the number of rows affected (changed, deleted, inserted) by the last executed statement. | 5 |
| 70 | mysqli_stmt_attr_get() | It returns the current value of the given attribute of the statement. | 5 |
| 71 | mysqli_stmt_attr_set() | This function can be used to set various attributes for the statement to change its behavior. | 5 |
| 72 | mysqli_stmt_bind_param() | It binds variables to the parameter placeholders in the prepared statement. | 5 |
| 73 | mysqli_stmt_bind_result() | It binds the columns of the result object to variables. | 5 |
| 74 | mysqli_stmt_close() | It closes a statement object. | 5 |
| 75 | mysqli_stmt_data_seek() | It is used to search for rows in the result object. | 5 |
| 76 | mysqli_stmt_errno() | It returns the error code that occurred during the execution of the last statement. | 5 |
| 77 | mysqli_stmt_error() | It returns the description of the error that occurred during the execution of the last statement. | 5 |
| 78 | mysqli_stmt_execute() | It executes a statement. | 5 |
| 79 | mysqli_stmt_fetch() | It extracts the columns of the result into the specified variables. | 5 |
| 80 | mysqli_stmt_field_count() | It returns the number of fields in the given statement result. | 5 |
| 81 | mysqli_stmt_free_result() | It is used to free the memory stored for the statement results. | 5 |
| 82 | mysqli_stmt_get_result() | It returns the results of the statement. | 5 |
| 83 | mysqli_stmt_num_rows() | It returns the number of rows in the statement results. | 5 |
| 84 | mysqli_stmt_param_count() | It returns the number of parameter placeholders in the prepared statement. | 5 |
| 85 | mysqli_stmt_prepare() | It prepares to execute a SQL statement, where you can use parameter placeholders ("?") in the query. | 5 |
| 86 | mysqli_stmt_reset() | It resets the error, unbuffered result set, and sent data through a statement. | 5 |
| 87 | mysqli_stmt_result_metadata() | It returns a metadata object that stores information about the statement results. | 5 |
| 88 | mysqli_stmt_send_long_data() | This function is used to send data in chunks to a column of type BLOB TEXT in the table if any column is of this type. | 5 |
| 89 | mysqli_stmt_store_result() | It is used to store the result of statement objects locally. | 5 |