php mysqli 使用prepare

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

$mysqli->close();

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/iamtsgx08/archive/2009/05/08/4161274.aspx