mysqli预处理得到结果集

<?php


 //预编译演示
 //1，创建mysqli对象
 $mysqli=new mysqli("localhost","root","1234","test");


 $mysqli->query("set names 'utf8'");
//2，创建预编译对象
 $sql="select id,username,email from user1 where id>?";
 $mysqli_stmt=$mysqli->prepare($sql);
 //绑定参数
 $id=2;
//参数绑定
$mysqli_stmt->bind_param('i',$id);
//绑定结果集
$mysqli_stmt->bind_result($id,$name,$email);
//执行
$mysqli_stmt->execute();
//取出绑定的值
while($mysqli_stmt->fetch()){
echo "<br/>---$id---$name---$email";


}
//关闭资源
//释放结果
$mysqli_stmt->free_result();
//关闭预编译语句
$mysqli_stmt->close();




$mysqli->close();
?>