Edit Report a Bug

    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.

    See Also

    add a note add a note

    User Contributed Notes 1 note

    up
    4
    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.
    add a note add a note
    To Top