预编译执行 dml 语句
<?php
//mysql预编译
$mysqli = new mysqli("localhost", "root", "root", "php");
$mysqli->query("set names gbk");
$sql = "insert into user1(name,psw,email,age) values(?,?,?,?)";
$mysqli_stmt = $mysqli->prepare($sql);
//绑定参数
$name = "公子玮";
$psw = "123";
$email = "gonziwei.sohu,com";
$age = 24;
$mysqli_stmt->bind_param("sssi",$name,$psw,$email,$age);
$b = $mysqli_stmt->execute();
if(!$b){
die("failed".$mysqli_stmt->error);
exit();
}else{
echo "success<br/>";
}
//继续添加
$name = "编程大师";
$psw = "123";
$email = "dashi.sohu,com";
$age = 25;
$mysqli_stmt->bind_param("sssi",$name,$psw,$email,$age);
$b = $mysqli_stmt->execute();
if(!$b){
die("failed".$mysqli_stmt->error);
exit();
}else{
echo "success<br/>";
}
//继续添加
$name = "编程屌丝";
$psw = "123";
$email = "diaoshi.sohu,com";
$age = 25;
$mysqli_stmt->bind_param("sssi",$name,$psw,$email,$age);
$b = $mysqli_stmt->execute();
if(!$b){
die("failed".$mysqli_stmt->error);
exit();
}else{
echo "success<br/>";
}
$mysqli->close();
?>
预编译执行 dql 语句:
<?php
//预编译 执行 dql 语句
header("Content-type:text/html;charset=utf-8");
$mysqli = new mysqli("localhost", "root", "root", "php");
if($mysqli->connect_error){
die($mysqli->connect_error);
exit();
}
//create a predefined object and get a position
$sql = "select id,name,email from user1 where id > ?";
$mysqli_stmt = $mysqli->prepare($sql);
$id = 5;
//bind param
$mysqli_stmt->bind_param("i",$id);
//bind results
$mysqli_stmt->bind_result($id,$name,$email);
$mysqli_stmt->execute();
while ($mysqli_stmt->fetch()){
echo "--$id--$name--$email<br/>";
}
$mysqli_stmt->close();
$mysqli->close();
?>