????：/1連接數(shù)據庫創(chuàng)建pdo對象$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');//2創(chuàng)建預處理對象$stmt////$sql = "INSERT IGNORE INTO `user` (`name`,`email`,`password`,`status`,

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

//
//$sql = "INSERT IGNORE INTO `user` (`name`,`email`,`password`,`status`,`creattime`) VALUES
//        (:name,:email,:password,:status,:creattime)";

//選擇sql語句
$sql = "INSERT IGNORE INTO `user`(`name`,`email`,`password`,`status`,`creattime`) VALUES
(:name,:email,:password,:status,:creattime) ";

//3驗證sql語句，生成預處理對象
$stmt=$pdo->prepare($sql);
//4參數(shù)綁定
$name='東不敗';
$email='dongfnag@qq.com';
$password=sha1('123456');
$status=1;
$creattime=time();

$stmt->bindParam('name',$name,PDO::PARAM_STR,20);
$stmt->bindParam('email',$email,PDO::PARAM_STR,20);
$stmt->bindParam('password',$password,PDO::PARAM_STR,20);
$stmt->bindParam('status',$status,PDO::PARAM_INT,2);
$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:14:59
???? ??：寫的很不錯 pdo對數(shù)據庫的處理目前使用的要比mysqli要多 一定要記得多去練習