PHP mysqli_free_result() Function

PHP mysqli_free_result() function frees the memory associated with a result.

Syntax

bool mysqli_free_result(result);

mysqli_free_result() Function Parameter

ParameterDescription
result :Required parameter. Mention a result set identifier returned by mysqli_query().

mysqli_free_result() Function Return Value

Return Values :Returns TRUE on success or FALSE on failure.

mysqli_free_result() Function Example

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