mysqli_stmt reset() Method

The mysqli_stmt::reset() / mysqli_stmt_reset() function 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 sets will be cleared when executing the prepared statement (or closing it).

To prepare a statement with another query, mysqli_stmt_prepare() function can be used.

Syntax

//Object-oriented style
public mysqli_stmt::reset()

//Procedural style
mysqli_stmt_reset(statement)

Parameters

statement Required. For procedural style only: Specify a mysqli_stmt object returned by mysqli_stmt_init().

Return Value

Returns true on success or false on failure.

❮ MySQLi Functions Reference