PHP代码
<?php
namespace app\index\controller;
use phpDocumentor\Reflection\DocBlock\Tags\Param;
use think\Controller;
use think\Request;
class Shijian extends Controller
{
public function index(){
// 从数据库里面提取
$data = db("teacher")->select();
//赋值给前段, 两只蛇
$this->assign("teacher", $data);
//把这个方法return给,展现html
return view();
}
public function view_tianjia(){
$data=db("teacher")->select();
$this->assign("teacher",$data);
return view();
}public function do_tianjia(){
$datas=$_POST;
$res=db("teacher")->insert($_POST);
if ($res){
return "提交成功";
}else{
return "提交失败";
}
}
//从index 页面中点击删除之后的页面, 在index 删除的那个键,href 添加id , 我们后台才知道我们要删除的是哪一个。
//1, 获取id 的值
// 2.把这个id 装到where 里面删除数据库里面该id 的数据,->delete();
//返回删除成功,否则删除失败
public function delete(){
$id=Request::instance()->param("id");
$data=db("teacher")->where("id",$id)->delete();
if($data){
return "删除成功";
}else{
return "删除失败";
}
}
public function view_edit(){
$id=Request::instance()->param("id");
$data=db("teacher")->where("id",$id)->find();
$this->assign("id",$data["id"]);
$this->assign("name",$data["name"]);
$this->assign("sex",$data["sex"]);
$this->assign("username",$data["username"]);
$this->assign("email",$data["email"]);
return view();
}
public function do_edit(){
$id=Request::instance()->param("id");
$datas=$_POST; //接受到前端的所有信息
$data=db("teacher")->where("id",$id)->update($datas);
if ($data){
return "修改成功";
}else{
return "修改失败";
}
}
}
index.html代码
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <table> <tr> <td>序号</td> <td>姓名</td> <td>性别</td> <td>用户名</td> <td>邮箱</td> <td>操作</td> </tr> {volist name="teacher" id="vo"} <tr> <td>{$vo.id}</td> <td>{$vo.name}</td> <td>{$vo.sex}</td> <td>{$vo.username}</td> <td>{$vo.email}</td> <td><a style="margin-right: 10px" href="delete/id/{$vo.id}">删除</a><a href="view_edit/id/{$vo.id}">修改</a></td> </tr> {/volist} </table> </body> </html>
view_tianjia.html<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <div> <form method="post" name="teacher" action="{:url('do_tianjia')}"> 姓名: <input type="text" name="name"><br> 性别: <input type="text" name="sex"><br> 用户名: <input type="text" name="username"><br> 邮箱: <input type="text" name="email"><br> <button>提交</button> </form> </div> </body> </html>
view_edit.html<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form method="post" name="teacher" action="{:url('shijian/do_edit')}"> <label>姓名:</label><input type="text" name="name" value="{$name}"> <label>性别:</label><input type="text" name="sex" value="{$sex}"> <label>用户名:</label><input type="text" name="username" value="{$username}"> <label>邮箱:</label><input type="text" name="email" value="{$email}"> <input type="hidden" name="id" value="{$id}"> <input type="submit" value="修改"> </body> </html>