(PHP 5, PHP 7) Performs a query on the database mixed mysqli::query ( string $query [, int $resultmode = MYSQLI_STORE_RESULT ] ) Object oriented style Procedural style mixed mysqli_query ( mysqli $link , string $query [, int $resultmode = MYSQLI_STORE_RESULT ] ) Performs a query against the database. For non-DML queries (not INSERT, UPDATE or DELETE), this function is similar to calling mysqli_real_query() followed by ei

(PHP 5, PHP 7) Prepare an SQL statement for execution mysqli_stmt mysqli::prepare ( string $query ) Object oriented style Procedural style mysqli_stmt mysqli_prepare ( mysqli $link , string $query ) Prepares the SQL query, and returns a statement handle to be used for further operations on the statement. The query must consist of a single SQL statement. The parameter markers must be bound to application variables using my

(PHP 5 >= 5.3.0, PHP 7) Poll connections public static int mysqli::poll ( array &$read, array &$error, array &$reject, int $sec [, int $usec ] ) Object oriented style Procedural style int mysqli_poll ( array &$read , array &$error , array &$reject , int $sec [, int $usec ] ) Poll connections. Available only with mysqlnd. The method can be used as static. Parameters:

(PHP 5, PHP 7) Pings a server connection, or tries to reconnect if the connection has gone down bool mysqli::ping ( void ) Object oriented style Procedural style bool mysqli_ping ( mysqli $link ) Checks whether the connection to the server is working. If it has gone down, and global option mysqli.reconnect is enabled an automatic reconnection is attempted. This function can be used by clients that remain idle for a long w

(PHP 5, PHP 7) Set options bool mysqli::options ( int $option, mixed $value ) Object oriented style Procedural style bool mysqli_options ( mysqli $link , int $option , mixed $value ) Used to set extra connect options and affect behavior for a connection. This function may be called multiple times to set several options. mysqli_options() should be called after mysqli_init() and before mysqli_real_connect().

(PHP 5, PHP 7) Prepare next result from multi_query bool mysqli::next_result ( void ) Object oriented style Procedural style bool mysqli_next_result ( mysqli $link ) Prepares next result set from a previous call to mysqli_multi_query() which can be retrieved by mysqli_store_result() or mysqli_use_result(). Parameters: link Procedural style only: A link identifier returned

(PHP 5, PHP 7) Performs a query on the database bool mysqli::multi_query ( string $query ) Object oriented style Procedural style bool mysqli_multi_query ( mysqli $link , string $query ) Executes one or multiple queries which are concatenated by a semicolon. To retrieve the resultset from the first query you can use mysqli_use_result() or mysqli_store_result(). All subsequent query results can be processed using mysqli_mo

(PHP 5, PHP 7) Check if there are any more query results from a multi query bool mysqli::more_results ( void ) Object oriented style Procedural style bool mysqli_more_results ( mysqli $link ) Indicates if one or more result sets are available from a previous call to mysqli_multi_query(). Parameters: link Procedural style only: A link identifier returned by mysqli_connect(

(PHP 5, PHP 7) Asks the server to kill a MySQL thread bool mysqli::kill ( int $processid ) Object oriented style Procedural style bool mysqli_kill ( mysqli $link , int $processid ) This function is used to ask the server to kill a MySQL thread specified by the processid parameter. This value must be retrieved by calling the mysqli_thread_id() function. To stop a running query you should use the SQL command KILL QUERY proc

(PHP 5, PHP 7) Returns the auto generated id used in the last query mixed mysqli_insert_id ( mysqli $link ) Object oriented style mixed $mysqli->insert_id; Procedural style The mysqli_insert_id() function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCR