<?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();
?>
//预编译演示
//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();
?>