CascadiaPHP 2024

mysqli_stmt::close

mysqli_stmt_close

(PHP 5, PHP 7, PHP 8)

mysqli_stmt::close -- mysqli_stmt_closeCloses a prepared statement

Description

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.

Parameters

statement

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

Return Values

Always returns true.

Changelog

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

up
-3
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