X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR BOOTSTRAP XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

PHP mysql_free_result() Function


PHP MySQL Reference Complete PHP MySQL Reference

Definition and Usage

The mysql_free_result() function frees memory used by a result handle.

This function returns TRUE on success, or FALSE on failure.

Syntax

mysql_free_result(data)

Parameter Description
data Required. Specifies which result handle to free. The result handle is the return from the mysql_query() function


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.


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


PHP MySQL Reference Complete PHP MySQL Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates

SHARE THIS PAGE

facebook