TP条件查询和分页查询

2023-07-17 19:29:52

一、条件查询

前端页面

<!doctype html>

<html>

<head>

	<meta charset="utf-8">

	<title></title>

    <link href="../../../../../bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css">

</head>

<body>

<div class="panel panel-primary">

    <div class="panel-heading">

        <h3 class="panel-title" style="text-align:center;">汽车详情表</h3>

    </div>

    <div class="panel-body">

	<form action="__ACTION__" method="post" class="form-inline" role="form">

	<div class="form-group">

		<label for="name">请输入关键字：</label>

		<input type="text" class="form-control" placeholder="请输入关键字" name="name"value="{$name}">

		<input type="submit" class="btn btn-primary btn-sm" value="查询"/>

	</div>

		<table class="table" style="width:100%;">

		  <thead>

			<tr>

			  <th>代号</th>

			  <th>名称</th>

			  <th>系列</th>

			  <th>出产时间</th>

			  <th>油耗</th>

			  <th>功率</th>

			  <th>排量</th>

			  <th>价格</th>

			</tr>

		  </thead>

		<foreach name="cars" item="v">

		  <tbody>

			<tr class="danger">

			  <th>{$v.code}</th>

			  <td>{$v.name}</td>

			  <td>{$v.brand}</td>

			  <td>{$v.time}</td>

			  <td>{$v.oil}</td>

			  <td>{$v.powers}</td>

			  <td>{$v.exhaust}</td>

			  <td>{$v.price}</td>

			</tr>

		  </tbody>

		</foreach>

		</table>

	</form>

    </div>

</div>

</body>

</html>

处理页面

<?php

namespace Home\Controller;

use Think\Controller;

class SelectController extends Controller{

    public function select(){

        $db = D("car");

        $tj = " 1=1 ";

        $name = "";//表单中保存查询的关键字

        if(!empty($_POST["name"])){

            $name = $_POST["name"];

            $tj = " name like '%{$name}%' ";

        }

        $arr = $db

            ->where($tj)

            ->select();

        $this->assign("cars",$arr);

        $this->assign("name",$name);//表单中保存查询的关键字

        $this->show();

    }

}

TP条件查询和分页查询

二、条件分页查询

	<div>

		<div>

			<h3 style="text-align:center;">汽车详情表</h3>

		</div>

		<div>

		<form action="__ACTION__" method="get">

		<div>

			<label >请输入关键字：</label>

			<input type="text" placeholder="请输入关键字" name="name" value="{$name}">

			<input type="submit" value="查询"/>

		</div>

			<table  style="width:100%; text-align:center;" border="1" cellpadding="0" cellspacing="0">

			  <thead>

				<tr>

				  <th>代号</th>

				  <th>名称</th>

				  <th>系列</th>

				  <th>出产时间</th>

				  <th>油耗</th>

				  <th>功率</th>

				  <th>排量</th>

				  <th>价格</th>

				</tr>

			  </thead>

			<foreach name="cars" item="v">

			  <tbody>

				<tr class="danger">

				  <th>{$v.code}</th>

				  <td>{$v.name}</td>

				  <td>{$v.brand}</td>

				  <td>{$v.time}</td>

				  <td>{$v.oil}</td>

				  <td>{$v.powers}</td>

				  <td>{$v.exhaust}</td>

				  <td>{$v.price}</td>

				</tr>

			  </tbody>

			</foreach>

			</table>

		</form>

		</div>

	<div>{$pagelist}</div>

</div>

<?php

namespace Home\Controller;

use Think\Controller;

class SelectController extends Controller{

	public function select(){

		$db = D("car");

		$tj = " 1=1 ";

		$name = "";//表单中保存查询的关键字

		if(!empty($_GET["name"])){

			$name = $_GET["name"];

			$tj = " name like '%{$name}%' ";

		}

		$arr = $db

			->where($tj)

			->page($_GET["p"],6)//分页

			->select();

		$zts = $db

			->where($tj)

			->count();//总条数

		$page = new\Think\Page($zts,6);//实例化页数和条数

		$page->setConfig("prev","上一页");//把<<改为上一页

		$page->setConfig("next","下一页");//把>>改为下一页

		$pagelist = $page->show();//分页显示

		$this->assign("pagelist",$pagelist);//往前端传分页数据

		$this->assign("name",$name);//表单中保存查询的关键字

		$this->assign("cars",$arr);

		$this->show();

	}

}

TP条件查询和分页查询

在这里可以修改分页的样式TP条件查询和分页查询

<?php

// +----------------------------------------------------------------------

// | ThinkPHP [ WE CAN DO IT JUST THINK IT ]

// +----------------------------------------------------------------------

// | Copyright (c) 2006-2014 http://thinkphp.cn All rights reserved.

// +----------------------------------------------------------------------

// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )

// +----------------------------------------------------------------------

// | Author: 麦当苗儿 <zuojiazi@vip.qq.com> <http://www.zjzit.cn>

// +----------------------------------------------------------------------

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>',//加css样式可以改变样式

        'prev'   => '<<',

        'next'   => '>>',

        'first'  => '1...',

        'last'   => '...%TOTAL_PAGE%',

        'theme'  => '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% 当前页:%NOW_PAGE% %HEADER% 共:%TOTAL_PAGE%页',//可以添加分页要显示的东西

    );

    /**

     * 架构函数

     * @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>";

    }

}
上一篇：1.AngularJS初探


下一篇：2.4G无线收发模块/射频RFM75调试总结/RF知识整理