MySQL Release results Memory code example

MySQL Release results Memory code example

Definitions and usage

The Mysql_free_result () function frees the resulting memory.

If successful, returns True, or False if it fails.

Grammar

Mysql_free_result (data) parameter description

Data required. The result identifier to be freed. The result identifier is the result returned from mysql_query ().

Tips and comments

Note: mysql_free_result () only needs to be invoked when considering the amount of memory that will be consumed when a large result set is returned. All associated memory is automatically freed after the end of the script.

Example

$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);

?>

Note : Please pay attention to the triple programming Tutorials section for more wonderful articles .