摘要：<?php//1連接數(shù)據(jù)庫創(chuàng)建pdo對象$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');//2創(chuàng)建預(yù)處理對象$stmt//選擇sql語句$sql = "UPDATE  `user` SET`email`=:email,`creattime

<?php
//1連接數(shù)據(jù)庫創(chuàng)建pdo對象
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');
//2創(chuàng)建預(yù)處理對象$stmt

//選擇sql語句
$sql = "UPDATE  `user` SET`email`=:email,`creattime`=:creattime  WHERE `user_id`=:user_id";

//3驗證sql語句，生成預(yù)處理對象
$stmt=$pdo->prepare($sql);
//4參數(shù)綁定
$id=2;
$email='dongfnag@qq.com';
$creattime=time();

$stmt->bindParam('user_id',$id,PDO::PARAM_INT,20);
$stmt->bindParam('email',$email,PDO::PARAM_STR,20);
$stmt->bindParam('creattime',$creattime,PDO::PARAM_INT,20);
//5執(zhí)行添加}

if ($stmt->execute()){
   echo ($stmt->rowCount()>0 ? '成功添加了'.$stmt->rowCount().'條記錄':'沒有記錄被添加');
}else {
   exit(print_r($stmt->errorInfo(), true));

批改老師：查無此人批改時間：2019-03-07 09:06:53
老師總結(jié)：完成的不錯?，F(xiàn)在pdo已經(jīng)替代了mysqli，所以只要好好學(xué)習(xí)pdo就行了，繼續(xù)加油