摘要：<?php date_default_timezone_set('PRC'); //PDO之添加操作 // 1.创建PDO对象，连接数据库 try { $pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8', 'ro
<?php
date_default_timezone_set('PRC');
//PDO之添加操作
// 1.创建PDO对象，连接数据库
try {
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8', 'root', 'root');
} catch (PDOException $e) {
exit($e->getMessage());
}
//2.创建预处理对象STMT
$sql = 'INSERT INTO `user` (`name`,`email`,`password`,`status`,`create_time`) VALUES (:name,:email,:password,:status,:create_time)';
$stmt = $pdo->prepare($sql);
//3.参数绑定
$name = '东方侠';
$email = 'dfbb@php.cn';
$password = sha1('123456');
$status = 1;
$createTime = date('Y-m-d H:m:s', time());
$stmt->bindParam(':name', $name, PDO::PARAM_STR, 20);
$stmt->bindParam(':email', $email, PDO::PARAM_STR, 100);
$stmt->bindParam(':password', $password, PDO::PARAM_STR, 20);
$stmt->bindParam(':status', $status, PDO::PARAM_INT);
$stmt->bindParam(':create_time', $createTime, PDO::PARAM_INT);
//4.执行
if ($stmt->execute()) {
echo ($stmt->rowCount() > 0) ? '成功添加了 '.$stmt->rowCount().'条记录!' : '没有记录被添加';
} else {
exit(print_r($stmt->errorInfo(), true));
}
//5.释放结果集
$stmt = null;
//6.关闭连接
$pdo = null;<?php
//PDO之更新操作
// 1.创建PDO对象，连接数据库
try {
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8', 'root', 'root');
} catch (PDOException $e) {
exit($e->getMessage());
}
//2.创建预处理对象STMT
$sql = 'UPDATE `user` SET `email`=:email,`create_time`=:create_time WHERE `user_id`=:user_id';
$stmt = $pdo->prepare($sql);
//3.参数绑定
$id = 17;
$email = 'east@php.cn';
$createTime = time();
$stmt->bindParam(':user_id', $id, PDO::PARAM_INT);
$stmt->bindParam(':email', $email, PDO::PARAM_STR, 100);
$stmt->bindParam(':create_time', $createTime, PDO::PARAM_INT);
//4.执行更新操作
if ($stmt->execute()) {
echo ($stmt->rowCount() > 0) ? '成功更新了 '.$stmt->rowCount().'条记录!' : '没有记录被更新';
} else {
exit(print_r($stmt->errorInfo(), true));
}
//5.释放结果集
$stmt = null;
//6.关闭连接
$pdo = null;
<?php
//PDO之删除操作
// 1.创建PDO对象，连接数据库
try {
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8', 'root', 'root');
} catch (PDOException $e) {
exit($e->getMessage());
}
//2.创建预处理对象STMT
$sql = 'DELETE FROM `user` WHERE `user_id`=:user_id';
$stmt = $pdo->prepare($sql);
//3.参数绑定
$id = 38;
$email = 'east@php.cn';
$stmt->bindParam(':user_id', $id, PDO::PARAM_INT);
//4.执行删除操作
if ($stmt->execute()) {
echo ($stmt->rowCount() > 0) ? '成功删除了 '.$stmt->rowCount().'条记录!' : '没有记录被删除';
} else {
exit(print_r($stmt->errorInfo(), true));
}
//5.释放结果集
$stmt = null;
//6.关闭连接
$pdo = null;
批改老师：天蓬老师批改时间：2019-04-08 09:20:48
老师总结：pdo的操作, 看上去语句很多, 其实很有规律的, 很好记, 不是吗?
