mysql php释放内存_php mysqli_free_result()函数释放结果集

mysqli_free_result()介绍

php mysqli_free_result()函数用于释放查询出来的数据结果集，这样有利于及时清理内存。

语法：

mysqli_free_result(result);

参数：

参数

描述

result

必需。数据结果集(由mysqli_query()所返回)

mysqli_free_result()实例

1、面向对象实例：

/* http://www.manongjc.com/article/1192.html */

//创建mysqli类

$mysqli = new mysqli();

//连接数据库服务器

$mysqli->connect("127.0.0.1", "root","", "mydatabase");

//sql语句

$query = "SELECT productid, name, price FROM product ORDER by name";

//执行sql语句

$mysqli->query($query);

//释放结果集

$result->free();

?>

2、面向过程实例：

/* http://www.manongjc.com */

$con=mysqli_connect("localhost","root","","db");

if (mysqli_connect_errno($con))

{

echo "连接失败，错误码： " . mysqli_connect_error();

}

$query = "SELECT productid, name, price FROM product ORDER BY name";

$result = mysqli_query($con,$query);

..../*这里是操作数据的代码，已省略*/

//释放结果集

mysqli_free_result($result);

mysqli_close($con);

?>