1，绑定参数
$mysqli=new mysqli($host,$user,$pass,$db);
if(mysqli_connect_errno()){
echo '连接出现异常了:'.mysqli_connect_error();
exit(0); }
$sql = 'insert into user(name,pass,email) values(?,?,?)';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('sss',$name,$paassword,$email);
$name= '2';
$paassword=md5('12345');
$email = 'iamtsgx08@google.com';
$stmt->execute();
echo '修改了'.$stmt->affected_rows.'行';
$stmt->close();
$mysqli->close();
2，绑定结果集
$sql = 'select name,pass,email from user';
if($stmt = $mysqli->prepare($sql)){
$stmt->execute();
$stmt->bind_result($name,$pass,$email); //绑定结果
echo "<table>";
while($stmt->fetch()){
echo "<tr>";
echo "<td>".$name."</td>";
echo "<td>".$pass."</td>";
echo "<td>".$email."</td>";
echo "</tr>";
}
echo "</table>";
$stmt->close();
}
&nbs
