abstract://数据库的删除操作//1.创建PDO对象连接数据库$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');//2.创建SQL语句$sql="DELETE FROM `user` WHERE `user_id`=:user_id";//3.验证SQL语
//数据库的删除操作
//1.创建PDO对象连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');
//2.创建SQL语句
$sql="DELETE FROM `user` WHERE `user_id`=:user_id";
//3.验证SQL语句
$stmt=$pdo->prepare($sql);
//4.参数绑定
$user_id=10;
$stmt->bindParam(':user_id',$user_id,PDO::PARAM_INT);
//5.执行删除
if ($stmt->execute()) {
echo ($stmt->rowCount()>0) ? '成功删除了'.$stmt->rowCount().'条记录!' : '没有记录被删除!';
} else {
exit(print_r($stmt->errorInfo(),true));
}
//数据库的更新操作
//1.创建PDO对象连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');
//2.创建SQL语句
$sql="UPDATE `user` SET `emall`=:emall,`create_time`=:create_time WHERE `user_id`=:user_id";
//3.验证SQL语句
$stmt=$pdo->prepare($sql);
//4.参数绑定
$user_id=10;
$emall='dwxabc@268.com';
$create_time=time();
$stmt->bindParam(':user_id',$user_id,PDO::PARAM_INT);
$stmt->bindParam(':create_time', $create_time,PDO::PARAM_INT);
//5.执行更新
if ($stmt->execute()) {
echo ($stmt->rowCount()>0) ? '成功更新了'.$stmt->rowCount().'条记录!' : '没有记录被更新!';
} else {
exit(print_r($stmt->errorInfo(),true));
}
Correcting teacher:天蓬老师Correction time:2018-11-12 07:40:06
Teacher's summary:很好, 可以想一下,如何要想知道,一共查询出了多少条记录 ,应该如何做呢?