实例教程
<?php
//PHP使用预编译技术
$mysqli=new mysqli("localhost","root","123456","worddb");
if($mysqli->connect_error){
die("连接失败".$mysqli->connect_error);
}
//添加三个用户
$sql="insert into users(name,age,email) values(?,?,?) ";
//创建预编译对象
$mysqli_sta=$mysqli->prepare($sql);
//绑定参数1
$name="马云";
$age="50";
$email="mayun@alibaba.com";
//前边的是类型,后边的是对应关系,s表示字符串,d表示double,i表示整形数据
$mysqli_sta->bind_param("sss",$name,$age,$email);
$bol=$mysqli_sta->execute();
//继续添加2
$name="马化腾";
$age="43";
$email="tony@qq.com";
$mysqli_sta->bind_param("sss",$name,$age,$email);
$bol=$mysqli_sta->execute();
//继续添加3
$name="李彦宏";
$age="41";
$email="liyanhong@baidu.com";
$mysqli_sta->bind_param("sss",$name,$age,$email);
//执行,返回一个Boolean值
$bol=$mysqli_sta->execute();
if($bol){
echo "成功了,真的成功了!";
}
else{
die("操作失败".$mysqli_sta->error);
}
$mysqli->close();
?>