数据表的增删改功能

abstract：<?php/** * PDO 添加操作 *///1.创建PDO对象，连接数据库$pdo = new PDO('mysql:host=127.0.0.1;dbname=lianxi','root','root');//2.创建SQL语句$sql = "INSERT INTO `user` (`name`,`email`,`passwor

<?php
/**
* PDO 添加操作
*/

//1.创建PDO对象，连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=lianxi','root','root');

//2.创建SQL语句
$sql = "INSERT INTO `user` (`name`,`email`,`password`,`status`,`create_time`) VALUE (:name,:email,:password,:status,:create_time)";

//3.验证SQL语句，创建出预处理对象
$stmt = $pdo->prepare($sql);

//4.参数绑定
$name = '陈昊';
$email = 'ch@qq.com';
$password = sha1('123456');
$status = 1;
$create_time = 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',$create_time,PDO::PARAM_INT);


//5.执行添加
if ($stmt->execute()){
   echo ($stmt->rowCount()>0) ? '成功添加了' . $stmt->rowCount() . '条记录!' : '没有添加记录';
}else{
  exit( print_r($stmt->errorInfo(),true));
}

<?php
/**
* PDO 更新操作（编辑/修改）
*/

//1.创建PDO对象，连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=lianxi','root','root');

//2.创建SQL语句
$sql = "UPDATE `user` SET `email`=:email,`create_time`=:create_time WHERE `user_id` = :user_id";

//3.验证SQL语句，创建出预处理对象
$stmt = $pdo->prepare($sql);

//4.参数绑定
$user_id = 14;
$email = 'ch@php22.com';
$create_time = time();

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


//5.执行更新
if ($stmt->execute()){
   echo ($stmt->rowCount()>0) ? '成功更新了' . $stmt->rowCount() . '条记录!' : '没有更新记录';
}else{
   exit( print_r($stmt->errorInfo(),true));
}

<?php
/**
* PDO 删除操作
*/

//1.创建PDO对象，连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=lianxi','root','root');

//2.创建SQL语句
$sql = "DELETE FROM `user` WHERE `user_id` = :user_id";

//3.验证SQL语句，创建出预处理对象
$stmt = $pdo->prepare($sql);

//4.参数绑定
$user_id = 14;


$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));
}

Correcting teacher：天蓬老师Correction time：2019-01-10 16:41:48
Teacher's summary：exit( print_r($stmt->errorInfo(),true)); 知道为什么要这么写吗?