参数绑定和输出数据表数据

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