PHP 8.1.0 Released!



(PHP 5, PHP 7, PHP 8)

mysqli_stmt::close -- mysqli_stmt_closeCloses a prepared statement


Object-oriented style

public mysqli_stmt::close(): bool

Procedural style

mysqli_stmt_close(mysqli_stmt $statement): bool

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

Returns true on success or false on failure.

See Also

add a note add a note

User Contributed Notes 1 note

daniel dot kipp at web dot de
15 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