abstract：/1连接数据库创建pdo对象$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');//2创建预处理对象$stmt////$sql = "INSERT IGNORE INTO `user` (`name`,`email`,`password`,`status`,
/1连接数据库创建pdo对象
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');
//2创建预处理对象$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参数绑定
$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执行添加}
if ($stmt->execute()){
echo ($stmt->rowCount()>0 ? '成功添加了'.$stmt->rowCount().'条记录':'没有记录被添加');
}else{
exit(print_r($stmt->errorInfo(),true));
}
Correcting teacher：韦小宝Correction time：2019-03-07 09:14:59
Teacher's summary：写的很不错 pdo对数据库的处理目前使用的要比mysqli要多 一定要记得多去练习