//model层
<?php namespace Home\Model; use Think\Model; //在model中,类名必须和表明一致 class IndexModel extends Model { //定义表名 protected $table = 'Index'; /* 添加 add(); 查询所有 select(); 查询单挑数据 find(); 删除 delete(); 更新 save(); */ public function insert($data){ return M($this->table)->add($data); } //显示所有信息 public function look(){ return M($this->table)->select(); } //查询单条数据 public function find($where){ return M($this->table)->where($where)->find(); } //修改操作 public function update($where,$data){ return M($this->table)->where($where)->save($data); } //删除操作 public function delete($where){ return M($this->table)->where($where)->delete(); } } ?>//控制器
<?php namespace Home\Controller; use Think\Controller; class IndexController extends Controller { public function index(){ $this->display(); } //添加 public function add(){ $res = D('Index')->insert($_POST); if($res){ $this->success('添加成功',U('Index/show')); }else{ $this->error('添加失败'); } } //查询 function show(){ $arr = D('Index')->look(); $this->assign('arr',$arr); $this->display('show'); } //单条查询 function show_one(){ $id = $_GET['id']; $arr = D('Index')->find("id='$id'"); $this->assign('arr',$arr); $this->display('show_one'); } //修改 function update(){ $id= $_POST['id']; $res = D('Index')->update("id='$id'",$_POST); if($res){ $this->success('修改成功!',U('Index/show')); }else{ $this->error('修改失败!'); } } //删除 function delete(){ $id= $_GET['id']; $res = D('Index')->delete("id='$id'"); if($res){ $this->success('删除成功!',U('Index/show')); }else{ $this->error('删除失败!'); } } }//视图层
1:表单添加页面
<form action="__URL__/add/" method="post"> <table> <tr> <td>用户名</td> <td><input type="text" name='username'></td> </tr> <tr> <td>密码</td> <td><input type="password" name='pwd'></td> </tr> <tr> <td></td> <td><input type="submit"></td> </tr> </table> </form>2:展示所有页面
<table border="1"> <tr> <td>编号</td> <td>用户名</td> <td>密码</td> <td>操作</td> </tr> <volist name='arr' id='val'> <tr> <td>{$val.id}</td> <td>{$val.username}</td> <td>{$val.pwd}</td> <td> <a href="__URL__/delete/id/{$val.id}">删除</a> <a href="__URL__/show_one/id/{$val.id}">修改</a> </td> </tr> </volist> </table> //展示单条<form action="__URL__/update/" method="post"> <table> <tr> <td>用户名</td> <td><input type="text" name='username' value="{$arr.username}"></td> </tr> <tr> <td>密码</td> <td><input type="password" name='pwd' value="{$arr.pwd}"></td> </tr> <tr> <td><input type="hidden" name='id' value="{$arr.id}"></td> <td><input type="submit"></td> </tr> </table> </form>