abstrakt：update <?php //1.創(chuàng)建PDO對(duì)象,連接數(shù)據(jù)庫(kù) $pdo = new PDO('mysql:host=127.0.0.1;dbname=php','root','root'); //2 創(chuàng)建SQL語(yǔ)句 $sql = "UPDATE `user`&nb

update
<?php
//1.創(chuàng)建PDO對(duì)象,連接數(shù)據(jù)庫(kù)
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php','root','root');

//2 創(chuàng)建SQL語(yǔ)句
$sql = "UPDATE `user` SET `email` = :email, `create_time` = :create_time WHERE `id` = :id";

//3.驗(yàn)證SQL語(yǔ)句,創(chuàng)建出預(yù)處理對(duì)象
$stmt = $pdo->prepare($sql);

//4.參數(shù)綁定
$id = 3;
$email = 'lwt@php.cn';
$createTime = time();

$stmt->bindParam(':id',$id,PDO::PARAM_INT);
$stmt->bindParam(':email',$email,PDO::PARAM_STR,100);
$stmt->bindParam(':create_time',$createTime,PDO::PARAM_INT);


//5.執(zhí)行更新
if($stmt->execute()){
    echo  ($stmt->rowCount()>0) ? '成功更新了 '.$stmt->rowCount().' 條記錄!' : '沒(méi)有記錄被更新';
}else{
    exit(print_r($stmt->errorInfo(),true));
}

insert

<?php
//1.創(chuàng)建PDO對(duì)象,連接數(shù)據(jù)庫(kù)
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php','root','root');

//2 創(chuàng)建SQL語(yǔ)句
$sql = "INSERT INTO `user` (`name`,`email`,`password`,`status`,`create_time`) VALUES (:name,:email,:password,:status,:create_time) ";

//3.驗(yàn)證SQL語(yǔ)句,創(chuàng)建出預(yù)處理對(duì)象
$stmt = $pdo->prepare($sql);

//4.參數(shù)綁定
$name = '東方不敗';
$email = 'dfbb@php.cn';
$password = 'sha1(123456)';
$status = 1;
$createTime = time();

$stmt->bindParam(':name',$name,PDO::PARAM_STR,20);
$stmt->bindParam(':email',$email,PDO::PARAM_STR,100);
$stmt->bindParam(':password',$password,PDO::PARAM_STR,40);
$stmt->bindParam(':status',$status,PDO::PARAM_INT);
$stmt->bindParam(':create_time',$createTime,PDO::PARAM_INT);


//5.執(zhí)行添加
if($stmt->execute()){
  echo  ($stmt->rowCount()>0) ? '成功添加了 '.$stmt->rowCount().' 條記錄!' : '沒(méi)有記錄被添加';
}else{
    exit(print_r($stmt->errorInfo(),true));
}

delete
<?php
//創(chuàng)建PDO對(duì)象 連接數(shù)據(jù)庫(kù)
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php','root','root');

//創(chuàng)建SQL語(yǔ)句
$sql = 'DELETE FROM `user` WHERE `id` = :id';

//3. 驗(yàn)證SQL語(yǔ)句,創(chuàng)建出預(yù)處理對(duì)象
$stmt = $pdo->prepare($sql);

//4.參數(shù)綁定
$id = 1;

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

//5.執(zhí)行刪除
if($stmt->execute()){
    echo ($stmt->rowCount()>0) ? '成功刪除了' .$stmt->rowCount().'條記錄!' : '沒(méi)有記錄被刪除';
}else{
    exit(print_r($stmt->errorInfo(),true));
}

Korrigierender Lehrer：天蓬老師Korrekturzeit：2019-04-22 10:18:38
Zusammenfassung des Lehrers：$stmt->bindParam(':name',$name,PDO::PARAM_STR,20); $stmt->bindParam(':email',$email,PDO::PARAM_STR,100); $stmt->bindParam(':password',$password,PDO::PARAM_STR,40); $stmt->bindParam(':statu