PHP mysql_free_result() Function
 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
| 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);
?>
|
Complete PHP MySQL Reference
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
