pdo连接数据库

<?php
//1连接数据库创建pdo对象
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');
//2创建预处理对象$stmt

//选择sql语句
$sql = "UPDATE  `user` SET`email`=:email,`creattime`=:creattime  WHERE `user_id`=:user_id";

//3验证sql语句，生成预处理对象
$stmt=$pdo->prepare($sql);
//4参数绑定
$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执行添加}

if ($stmt->execute()){
   echo ($stmt->rowCount()>0 ? '成功添加了'.$stmt->rowCount().'条记录':'没有记录被添加');
}else {
   exit(print_r($stmt->errorInfo(), true));