PHP 5 MySQLi Functions

PHP MySQLi Introduction

PHP MySQLi = PHP MySQL Improved!

The MySQLi capacities enables you to get to MySQL database servers.

Note: The MySQLi expansion is intended to work with MySQL form 4.1.13 or newer.

Installation/Runtime Configuration

For the MySQLi capacities to be accessible, you should incorporate PHP with help for the MySQLi extension.

The MySQLi expansion was presented with PHP variant 5.0.0. The MySQL Native Driver was incorporated into PHP adaptation 5.3.0.

For establishment subtleties, go to: http://php.net/manual/en/mysqli.installation.php

For runtime design subtleties, go to: http://php.net/manual/en/mysqli.configuration.php

PHP 5 MySQLi Functions

Function Description
mysqli_affected_rows() Returns the quantity of influenced columns in the past MySQL operation
mysqli_autocommit() Turns on or off auto-submitting database modifications
mysqli_change_user() Changes the client of the predefined database connection
mysqli_character_set_name() Returns the default character set for the database connection
mysqli_close() Closes a recently opened database connection
mysqli_commit() Commits the current transaction
mysqli_connect_errno() Returns the blunder code from the last association error
mysqli_connect_error() Returns the blunder depiction from the last association error
mysqli_connect() Opens another association with the MySQL server
mysqli_data_seek() Adjusts the outcome pointer to a discretionary column in the outcome set
mysqli_debug() Performs investigating operations
mysqli_dump_debug_info() Dumps investigating information into the log
mysqli_errno() Returns the last mistake code for the latest capacity call
mysqli_error_list() Returns a rundown of blunders for the latest capacity call
mysqli_error() Returns the last mistake portrayal for the latest capacity call
mysqli_fetch_all() Fetches all outcome pushes as a cooperative cluster, a numeric exhibit, or both
mysqli_fetch_array() Fetches an outcome push as an acquainted, a numeric exhibit, or both
mysqli_fetch_assoc() Fetches an outcome push as an acquainted array
mysqli_fetch_field_direct() Returns meta-information for a solitary field in the outcome set, as an object
< mysqli_fetch_field() Returns the following field in the outcome set, as an object
mysqli_fetch_fields() Returns a variety of items that speak to the fields in a result set
mysqli_fetch_lengths() Returns the lengths of the segments of the present column in the outcome set
mysqli_fetch_object() Returns the present column of an outcome set, as an object
mysqli_fetch_row() Fetches one line from an outcome set and returns it as a listed array
mysqli_field_count() Returns the quantity of sections for the latest query
mysqli_field_seek() Sets the field cursor to the given field offset
mysqli_field_tell() Returns the situation of the field cursor
mysqli_free_result() Frees the memory related with a result
mysqli_get_charset() Returns a character set object
mysqli_get_client_info() Returns the MySQL customer library version
mysqli_get_client_stats() Returns insights about customer per-process
mysqli_get_client_version() Returns the MySQL customer library form as an integer
mysqli_get_connection_stats() Returns insights about the customer connection
mysqli_get_host_info() Returns the MySQL server hostname and the association type
mysqli_get_proto_info() Returns the MySQL convention version
mysqli_get_server_info() Returns the MySQL server version
mysqli_get_server_version() Returns the MySQL server form as an integer
mysqli_info() Returns data about the most as of late executed query
mysqli_init() Initializes MySQLi and returns an asset for use with mysqli_real_connect()
mysqli_insert_id() Returns the auto-created id utilized in the last query
mysqli_kill() Asks the server to slaughter a MySQL thread
mysqli_more_results() Checks if there are more outcomes from a multi query
mysqli_multi_query() Performs at least one inquiries on the database
mysqli_next_result() Prepares the following outcome set from mysqli_multi_query()
mysqli_num_fields() Returns the quantity of fields in an outcome set
mysqli_num_rows() Returns the quantity of columns in an outcome set
mysqli_options() Sets additional interface choices and influence conduct for a connection
mysqli_ping() Pings a server association, or attempts to reconnect if the association has gone down
mysqli_prepare() Prepares a SQL explanation for execution
mysqli_query() Performs a question against the database
mysqli_real_connect() Opens another association with the MySQL server
mysqli_real_escape_string() Escapes uncommon characters in a string for use in a SQL statement
mysqli_real_query() Executes a SQL query
mysqli_reap_async_query() Returns the outcome from async inquiry
mysqli_refresh() Refreshes tables or reserves, or resets the replication server information
mysqli_rollback() Rolls back the present exchange for the database
mysqli_select_db() Changes the default database for the connection
mysqli_set_charset() Sets the default customer character set
mysqli_set_local_infile_default() Unsets client characterized handler for burden nearby infile command
mysqli_set_local_infile_handler() Set callback work for LOAD DATA LOCAL INFILE command
mysqli_sqlstate() Returns the SQLSTATE mistake code for the last MySQL operation
mysqli_ssl_set() Used to set up secure associations utilizing SSL
mysqli_stat() Returns the present framework status
mysqli_stmt_init() Initializes an announcement and returns an article for use with mysqli_stmt_prepare()
mysqli_store_result() Transfers an outcome set from the last query
mysqli_thread_id() Returns the string ID for the current connection
mysqli_thread_safe() Returns whether the customer library is assembled as string safe
mysqli_use_result() Initiates the recovery of an outcome set from the last question executed utilizing the mysqli_real_query()
mysqli_warning_count() Returns the quantity of alerts from the last inquiry in the connection