abstract：数据表：增加数据操作：<?php require 'demo21.php'; //2、写sql语句 $sql = "insert into user(name,sex,age,email,password,status,creat_time)values(:name,:sex,:age,:email,:passwor
数据表：
增加数据操作：
<?php
require 'demo21.php';
//2、写sql语句
$sql = "insert into user(name,sex,age,email,password,status,creat_time)values(:name,:sex,:age,:email,:password,:status,:creat_time)";
//3验证sql语句
$stmt = $pdo->prepare($sql);
//4、参数绑定
$name = '小王';
$sex = '1';
$age = '26';
$email = '403280636@qq.com';
$password = sha1('123456');
$status = '1';
$creatTime = time();
$stmt->bindParam(':name', $name, PDO::PARAM_STR, 20);
$stmt->bindParam(':sex', $sex, PDO::PARAM_INT, 2);
$stmt->bindParam(':age', $age, PDO::PARAM_INT, 4);
$stmt->bindParam(':email', $email, PDO::PARAM_STR, 50);
$stmt->bindParam(':password', $password, PDO::PARAM_STR, 100);
$stmt->bindParam(':status', $status, PDO::PARAM_INT, 1);
$stmt->bindParam(':creat_time', $creatTime, PDO::PARAM_INT, 15);
//5.执行添加
if ($stmt->execute()) {
echo ($stmt->rowCount() > 0) ? '添加成功' : '添加失败';
} else {
exit(print_r($stmt->errorInfo(),true).'添加失败');
}删除数据操作：
<?php
require 'demo21.php';
//2、写sql语句
$sql = "DELETE from user where id=:id ";
//3验证sql语句
$stmt = $pdo->prepare($sql);
//4、参数绑定
$id=11;
$creatTime = time();
$stmt->bindParam(':id', $id, PDO::PARAM_INT, 2);
//5.执行添加
if ($stmt->execute()) {
echo ($stmt->rowCount() > 0) ? '删除成功' : '删除失败'.'成功删除了'.$stmt->rowCount().'条数据';
} else {
exit(print_r($stmt->errorInfo(),true).'删除失败');
}修改数据操作：
<?php
require 'demo21.php';
//2、写sql语句
$sql = "UPDATE user set email=:email,creat_time=:creat_time where id=:id";
//3验证sql语句
$stmt = $pdo->prepare($sql);
//4、参数绑定
$id=2;
$email = '578869763@qq.com';
$creatTime = time();
$stmt->bindParam(':id', $id, PDO::PARAM_INT, 2);
$stmt->bindParam(':email', $email, PDO::PARAM_STR, 50);
$stmt->bindParam(':creat_time', $creatTime, PDO::PARAM_INT, 15);
//5.执行添加
if ($stmt->execute()) {
echo ($stmt->rowCount() > 0) ? '修改成功' : '添加失败'.'成功修改了'.$stmt->rowCount().'条数据';
} else {
exit(print_r($stmt->errorInfo(),true).'修改失败');
}查询数据操作：
<?php
//require 'demo21.php';
try{
$pdo=new PDO('mysql:host=localhost;dbname=edu','root','root');
}catch (Exception $e){
exit($e->getMessage());
}
$sql="select id,name,sex,age,creat_time from user where status=:status";
$stmt=$pdo->prepare($sql);
$stmt->execute([':status'=>1]);
$result=$stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<style>
table{width: 600px;border: #ccc solid;border-spacing:0px;}
table td{width:20%;white-space:nowrap;height: 30px;line-height: 30px;text-align: center;border: 1px solid #ccc}
table tr:nth-child(odd){background-color: #9acfea}
</style>
<table cellpadding="0" cellspacing="0">
<tr>
<th>id</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>注册时间</th>
</tr>
<?php foreach($result as $k=>$v): ?>
<tr>
<td><?php echo $v['id'] ?></td>
<td><?php echo $v['name'] ?></td>
<td><?php echo $v['sex'] ?></td>
<td><?php echo $v['age'] ?></td>
<td><?php echo date('Y-h-d',$v['creat_time'])?></td>
</tr>
<?php
endforeach;
?>
</table>
Correcting teacher：天蓬老师Correction time：2019-02-18 13:48:42
Teacher's summary：如果参数较多, 并且并不是从外部传入的话, 你这样写有点麻烦:
$name = '小王';
$sex = '1';
$age = '26';
$email = '403280636@qq.com';
$password = sha1('123456');
$status = '1';
$creatTime = time();
$stmt->bindParam(':name', $name,