Definition and Usage
定义和用法

The mysql_free_result() function frees memory used by a result handle.
mysql_free_result()函数的作用是：释放所使用的结果内存。

This function returns TRUE on success, or FALSE on failure.
如果该函数成功执行，则返回True；如果执行失败，则返回False。

Syntax
语法

mysql_free_result(data)

Tips and Notes
提示

Tip: PHP automatically releases the memory used by result handles at the end of the script. However, this function can be useful when you want to free up memory between large queries.
提示：PHP会在脚本程序执行完毕后自动释放所使用的结果内存。当你需要释放大量查询语句的内存时，使用这个函数将非常有效。

Example
案例

<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con) { die('Could not connect: ' . mysql_error()); }

$db_selected = mysql_select_db("test_db",$con);

$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_row($result));

// Free memory
mysql_free_result($result);

$sql = "SELECT * from Customers";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_row($result));

mysql_close($con);
?>

评论 (0) All