thinkphp6: 数据库查询分页(thinkphp 6.0.9/php 8.0.14)

一，编写model和controller代码

1,model/Article.php

<?php
declare (strict_types = 1);
 
namespace app\model;
 
use think\Model;
use think\facade\Db;
 
/**
* @mixin \think\Model
*/
class Article extends Model
{
    //类名与表名不一致时在这里指定数据表名
    protected $table = "media";
 
   //page:当前页
   //size: 每页的数量
    public function getPageMedia($page,$size) {
        //分页查询时用paginate方法
        $result = Db::table("media")->where("isSale",1)->order(['isSale'=>'asc','id'=>'desc'])->paginate(['list_rows'=> $size, 'page' => $page]);
        return $result;
    }
}

2,controller/Article.php

<?php
declare (strict_types = 1);
 
namespace app\controller;
 
use app\BaseController;
use app\result\Result;
use think\Request;
use think\facade\Cache;
use app\model\Article as ArticleModel;
 
class Article extends BaseController
{
    //分页查询多条media记录
    public function pageMedia() {
        $page = $this->request->param('page',1,'intval');
        $size = $this->request->param('size',1,'intval');
 
        $article = new ArticleModel();
        $rows = $article->getPageMedia($page,$size);
 
        if (sizeof($rows) == 0) {
            return Result::Error(1,"没有符合条件的数据");
        } else {
            return Result::Success($rows);
        }
    }
}

3,Result.php

<?php
 
namespace app\result;
 
use think\response\Json;
 
class Result {
    //success
    static public function Success($data):Json {
        $rs = [
            'code'=>0,
            'msg'=>"success",
            'data'=>$data,
        ];
        return json($rs);
    }
    //error
    static public function Error($code,$msg):Json {
        $rs = [
            'code'=>$code,
            'msg'=>$msg,
            'data'=>"",
        ];
        return json($rs);
    }
}

说明：刘宏缔的架构森林是一个专注架构的博客，地址：https://www.cnblogs.com/architectforest

         对应的源码可以访问这里获取： https://github.com/liuhongdi/
         或: https://gitee.com/liuhongdi

说明：作者:刘宏缔 邮箱: 371125307@qq.com 

二，测试效果

访问:

http://127.0.0.1:8000/article/pagemedia?page=1&size=2

返回:

 

三，查看php和thinkphp的版本:

php:

root@lhdpc:~# php --version
PHP 8.0.14 (cli) (built: Dec 23 2021 11:52:42) ( NTS )
Copyright (c) The PHP Group
Zend Engine v4.0.14, Copyright (c) Zend Technologies
    with Zend OPcache v8.0.14, Copyright (c), by Zend Technologies

thinkphp:

root@lhdpc:~# cd /data/php/admapi/
root@lhdpc:/data/php/admapi# php think version
v6.0.9