PHP 7.0.6 Released

    mysqli_result::free

    mysqli_free_result

    (PHP 5, PHP 7)

    mysqli_result::free -- mysqli_free_result — Frees the memory associated with a result

    Description

    Object oriented style

    void mysqli_result::free ( void )
    void mysqli_result::close ( void )
    void mysqli_result::free_result ( void )

    Procedural style

    void mysqli_free_result ( mysqli_result $result )

    Frees the memory associated with the result.

    Note:

    You should always free your result with mysqli_free_result(), when your result object is not needed anymore.

    Parameters

    result

    Procedural style only: A result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result().

    Return Values

    No value is returned.

    See Also

    User Contributed Notes

    Vector at ionisis dot com
    6 years ago
    If you are getting this error:
    Internal SQL Bug: 2014, Commands out of sync; you can't run this command now

    Then you never called mysqli_result::free(), mysqli_result::free_result(), mysqli_result::close(), or mysqli_free_result() in your script, and must call it before executing another stored procedure.
    Anonymous
    6 years ago
    Freeing the memory associated with a result means that the references returned by mysqli_fetch_object (or equivalent) are cleared. Thus if you should pass an object pointing to a database row _by reference_, every call of mysqli_free_result will discard the referenced data.
    To Top