(PHP 5, PHP 7, PHP 8)

mysqli_stmt::close -- mysqli_stmt_closeCloses a prepared statement


Object-oriented style

public mysqli_stmt::close(): true

Procedural style

mysqli_stmt_close(mysqli_stmt $statement): true

Closes a prepared statement. mysqli_stmt_close() also deallocates the statement handle. If the current statement has pending or unread results, this function cancels them so that the next query can be executed.



Procedural style only: A mysqli_stmt object returned by mysqli_stmt_init().

Return Values

Always returns true.


Version Description
8.0.0 This function now always returns true. Previously it returned false on failure.

See Also

add a note

User Contributed Notes 1 note

daniel dot kipp at web dot de
18 years ago
if you are repeating an statement in an loop using bind_param and so on inside it for a larger operation. i thougt id would be good to clean it with stmt->close. but it broke always with an error after aprox. 250 operations . As i tried it with stmt->reset it worked for me.
To Top