Easy Tutorial
❮ Func String Str Word Count Php Imagechar ❯

PHP 5 MySQLi Functions


Introduction to PHP MySQLi

PHP MySQLi = PHP MySQL Improved!

MySQLi functions allow you to access the MySQL database server.

Note: The MySQLi extension is designed for MySQL versions 4.1.13 or newer.


Installation / Runtime Configuration

To use MySQLi functions, you must add support for the MySQLi extension when compiling PHP.

The MySQLi extension was introduced in PHP 5.0.0. The MySQL Native Driver is included in PHP 5.3.0.

For detailed installation information, visit: http://www.php.net/manual/en/mysqli.installation.php

For detailed runtime configuration information, visit: http://www.php.net/manual/en/mysqli.configuration.php


PHP 5 MySQLi Functions

Function Description
mysqli_affected_rows() Returns the number of rows affected by the previous MySQL operation.
mysqli_autocommit() Turns on or off auto-commit mode for database modifications.
mysqli_change_user() Changes the user of the specified database connection.
mysqli_character_set_name() Returns the default character set for the database connection.
mysqli_close() Closes a previously opened database connection.
mysqli_commit() Commits the current transaction.
mysqli_connect_errno() Returns the error code from the last connection error.
mysqli_connect_error() Returns the error description from the last connection error.
mysqli_connect() Opens a new connection to the MySQL server.
mysqli_data_seek() Adjusts the result pointer to an arbitrary row in the result set.
mysqli_debug() Performs debugging operations.
mysqli_dump_debug_info() Dumps debugging information into the log.
mysqli_errno() Returns the last error code for the most recent function call.
mysqli_error_list() Returns a list of errors from the last function call.
mysqli_error() Returns the last error description for the most recent function call.
mysqli_fetch_all() Fetches all result rows as an associative array, a numeric array, or both.
mysqli_fetch_array() Fetches a result row as an associative array, a numeric array, or both.
mysqli_fetch_assoc() Fetches a result row as an associative array.
mysqli_fetch_field_direct() Fetches meta-data for a single field in the result set and returns it as an object.
mysqli_fetch_field() Fetches the next field from the result set and returns it as an object.
mysqli_fetch_fields() Returns an array of objects representing the fields in a result set.
mysqli_fetch_lengths() Returns the lengths of the columns of the current row in the result set.
mysqli_fetch_object() Fetches the current row from the result set and returns it as an object.
mysqli_fetch_row() Fetches a row from the result set and returns it as an enumerated array.
mysqli_field_count() Returns the number of columns for the most recent query.
mysqli_field_seek() Sets the field cursor to the given offset in the result set.
mysqli_field_tell() Returns the position of the field cursor in the result set.
mysqli_free_result() Frees the memory associated with the result.
mysqli_get_charset() Returns a character set object.
mysqli_get_client_info() Returns the MySQL client library version.
mysqli_get_client_stats() Returns statistics about the client per process.
mysqli_get_client_version() Returns the MySQL client library version as an integer.
mysqli_get_connection_stats() Returns statistics about the client connection.
mysqli_get_host_info() Returns the MySQL server hostname and connection type.
mysqli_get_proto_info() Returns the MySQL protocol version.
mysqli_get_server_info() Returns the MySQL server version.
mysqli_get_server_version() Returns the MySQL server version as an integer.
mysqli_info() Returns information about the most recently executed query.
mysqli_init() Initializes MySQLi and returns a resource for use with mysqli_real_connect().
mysqli_insert_id() Returns the auto-generated ID used in the last query.
mysql_kill() Requests the server to kill a MySQL thread.
mysqli_more_results() Checks if there are more results from a multi-query.
mysqli_multi_query() Performs one or more queries on the database.
mysqli_next_result() Prepares the next result set from mysqli_multi_query().
mysqli_num_fields() Returns the number of fields in the result set.
mysqli_num_rows() Returns the number of rows in the result set.
mysqli_options() Sets extra connection options to affect the connection behavior.
mysqli_ping() Pings a server connection, or tries to reconnect if the connection has gone down.
mysqli_prepare() Prepares an SQL statement for execution.
mysqli_query() Executes a query against the database.
mysqli_real_connect() Opens a new connection to the MySQL server.
mysqli_real_escape_string() Escapes special characters in a string for use in an SQL statement.
mysqli_real_query() Executes an SQL query.
mysqli_reap_async_query() Returns the result from an asynchronous query.
mysqli_refresh() Refreshes tables or caches, or resets replication server information.
mysqli_rollback() Rolls back the current transaction in the database.
mysqli_select_db() Changes the default database for the connection.
mysqli_set_charset() Sets the default client character set.
mysqli_set_local_infile_default() Unsets the user-defined handler for load local infile command.
mysqli_set_local_infile_handler() Sets the callback function for the LOAD DATA LOCAL INFILE command.
mysqli_sqlstate() Returns the SQLSTATE error code for the last MySQL operation.
mysqli_ssl_set() Used for establishing an SSL secure connection.
mysqli_stat() Returns the current system status.
mysqli_stmt_init() Initializes a statement and returns an object for use with mysqli_stmt_prepare().
mysqli_store_result() Transfers the current result set.
mysqli_thread_id() Returns the thread ID for the current connection.
mysqli_thread_safe() Returns whether the client library is compiled as thread-safe.
mysqli_use_result() Initiates the retrieval of a result set from the last query executed using mysqli_real_query().
mysqli_warning_count() Returns the number of warnings from the last query in the connection.
❮ Func String Str Word Count Php Imagechar ❯