Home Backend Development PHP Tutorial Implementation method of paging query function in thinkPHP5 framework

Implementation method of paging query function in thinkPHP5 framework

Mar 28, 2018 am 09:54 AM
php thinkphp5 Query function

This article mainly introduces the method of thinkPHP5 framework to realize the paging query function, and analyzes the related controllers, templates and other operating techniques of thinkPHP5 to realize the paging query function in the form of examples. Friends who need it can refer to it. I hope it can help everyone. .

Admin.php in the controller file


<?php
namespace app\admin\controller;
use think\Controller;
use app\admin\model\Admin as AdminModel;  //使用分页类 取别名解决类名冲突
class Admin extends Controller{
  public function lst(){
/* 分页开始  */
    $list = AdminModel::paginate(3);
    $this -> assign(&#39;list&#39;,$list);
/* 结束 */
    return $this->fetch(&#39;lst&#39;);
  }
  public function add(){
    //判断页面是否提交
    if(request()->isPost()){
      //打印接收到的参数
      //dump(input(&#39;post.&#39;));
      $data = [  //接受传递的参数
        &#39;username&#39; => input(&#39;username&#39;),
        &#39;password&#39; => md5(input(&#39;password&#39;)),
      ];
/*验证开始*/
      $validate = \think\Loader::validate(&#39;Admin&#39;);
            /* scene(&#39;add&#39;) 在add页面添加验证应用  */
      if(!$validate -> scene(&#39;add&#39;)-> check($data)){
        /* 验证失败打印 */
        $this -> error($validate->getError());
        die;
      }
/*结束*/
    /* Db(&#39;表名&#39;) 数据库助手函数*/
      if(Db(&#39;admin&#39;) -> insert($data)){    //添加数据
        return $this->success(&#39;添加成功&#39;,&#39;lst&#39;); //成功后跳转 lst 界面
      }else{
        return $this->error(&#39;添加管理员失败&#39;);
      }
      return;
    }
    return $this->fetch(&#39;add&#39;);
  }
}
Copy after login

Admin.php in the model file


<?php
namespace app\admin\model;
use think\Model;
class Admin extends Model{
}
Copy after login

lst.html


<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8">
    <title>后台</title>
    <style type="text/css">
      *{
        padding: 0;
        margin: 0;
      }
      table{
        width: 500px;
        margin: auto;
      }
      .pagination li{
        margin: 10px;
        float: left;
        list-style: none;
      }
    </style>
  </head>
  <body>
    <p>我是lst</p>
    <a href="{:url(&#39;admin/add&#39;)}" rel="external nofollow" >跳转add</a>
    <table border="1" cellspacing="" cellpadding="">
      <tr>
        <th>ID</th>
        <th>用户名</th>
        <th>操作</th>
      </tr>
      <!-- 循环数据  -->
      {volist name="list" id="vo"}
        <tr>
          <td>{$vo.id}</td>
          <td>{$vo.username}</td>
          <td>Data</td>
        </tr>
      {/volist}
    </table>
    <!-- 分页器 -->
    {$list ->render()}
  </body>
</html>
Copy after login

The above is the detailed content of Implementation method of paging query function in thinkPHP5 framework. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

CakePHP Working with Database CakePHP Working with Database Sep 10, 2024 pm 05:25 PM

Working with database in CakePHP is very easy. We will understand the CRUD (Create, Read, Update, Delete) operations in this chapter.

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

To work on file upload we are going to use the form helper. Here, is an example for file upload.

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

In this chapter, we are going to learn the following topics related to routing ?

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu

CakePHP Creating Validators CakePHP Creating Validators Sep 10, 2024 pm 05:26 PM

Validator can be created by adding the following two lines in the controller.

See all articles