abstract://1.连接数据库,创建pdo对象 $pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8','root','123456'); //2.创建sql语句 $sql = "DELETE FROM `
//1.连接数据库,创建pdo对象 $pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8','root','123456'); //2.创建sql语句 $sql = "DELETE FROM `user` WHERE `user_id`= :user_id "; //3.创建预处理对象$stmt $stmt = $pdo->prepare($sql); //4.参数绑定 $user_id = 5; $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)); }
增加、更新、删除操作大同小异,只需更改sql语句即可。
注意:更新和删除一定要设定条件!!
Correcting teacher:韦小宝Correction time:2018-11-12 09:01:23
Teacher's summary:总结的比较节俭!写的还可以!但是还有提升的空间!继续加油吧!!!