tp增删改查

//model层

<?php 
namespace HomeModel;
use ThinkModel;
//在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 HomeController;
use ThinkController;
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>

<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>