(PHP 5, PHP 7) Returns SQLSTATE error from previous statement operation string mysqli_stmt_sqlstate ( mysqli_stmt $stmt ) Object oriented style string $mysqli_stmt->sqlstate; Procedural style Returns a string containing the SQLSTATE error code for the most recently invoked prepared statement function that can succeed or fail. The error code consists of five characters. '00000' means no error. The values are specified by

(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) 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) 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) 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 >= 5.3.0, PHP 7) Reads the next result from a multiple query public bool mysqli_stmt::next_result ( void ) Object oriented style (method): Procedural style: bool mysqli_stmt_next_result ( mysql_stmt $stmt ) Reads the next result from a multiple query. Parameters: stmt Procedural style only: A statement identifier returned by mysqli_stmt_init().

(PHP 5 >= 5.3.0, PHP 7) Check if there are more query results from a multiple query public bool mysqli_stmt::more_results ( void ) Object oriented style (method): Procedural style: bool mysqli_stmt_more_results ( mysql_stmt $stmt ) Checks if there are more query results from a multiple query. Parameters: stmt Procedural style only: A statement identifier returned by my

(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.