(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 >= 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) 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, 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) 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) 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) 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) 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

(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) Initializes MySQLi and returns a resource for use with mysqli_real_connect() mysqli mysqli::init ( void ) Object oriented style Procedural style mysqli mysqli_init ( void ) Allocates or initializes a MYSQL object suitable for mysqli_options() and mysqli_real_connect(). Note: Any subsequent calls to any mysqli function (except mysqli_options()) will fail until mysqli_real_connect() was called.