TP搜索，分页（保留搜索条件）简单实现

来源：互联网发布：程序员论坛排行榜编辑：程序博客网时间：2024/05/19 22:25
TP搜索，分页（保留搜索条件）

Controller层/控制器层/VoController.class.php<?php/** * @author        xiaozhang * * @email         915752851@qq.com * * @information  Vo grade */namespace Home\Controller;use Think\Controller;class VoController extends Controller {    public function index(){        if(IS_GET){            $this->display();        }        if(IS_POST){             $data = array(                 'name' => I('username'),                 'sort' => I('sort'),             );            $res = M('Vo')->add($data);            if($res){                $this->success("提交成功",U('Vo/show'));            }else{                $this->error("提交失败");            }        }    }    public function show(){        $where = "1=1";        if(!empty($username = I("username"))){            $where .= "  and username = '$username'";        }        if(!empty($sort = I("sort"))){            $where .= "  and sort = '$sort'";        }        $Vo = M('Vo'); // 实例化Vo对象        $count      = $Vo->where($where)->count();   // 查询满足要求的总记录数        $Page       = new \Think\Page($count,2);    // 实例化分页类        // 传入总记录数和每页显示的记录数(25)        $show       = $Page->show();                // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性        $list = $Vo->where($where)->order('id')->limit($Page->firstRow.','.$Page->listRows)->select();        $this->assign('list',$list);                // 赋值数据集        $this->assign('username',$username);        $this->assign('sort',$sort);        $this->assign('page',$show);                // 赋值分页输出        $this->display();                           // 输出模板    }}View层/视图层/index.html添加index.html<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>Title</title></head><body><form action="{:U('Home/Vo/index')}" method="post">    <table>        <tr>            <td>学生姓名</td>            <td><input type="text" name="username"></td>        </tr>        <tr>            <td>学生学号</td>            <td><input type="text" name="sort"></td>        </tr>        <tr>            <td colspan="2"><input type="submit" value="提交"></td>        </tr>    </table></form></body></html>View层/视图层/show.html<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>Title</title></head><script style="__PUBLIC__/Home/js/jquery.js"></script><style>    td{width: 180px;text-align: center}    .num, .current, .prev{margin-left: 15px;}</style><body><center>    <form action="{:U('Home/Vo/show')}" method="get">    姓名：<input type="text" name="username" value="{$username}">    学号：<input type="text" name="sort"  value="{$sort}">    <input type="submit" value="搜索">    </form>    <table>        <tr>            <td>id</td>            <td>姓名</td>            <td>学号</td>            <td>操作</td>        </tr>        <foreach name="list" item="vo">        <tr>            <td>{$vo.id}</td>            <td>{$vo.username}</td>            <td>{$vo.sort}</td>            <td><a href="">删除</a> | <a href="">修改</a></td>        </tr>        </foreach>    </table>{$page}</center></body></html>
这里写图片描述
阅读全文
1 0