mysqli扩展库增强-预处理mysqli_stmt 批量查询显示结果

<?php 
    //mysqli扩展库增强-预处理mysqli_stmt  批量查询显示结果
    //1、创建mysql对象
  	$mysqli=new mysqli("127.0.0.1","root","password","testdb");
  	//验证是否连接成功
    if($mysqli->connect_error){
    	die("连接失败".$mysqli->connect_error);
    }
    //2创建预编译对象

  	$sql="select id,name,email,age from user where id>?";
  	$mysqli_stmt=$mysqli->prepare($sql);
  	$id=5;
  	//绑定参数
  	$mysqli_stmt->bind_param("i",$id);
  	//执行
  	$mysqli_stmt->exeucte();

  	//取出绑定的值
  	while ($mysqli_stmt->fetcch()) {
  		//显示结果
  		echo"--$id--$name--$email--$age--"
  	}


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

    //关闭连接
    $mysqli->close();
  	

?>