(PHP 5, PHP 7) Transfers a result set from a prepared statement bool mysqli_stmt::store_result ( void ) Object oriented style Procedural style bool mysqli_stmt_store_result ( mysqli_stmt $stmt ) You must call mysqli_stmt_store_result() for every query that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN), if and only if you want to buffer the complete result set by the client, so that the subsequent mysq

(PHP 5, PHP 7) Returns result set metadata from a prepared statement mysqli_result mysqli_stmt::result_metadata ( void ) Object oriented style Procedural style mysqli_result mysqli_stmt_result_metadata ( mysqli_stmt $stmt ) If a statement passed to mysqli_prepare() is one that produces a result set, mysqli_stmt_result_metadata() returns the result object that can be used to process the meta information such as total number

(PHP 5, PHP 7) Resets a prepared statement bool mysqli_stmt::reset ( void ) Object oriented style Procedural style bool mysqli_stmt_reset ( mysqli_stmt $stmt ) Resets a prepared statement on client and server to state after prepare. It resets the statement on the server, data sent using mysqli_stmt_send_long_data(), unbuffered result sets and current errors. It does not clear bindings or stored result sets. Stored result

(PHP 5, PHP 7) Send data in blocks bool mysqli_stmt::send_long_data ( int $param_nr, string $data ) Object oriented style Procedural style bool mysqli_stmt_send_long_data ( mysqli_stmt $stmt , int $param_nr , string $data ) Allows to send parameter data to the server in pieces (or chunks), e.g. if the size of a blob exceeds the size of max_allowed_packet. This function can be called multiple times to send the parts of a cha

(PHP 5, PHP 7) Return the number of rows in statements result set int mysqli_stmt_num_rows ( mysqli_stmt $stmt ) Object oriented style int $mysqli_stmt->num_rows; Procedural style Returns the number of rows in the result set. The use of mysqli_stmt_num_rows() depends on whether or not you used mysqli_stmt_store_result() to buffer the entire result set in the statement handle. If you use mysqli_stmt_store_result(), mysq

(PHP 5, PHP 7) Prepare an SQL statement for execution mixed mysqli_stmt::prepare ( string $query ) Object oriented style Procedural style bool mysqli_stmt_prepare ( mysqli_stmt $stmt , string $query ) Prepares the SQL query pointed to by the null-terminated string query. The parameter markers must be bound to application variables using mysqli_stmt_bind_param() and/or mysqli_stmt_bind_result() before executing the stateme

(PHP 5, PHP 7) Returns the number of parameter for the given statement int mysqli_stmt_param_count ( mysqli_stmt $stmt ) Object oriented style int $mysqli_stmt->param_count; Procedural style Returns the number of parameter markers present in the prepared statement. Parameters: stmt Procedural style only: A statement identifier returned by mysqli_stmt_init().

(PHP 5, PHP 7) Frees stored result memory for the given statement handle void mysqli_stmt::free_result ( void ) Object oriented style Procedural style void mysqli_stmt_free_result ( mysqli_stmt $stmt ) Frees the result memory associated with the statement, which was allocated by mysqli_stmt_store_result(). Parameters: stmt Procedural style only: A statement identifier re

(PHP 5, PHP 7) Get the ID generated from the previous INSERT operation mixed mysqli_stmt_insert_id ( mysqli_stmt $stmt ) Object oriented style int $mysqli_stmt->insert_id; Procedural style This function is currently not documented; only its argument list is available.

(PHP 5, PHP 7) Returns the number of field in the given statement int mysqli_stmt_field_count ( mysqli_stmt $stmt ) Object oriented style int $mysqli_stmt->field_count; Procedural style This function is currently not documented; only its argument list is available.