无涯教程-PHP - mysqli_free_result函数

mysqli_free_result - 语法

mysqli_free_result(result);

它将释放与输出关联的内存。

mysqli_free_result - 返回值

它返回输出的空闲内存

mysqli_free_result - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","db");
if (mysqli_connect_errno($connection_mysql)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT name FROM Emp";
if ($result</span><span class="pun">=</span><span class="pln">mysqli_query</span><span class="pun">(</span><span class="pln">$connection_mysql,sql</span><span class="pun">)){</span><span class="pln">
      </span><span class="kwd">while</span><span class="pln"> </span><span class="pun">(</span><span class="pln">row=mysqli_fetch_row(result</span><span class="pun">)){</span><span class="pln">
         printf </span><span class="pun">(</span><span class="str">"%s (%s)\n"</span><span class="pun">,</span><span class="pln">row[0],row</span><span class="pun">[</span><span class="lit">1</span><span class="pun">]);</span><span class="pln">
      </span><span class="pun">}</span><span class="pln">
      mysqli_free_result</span><span class="pun">(</span><span class="pln">result);//clear result set
}
mysqli_close($connection_mysql);
?>

参考链接

www.learnfk.com/php/php-mys…