thinkphp带搜索条件分页小demo

时间:2022-10-27 17:33:43

1)前台html模板页面:

<html>
<head>
    <title>ThinkPHP带搜索条件分页</title>
    <script type="text/javascript" src="__ROOT__/statics/js/jquery.js"></script>
    <link rel="stylesheet" href="__ROOT__/statics/js/page.css"/>
</head>
<script language="JavaScript">
    $(function () {
        $('#sub').bind('click',function(){
            $("#form").attr("action", "__URL__/test1/p/1");
            $('#form1').submit();
        });
        // 分页(修改链接方法)
        $('.pages a').click(function(){
            var tmpHref = $(this).attr('href');
            tmpHref = tmpHref.replace(/\/selCon\//,"");
            $("#form1").attr("action", tmpHref);
            $("#form1").submit();
            return false;
        });
    })
</script>
<body>
<div>
    <form action="__URL__/test1" method="post" id="form1">
        <input type="text" name="post_title" id="title" value="{$post_title}"/>
        <select name="post_status" id="">
            <option value="0" <if condition="$post_status eq 0"> selected</if> >--状态--</option>
            <option value="1" <if condition="$post_status eq 1"> selected</if> >1</option>
            <option value="2" <if condition="$post_status eq 2"> selected</if> >2</option>
            <option value="3" <if condition="$post_status eq 3"> selected</if> >3</option>
        </select>
        <input type="button" name="sub" id="sub" value="确定"/><br/>
    </form>
    <volist name="list" id="vo">
        <p>{$vo.post_title} ---- {$vo.post_modified} --status:{$vo.post_status}</p>
    </volist>
</div>
<div class="green-black">
    {$page}
</div>
</body>
</html>

2)后台控制器方法(所用分页类tp3.2.2):

public function test1()
    {
        $User = M('posts'); // 实例化User对象
        if(!empty($_POST['post_title'])){
            $map['post_title']=$_POST['post_title'];
        }
        if(!empty($_POST['post_status'])){
            $map['post_status']=$_POST['post_status'];
        }
        $count = $User->where($map)->count();

     $Page = new \Think\Page($count,2);
        //设置分页样式
        $Page->setConfig('prev','上一页');
        $Page->setConfig('next','下一页');
     // 实例化分页类 传入总记录数和每页显示的记录数(25)
        $Page -> setConfig("theme","%HEADER% %NOW_PAGE%/%TOTAL_PAGE%页 %FIRST% %UP_PAGE% %DOWN_PAGE% %LINK_PAGE% %END%");
        $show = $Page->show(); // 分页显示输出
        // 进行分页数据查询 注意limit方法的参数要使用Page类的属性
        $list = $User->order('id')->where($map)->limit($Page->firstRow.','.$Page->listRows)->select();
        $this->assign('list',$list);
        // 赋值数据集
        $this->assign('page',$show);
        $this->assign('post_title',$_POST['post_title']);
        $this->assign('post_status',$_POST['post_status']);

        $this->display(":test1");
    }
thinkphp带搜索条件分页小demothinkphp带搜索条件分页小demo
<?php

namespace Think;

class Page{
    public $firstRow; // 起始行数
    public $listRows; // 列表每页显示行数
    public $parameter; // 分页跳转时要带的参数
    public $totalRows; // 总行数
    public $totalPages; // 分页总页面数
    public $rollPage   = 11;// 分页栏每页显示的页数
    public $lastSuffix = true; // 最后一页是否显示总页数

    private $p       = 'p'; //分页参数名
    private $url     = ''; //当前链接URL
    private $nowPage = 1;

    // 分页显示定制
    private $config  = array(
        'header' => '<span class="rows">共 %TOTAL_ROW% 条记录</span>',
        'prev'   => '<<',
        'next'   => '>>',
        'first'  => '1...',
        'last'   => '...%TOTAL_PAGE%',
        'theme'  => '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%',
    );

    /**
     * 架构函数
     * @param array $totalRows  总的记录数
     * @param array $listRows  每页显示记录数
     * @param array $parameter  分页跳转的参数
     */
    public function __construct($totalRows, $listRows=20, $parameter = array()) {
        C('VAR_PAGE') && $this->p = C('VAR_PAGE'); //设置分页参数名称
        /* 基础设置 */
        $this->totalRows  = $totalRows; //设置总记录数
        $this->listRows   = $listRows;  //设置每页显示行数
        $this->parameter  = empty($parameter) ? $_GET : $parameter;
        $this->nowPage    = empty($_GET[$this->p]) ? 1 : intval($_GET[$this->p]);
        $this->nowPage    = $this->nowPage>0 ? $this->nowPage : 1;
        $this->firstRow   = $this->listRows * ($this->nowPage - 1);
    }

    /**
     * 定制分页链接设置
     * @param string $name  设置名称
     * @param string $value 设置值
     */
    public function setConfig($name,$value) {
        if(isset($this->config[$name])) {
            $this->config[$name] = $value;
        }
    }

    /**
     * 生成链接URL
     * @param  integer $page 页码
     * @return string
     */
    private function url($page){
        return str_replace(urlencode('[PAGE]'), $page, $this->url);
    }

    /**
     * 组装分页链接
     * @return string
     */
    public function show() {
        if(0 == $this->totalRows) return '';

        /* 生成URL */
        $this->parameter[$this->p] = '[PAGE]';
        $this->url = U(ACTION_NAME, $this->parameter);
        /* 计算分页信息 */
        $this->totalPages = ceil($this->totalRows / $this->listRows); //总页数
        if(!empty($this->totalPages) && $this->nowPage > $this->totalPages) {
            $this->nowPage = $this->totalPages;
        }

        /* 计算分页零时变量 */
        $now_cool_page      = $this->rollPage/2;
        $now_cool_page_ceil = ceil($now_cool_page);
        $this->lastSuffix && $this->config['last'] = $this->totalPages;

        //上一页
        $up_row  = $this->nowPage - 1;
        $up_page = $up_row > 0 ? '<a class="prev" href="' . $this->url($up_row) . '">' . $this->config['prev'] . '</a>' : '';

        //下一页
        $down_row  = $this->nowPage + 1;
        $down_page = ($down_row <= $this->totalPages) ? '<a class="next" href="' . $this->url($down_row) . '">' . $this->config['next'] . '</a>' : '';

        //第一页
        $the_first = '';
        if($this->totalPages > $this->rollPage && ($this->nowPage - $now_cool_page) >= 1){
            $the_first = '<a class="first" href="' . $this->url(1) . '">' . $this->config['first'] . '</a>';
        }

        //最后一页
        $the_end = '';
        if($this->totalPages > $this->rollPage && ($this->nowPage + $now_cool_page) < $this->totalPages){
            $the_end = '<a class="end" href="' . $this->url($this->totalPages) . '">' . $this->config['last'] . '</a>';
        }

        //数字连接
        $link_page = "";
        for($i = 1; $i <= $this->rollPage; $i++){
            if(($this->nowPage - $now_cool_page) <= 0 ){
                $page = $i;
            }elseif(($this->nowPage + $now_cool_page - 1) >= $this->totalPages){
                $page = $this->totalPages - $this->rollPage + $i;
            }else{
                $page = $this->nowPage - $now_cool_page_ceil + $i;
            }
            if($page > 0 && $page != $this->nowPage){

                if($page <= $this->totalPages){
                    $link_page .= '<a class="num" href="' . $this->url($page) . '">' . $page . '</a>';
                }else{
                    break;
                }
            }else{
                if($page > 0 && $this->totalPages != 1){
                    $link_page .= '<span class="current">' . $page . '</span>';
                }
            }
        }

        //替换分页内容
        $page_str = str_replace(
            array('%HEADER%', '%NOW_PAGE%', '%UP_PAGE%', '%DOWN_PAGE%', '%FIRST%', '%LINK_PAGE%', '%END%', '%TOTAL_ROW%', '%TOTAL_PAGE%'),
            array($this->config['header'], $this->nowPage, $up_page, $down_page, $the_first, $link_page, $the_end, $this->totalRows, $this->totalPages),
            $this->config['theme']);
        return "<div>{$page_str}</div>";
    }
}
page.class.php