PHP 7.0.6 Released

    mysqli_stmt::close

    mysqli_stmt_close

    (PHP 5, PHP 7)

    mysqli_stmt::close -- mysqli_stmt_close — Closes a prepared statement

    Description

    Object oriented style

    bool mysqli_stmt::close ( void )

    Procedural style

    bool mysqli_stmt_close ( mysqli_stmt $stmt )

    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

    stmt

    Procedural style only: A statement identifier returned by mysqli_stmt_init().

    Return Values

    Returns TRUE on success or FALSE on failure.

    See Also

    User Contributed Notes

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