php预处理

实例教程

<?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();

?>