mysqli_stmt::close

mysqli_stmt_close

(PHP 5, PHP 7, PHP 8)

mysqli_stmt::close -- mysqli_stmt_close — Closes 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.

Improve This Page

Learn How To Improve This Page • Submit a Pull Request • Report a Bug

＋add a note

User Contributed Notes 1 note

down

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.