abstrak：<?phpheader('content-type:text/html;charset=utf-8');//創(chuàng)建pdo連接數(shù)據(jù)庫$pdo = new PDO('mysql:host=127.0.0.1;dbname=stu','root','root');//創(chuàng)建sql$sql ="INSERT INTO `user`

<?php

header('content-type:text/html;charset=utf-8');

//創(chuàng)建pdo連接數(shù)據(jù)庫

$pdo = new PDO('mysql:host=127.0.0.1;dbname=stu','root','root');

//創(chuàng)建sql

$sql ="INSERT INTO `user` (`username`,`sex`,`age`,`email`,`status`) VALUES (:username,:sex,:age,:email,:status)";

//3.驗(yàn)證sql語句創(chuàng)建預(yù)處理對(duì)象stmt

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

//參數(shù)綁定
$username = '沙迦';
$sex = '男';
$age = 25;
$email = 'sj@qq.com';
$status = -1;

$stmt->bindParam(':username',$username,PDO::PARAM_STR,20);
$stmt->bindParam(':sex',$sex,PDO::PARAM_STR,4);
$stmt->bindParam(':age',$age,PDO::PARAM_INT);
$stmt->bindParam(':email',$email,PDO::PARAM_STR,50);
$stmt->bindParam(':status',$status,PDO::PARAM_STR ,4);

if($stmt->execute()){
   echo ($stmt->rowCount()>0) ? '成功添加了'.$rowCount().' 條記錄' : '沒有記錄';
}else{
   exit(print_r($stmt->errorInfo(),true));
};

？>

<?php
header('content-type:text/html;charset=utf-8');
/**
* Created by PhpStorm.
* User: guanzhiyu
* Date: 2019/4/9
* Time: 15:53
* 八、PDO更新操作
* rowCount()方法：返回受影響的記錄數(shù)量
* errorInfo():返回出錯(cuò)信息（數(shù)組格式）
*/

//創(chuàng)建pdo鏈接數(shù)據(jù)庫
$pdo = new PDO('mysql:host=127.0.0.1;dbname=stu','root','root');
//創(chuàng)建sql;
$sql = "UPDATE `user` SET `email`=:email  WHERE `id` = :user_id";
//創(chuàng)建預(yù)處理對(duì)象
$stmt = $pdo->prepare($sql);
//4參數(shù)綁定
$id = 4;
$email = 's@qq.com';
$stmt->bindParam(':user_id',$id ,PDO::PARAM_INT);
$stmt->bindParam(':email',$email,PDO::PARAM_STR,40);

if($stmt->execute()){
   echo ($stmt->rowCount()>0) ? '成功更新了' . $stmt->rowCount() .'條數(shù)據(jù)' : '沒有更新記錄';
}else{
   exit(print_r($stmt->errorInfo(),true));
}

<?php
header('content-type:text/html;charset=utf-8');
/**
* Created by PhpStorm.
* User: guanzhiyu
* Date: 2019/4/9
* Time: 19:33
* 九、PDO刪除操作
* 刪除操作是最微信的寫操作;
* 在實(shí)際開發(fā)過程，我們都是使用軟刪除實(shí)現(xiàn)；
* 軟刪除就是利用更新模擬刪除操作，通過刪除標(biāo)記字段來解決；
* 刪除操作，必須基于條件，絕對(duì)禁止無條件刪除；
* 如果想清空表中數(shù)據(jù)，請(qǐng)使用：TRUNCATE TABLE 命令；
*/
//創(chuàng)建pdo鏈接數(shù)據(jù)庫
$pdo = new PDO('mysql:host=127.0.0.1;dbname=stu','root','root');
//創(chuàng)建sql;
$sql = "DELETE FROM `user` WHERE `id` = :user_id";
//創(chuàng)建預(yù)處理對(duì)象
$stmt = $pdo->prepare($sql);
//4參數(shù)綁定
$id = 4;
$email = 's@qq.com';
$stmt->bindParam(':user_id',$id ,PDO::PARAM_INT);


if($stmt->execute()){
   echo ($stmt->rowCount()>0) ? '成功刪除了' . $stmt->rowCount() .'條數(shù)據(jù)' : '沒有記錄被刪除';
}else{
   exit(print_r($stmt->errorInfo(),true));
}

Guru membetulkan：天蓬老師Masa pembetulan：2019-04-10 09:41:25
Rumusan guru：刪除操作, 是最危險(xiǎn)的操作之下, 而且是物理刪除,所以必須要有條件, 要當(dāng)心