(PHP 5, PHP 7) Returns the error code from last connect call int mysqli_connect_errno ( void ) Object oriented style int $mysqli->connect_errno; Procedural style Returns the last error code number from the last call to mysqli_connect(). Note: Client error message numbers are listed in the MySQL errmsg.h header file, server error message numbers are listed in mysqld_error.h. In the MySQL source distribution you can fi

(PHP 5, PHP 7) Commits the current transaction bool mysqli::commit ([ int $flags [, string $name ]] ) Object oriented style Procedural style bool mysqli_commit ( mysqli $link [, int $flags [, string $name ]] ) Commits the current transaction for the database connection. Parameters: link Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

(PHP 5, PHP 7) Closes a previously opened database connection bool mysqli::close ( void ) Object oriented style Procedural style bool mysqli_close ( mysqli $link ) Closes a previously opened database connection. Open non-persistent MySQL connections and result sets are automatically destroyed when a PHP script finishes its execution. So, while explicitly closing open connections and freeing result sets is optional, doing

(PHP 5, PHP 7) Returns the MySQL client version as a string int mysqli_get_client_version ( mysqli $link ) Object oriented style int $mysqli->client_version; Procedural style Returns client version number as an integer. Returns: A number that represents the MySQL client library version in format: main_version*10000 + minor_version *100 + sub_version. For example, 4.1.0 is returned as 40100.

(PHP 5, PHP 7) Get MySQL client info string mysqli_get_client_info ( mysqli $link ) Object oriented style string $mysqli->client_info; Procedural style Returns a string that represents the MySQL client library version. Returns: A string that represents the MySQL client library version Examples: mysqli_get_client_info

(PHP 5, PHP 7) Returns the default character set for the database connection string mysqli::character_set_name ( void ) Object oriented style Procedural style string mysqli_character_set_name ( mysqli $link ) Returns the current character set for the database connection. Parameters: link Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init(

(PHP 5, PHP 7) Changes the user of the specified database connection bool mysqli::change_user ( string $user, string $password, string $database ) Object oriented style Procedural style bool mysqli_change_user ( mysqli $link , string $user , string $password , string $database ) Changes the user of the specified database connection and sets the current database. In order to successfully change users a valid username and p

(PHP 5 >= 5.5.0, PHP 7) Starts a transaction public bool mysqli::begin_transaction ([ int $flags [, string $name ]] ) Object oriented style (method): Procedural style: bool mysqli_begin_transaction ( mysqli $link [, int $flags [, string $name ]] ) Begins a transaction. Requires MySQL 5.6 and above, and the InnoDB engine (it is enabled by default). For additional details about how MySQL transactions work, see » http://dev

(PHP 5, PHP 7) Turns on or off auto-committing database modifications bool mysqli::autocommit ( bool $mode ) Object oriented style Procedural style bool mysqli_autocommit ( mysqli $link , bool $mode ) Turns on or off auto-commit mode on queries for the database connection. To determine the current state of autocommit use the SQL command SELECT @@autocommit. Parameters: link

(PHP 5, PHP 7) Gets the number of affected rows in a previous MySQL operation int mysqli_affected_rows ( mysqli $link ) Object oriented style int $mysqli->affected_rows; Procedural style Returns the number of rows affected by the last INSERT, UPDATE, REPLACE or DELETE query. For SELECT statements mysqli_affected_rows() works like mysqli_num_rows(). Parameters: link P