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

add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top