(PHP 5, PHP 7) Selects the default database for database queries bool mysqli::select_db ( string $dbname ) Object oriented style Procedural style bool mysqli_select_db ( mysqli $link , string $dbname ) Selects the default database to be used when performing queries against the database connection. Note: This function should only be used to change the default database for the connection. You can select the default databa

(PHP 5 >= 5.5.0, PHP 7) Set a named transaction savepoint public bool mysqli::savepoint ( string $name ) Object oriented style (method): Procedural style: bool mysqli_savepoint ( mysqli $link , string $name ) Parameters: link Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init() name Procedural style onl

(PHP 5, PHP 7) Returns RPL query type int mysqli::rpl_query_type ( string $query ) Object oriented style Procedural style int mysqli_rpl_query_type ( mysqli $link , string $query ) Returns MYSQLI_RPL_MASTER, MYSQLI_RPL_SLAVE or MYSQLI_RPL_ADMIN depending on a query type. INSERT, UPDATE and similar are master queries, SELECT is slave, and FLUSH, REPAIR and similar are admin. Thi

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

(PHP 5 >= 5.5.0, PHP 7) Removes the named savepoint from the set of savepoints of the current transaction public bool mysqli::release_savepoint ( string $name ) Object oriented style (method): Procedural style: bool mysqli_release_savepoint ( mysqli $link , string $name ) Parameters: link Procedural style only: A link identifier returned by mysqli_connect() or mysqli_ini

(PHP 5 <= 5.3.0) Refreshes public bool mysqli::refresh ( int $options ) Object oriented style Procedural style int mysqli_refresh ( resource $link , int $options ) Flushes tables or caches, or resets the replication server information. Parameters: link Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init() options

(PHP 5 >= 5.3.0, PHP 7) Get result from async query public mysqli_result mysqli::reap_async_query ( void ) Object oriented style Procedural style mysqli_result mysqli_reap_async_query ( mysqli $link ) Get result from async query. Available only with mysqlnd. Parameters: link Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

(PHP 5, PHP 7) Execute an SQL query bool mysqli::real_query ( string $query ) Object oriented style Procedural style bool mysqli_real_query ( mysqli $link , string $query ) Executes a single query against the database whose result can then be retrieved or stored using the mysqli_store_result() or mysqli_use_result() functions. In order to determine if a given query should return a result set or not, see mysqli_field_count

(PHP 5, PHP 7) Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection string mysqli::escape_string ( string $escapestr ) Object oriented style string mysqli::real_escape_string ( string $escapestr ) Procedural style string mysqli_real_escape_string ( mysqli $link , string $escapestr ) This function is used to create a legal SQL string that you can use i

(PHP 5, PHP 7) Opens a connection to a mysql server bool mysqli::real_connect ([ string $host [, string $username [, string $passwd [, string $dbname [, int $port [, string $socket [, int $flags ]]]]]]] ) Object oriented style Procedural style bool mysqli_real_connect ( mysqli $link [, string $host [, string $username [, string $passwd [, string $dbname [, int $port [, string $socket [, int $flags ]]]]]]] ) Establish a conn