mysqli_result::free

mysqli_free_result

(PHP 5)

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

说明

面向对象风格

void mysqli_result::free ( void )

void mysqli_result::close ( void )

void mysqli_result::free_result ( void )

过程化风格

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.

参数

result: 仅以过程化样式：由 mysqli_query() ， mysqli_store_result() 或 mysqli_use_result() 返回的结果集标识。

返回值

没有返回值。

参见

mysqli_query() - 对数据库执行一次查询
mysqli_stmt_store_result() - Transfers a result set from a prepared statement
mysqli_store_result() - Transfers a result set from the last query
mysqli_use_result() - Initiate a result set retrieval

用户评论:

[#1] Vector at ionisis dot com [2009-12-28 17:17:45]

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.

[#2] Anonymous [2009-10-18 15:49:27]

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.