正文
tp5增删改查
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
tp5框架增删改查，相对于以前的源生代码而言，非常简单，主要是为了熟练的应用框架，下面的代码主要是tp5框架的增删改查，让我们的更好 掌握框架。
<?php
namespace app\index\controller;
use think\Controller;
use think\Db;
use think\Request;
class Index extends Controller
{
public function index(){
return view("index");
}
//添加
public function add(){
$data = Request::instance()->param();
$res = Db::table('yun')->insert($data);
if($res){
return $this->success("添加成功","show");
}else{
return $this->success("添加失败","index");
}
}
//展示
public function show(){
$data = Db::table("yun")->order('id asc')->select();
return view("show",['data'=>$data]);
}
//删除
public function del(){
$id=Request::instance()->param("id");
$res=Db::table("yun")->where('id',$id)->delete();
if($res){
return $this->success("删除成功","show");
}else{
return $this->success("删除失败","show");
}
}
//查询单条数据
public function update(){
$id=Request::instance()->param("id");
$data = Db::table("yun")->where('id',$id)->find();
return view("update",['data'=>$data]);
}
//修改
public function updates(){
$id=Request::instance()->param("id");
$data=Request::instance()->param();
$res=Db::table("yun")->where('id',$id)->update($data);
if($res){
return $this->success("修改成功","show");
}else{
return $this->success("修改失败","show");
}
}
}
表单的提交
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<center>
<form action="{:url('index/add')}" method="post">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="age"></td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="address"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="添加"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
数据的展示
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<center>
<table>
<tr>
<td>ID</td>
<td>姓名</td>
<td>性别</td>
<td>年龄</td>
<td>地址</td>
<td>操作</td>
</tr>
{volist name="data" id="vo"}
<tr>
<td>{$vo.id}</td>
<td>{$vo.name}</td>
<td class="sex" id="{$vo.id}">
{if condition="$vo.sex eq 0 "} 男
{elseif condition="$vo.sex eq 1"}女
{/if}
</td>
<td>{$vo.age}</td>
<td>{$vo.address}</td>
<td>
<a href="{:url('index/del')}?id={$vo.id}">删除</a>
<a href="{:url('index/update')}?id={$vo.id}">修改</a>
</td>
</tr>
{/volist}
</table>
</center>
</body>
</html>
单条数据的遍历
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<center>
<form action="{:url('index/updates')}" method="post">
<input type="hidden" name="id" value="{$data['id']}">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="name" value="{$data['name']}"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="age" value="{$data['age']}"></td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="address" value="{$data['address']}"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="修改"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
