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=mysqli_query($connection_mysql,$sql)){
      while ($row=mysqli_fetch_row($result)){
         printf ("%s (%s)\n",$row[0],$row[1]);
      }
      mysqli_free_result($result);//clear result set
   }
   mysqli_close($connection_mysql);
?>