abstract：一、添加操作<?php$pdo = new PDO('mysql:dbname=php_edu','root','root');$sql = "INSERT IGNORE INTO `user` (`name`,`email`,`password`,`status`,`create_time`) VALUES   &nbs

一、添加操作

<?php
$pdo = new PDO('mysql:dbname=php_edu','root','root');

$sql = "INSERT IGNORE INTO `user` (`name`,`email`,`password`,`status`,`create_time`) VALUES
       (:name,:email,:password,:status,:create_time)";

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

$name = '張無忌';
$email = 'zwj@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);

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

二、更新操作
$pdo = new PDO('mysql:dbname=php_edu','root','root');
$sql = "UPDATE `user` SET `email`=:email,`create_time`=:create_time WHERE `id`=:id";

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

$id = 2;
$email = 'yln@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);
if ($stmt->execute()) {
   echo ($stmt->rowCount()>0) ? '成功更新了'.$stmt->rowCount().'條記錄!' : '沒有記錄被更新!';
} else {
   exit(print_r($stmt->errorInfo(),true));
}

三、刪除操作

<?php
$pdo = new PDO('mysql:dbname=php_edu','root','root');
$sql = "DELETE FROM `user` WHERE `id`=:id";
$stmt = $pdo->prepare($sql);
$id = 2;
$stmt->bindParam(':id',$id,PDO::PARAM_INT);
if ($stmt->execute()) {
   echo ($stmt->rowCount()>0) ? '成功刪除了'.$stmt->rowCount().'條記錄!' : '沒有記錄被刪除!';
} else {
   exit(print_r($stmt->errorInfo(),true));
}

Correcting teacher：天蓬老師Correction time：2019-04-10 10:33:18
Teacher's summary：寫操作可以通過rowCount()判斷是否執(zhí)行成功, 查詢操作要麻煩些的