PHPmysqli的 预处理执行查询语句

header( 'Content-Type:text/html;charset=utf-8 '); 
require 'prepareSrarment.php';
$mysqli=new mysqli("localhost", "root", "password, "user1", 3306);
$mysqli->set_charset("utf8");
//使用预编译从数据库中查询
//使用预处理的方法，查询所有ID>5的用户
$sql="select id,name,email from user1 where id>?";
$mysqli_stmt=$mysqli->prepare($sql) or die("1".$mysqli_stmt->error);
//绑定参数
$id=12;
$mysqli_stmt->bind_param("i", $id)or die($mysqli_stmt->error);
//绑定结果集
$mysqli_stmt->bind_result($id,$name,$email)or die($mysqli_stmt->error);
//执行
$mysqli_stmt->execute()or die("2".$mysqli_stmt->error);

while ($mysqli_stmt->fetch()){
    echo "<br/>---$id---$name----$email";
}
$mysqli_stmt->free_result();
$mysqli_stmt->close();
$mysqli->close();
?>