PHP mysqli_free_result() function frees the memory associated with a result.
Syntax
bool mysqli_free_result(result);
Parameter | Description |
---|---|
result : | Required parameter. Mention a result set identifier returned by mysqli_query(). |
Return Values : | Returns TRUE on success or FALSE on failure. |
<?php $con = mysqli_free_result("localhost","user","password","db"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "SELECT * FROM employee"; $sql_result = mysqli_query($con, $sql); while ($row = mysqli_fetch_row($sql_result)) { echo "First Name :" . $row[0] . " Last Name :" . $row[1]; } // Free the memory associated with result mysqli_free_result($sql_result); mysqli_close($con); ?>