增删查改语句 熟练

$pdo=new PDO('mysql:dbname=study;charset=utf8','root,'123456');

$sql="INSERT IGNORE INTO `user` (`name`,`email`,`age`,`sex`,`phone`)

VALUES (:name, :email, :age, :sex, :phone)";//新增操作

//$sql="SELECT `name`,`age`,`email` FROM`user`WHERE `id`=:id ";//查找 要基于条件

//$sql="UPDATE `user` SET `name`=:name,`email`=:email WHERE `id`=:id";//更新操作

//$sql="DELETE FROM `user` WHERE `id`=:id";//删除操作

$stme=$pdo->prepare($sql);

//列绑定 bindColumn

//$id=1;

//$stmt->bindParam(':id',$id,PDO::PARAM_INT)

//$stmt->bindColumn(1,$name,PDO::PARAM_STR);

//$stmt->bindColumn(2,$age,PDO::PARAM_STR);

//$stmt->bindColumn(3,$email,PDO::PARAM_STR);

//参数绑定 bindParam bindValue 区别bindValue参数可以直接是字面量    

$name='张耳';

$email='759548055@qq.com';

$age='23';

$sex='1;

$phone='13282128678';

$stmt->bindParam(':name',$name,PDO::PARAM_STR,20);

$stmt->bindParam(':email',$email,PDO::PARAM_STR,50);

$stmt->bindParam(':age',$age,PDO::PARAM_INT,3);

$stmt->bindParam(':sex',$sex,PDO::PARAM_STR,2);

$stmt->bindParam(':phone',$phone,PDO::PARAM_INT,11);

//$stmt->execute()

//while($stmt->fetch(PDO::FETCH_BOUND)){

//        echo $name $age $email; 直接输出字符串 列绑定以后

//}

if($stmt->execute())(

    echo ($stmt->rowCount>0) ？ '成功添加' ：'失败'；

)else{

    exit(print_r($stmt->errorInfo(),true));

};