PHP MySQLi functions

List of Functions

PHP - shows the first version of PHP that supports the function.

Function & Description

    1.mysqli_affected_rows

    It returns the number of affected rows in the previous SELECT, INSERT, UPDATE, REPLACE, or DELETE query.

    2.mysqli_autocommit

    Used to turn off or off the modification of an automated committed site.

    3.mysqli_begin_transaction

    It is used to start a MySQL transaction.

    4.mysqli_change_user

    It is used to change the current/given database connection user.

    5.mysqli_character_set_name

    Used to retrieve a set of current default characters database.

    6.mysqli_close

    It is used to close MySQLi connection

    7.mysqli_commit

    It is used to save the database modifications.

    8.mysqli_connect

    Opens connection to MySQLi Server

    9.mysqli_connect_errno

    Returns the error code from the last connection.

    10.mysqli_connect_error

    Returns the error description from the last connection.

    11.mysqli_debug

    It is used to perform debugging operations

    12.mysqli_dump_debug_info

    It is used to dump debugging info into the log

    13.mysqli_errno

    It returns the last error code for the most recent statement.

    14.mysqli_error

    Returns the last error code for the latest statement.

    15.mysqli_error_list

    Returns the description of the last error for the most recent statement.

    16.mysqli_field_count

    It returns the number of columns/fields for the most recent query.

    17.mysqli_get_charset

    It returns a character set object.

    18.mysqli_get_client_info

    It returns the MySQL client library version.

    19.mysqli_get client_stats

    It returns statistics about client per-process.

    20.mysqli_get_client_version

    It returns the MySQLi client library version.