【Uniapp小程序】实现上滑加载分页（触底加载）附后端Thinkphp代码

$query_total=DB::table('book')->where(["class_id"=>$class_id])->paginate($per_page);
 查询符合条件的总记录总数
 $class=DB::table('book')->where(["class_id"=>$class_id])->limit($page,$per_page)->select();
 查询limit限制后的数据
 注意：thinkphp中 limit(a,b)表示从第a行的b条数据

//依据分类查询图书
    public function query_book_by_classid(){
        $token=input('token');
        $class_id=input('class_id');
        $page=input('page');//起始行
        $per_page=input('per_page');//每页数据
        $redis = new Redis();
        $result= $redis->get($token);
       if ($result) {
        //   limit(a,b)从第a行的b条数据 
              $query_total=DB::table('book')->where(["class_id"=>$class_id])->paginate($per_page);
              $class=DB::table('book')->where(["class_id"=>$class_id])->limit($page,$per_page)->select();
              $coun=ceil($query_total->total()/$per_page);
        die(
        json_encode(
            array(
            'code' => 200,
            'total' => $coun,
            'data' => $class,
            'msg' => '获取成功'
        ),480)
);
       } 
       else {
           die(
        json_encode(
            array(
            'code' => 100,
            'data'=>'',
            'msg' => 'token失效或不存在！请重新获取'
        ),480)
);
       }
    }

onReachBottom() {
    console.log("我被触发了");
    },

<script>
  export default {
    data() {
      return {
        // 商品数据
        goodsList:[],
        loadText:"",
        loadSwitch:false,
        // 分页信息
        total:"",//总页数
        page:0,//起始页
        per_page:6,//每页显示
      }
    },
    onReachBottom() {
      // 如果当前页数大于等于总页数，状态修改为没有更多了，不再继续往下执行代码
            uni.showLoading({
              title:'加载中..'
            })
          if(this.loadSwitch){
            this.loadSwitch = false;
            this.page = this.page+this.per_page;//页面新增一页
          setTimeout(() => {
            this.getGoodsList(this.tabs2[0]['id']);
          }, 1200); 
          }else{
            uni.hideLoading()
          }
        },
    onLoad() {
      this.get_book_class();
      setTimeout(() => {
        this.getGoodsList(this.tabs2[0]['id']);     
        console.log(this.tabs2[0]['id'])
      }, 1100);
    },
    methods: {
      getGoodsList(ee){
        console.log("默认得到的分类id"+ee)
              this.loadText = "加载中";
              uni.request({
                url: 'https://xxxxx/index.php/index/Api/query_book_by_classid', //仅为示例，并非真实接口地址。
                data: {
                    token:uni.getStorageSync('token'),
                  class_id:ee,
                  page:this.page,
                  per_page:this.per_page
                },
                method: 'POST',
                header: {
                    'content-type': 'application/x-www-form-urlencoded' //自定义请求头信息
                },
                success: (res) => {
                  this.goodsList = this.goodsList.concat(res.data.data);
                  var total=res.data.total;
                  if(this.page >= total) {
                    this.loadSwitch = false;
                    this.loadText = "没有啦~";
                    uni.hideLoading()
                  }else{
                  setTimeout(()=>{
                    this.loadText = "上拉加载更多";
                    this.loadSwitch = true;
                    uni.hideLoading()
                  },200);
                  }
                    }
              })
            },
      get_book_class(){
        let url = 'https://xxxxx/index.php/index/Api/query_class';
          uni.request({
            url,
            data: {
               token:uni.getStorageSync('token')
            },
            method:'GET',
            success: (res) => {
              console.log(res.data)
              if (res.data.code==200) {
                console.log(res.data.data.length)
                for(let i = 0;i<res.data.data.length;i++){
                  this.tabs2.push(res.data.data[i]);
                }
              } else{
                uni.showToast({
                  title:res.data.msg,
                  icon:'none'
                })
              }
              }
          })
      },
      onTabs2Change(index){
        // 设置激活
        console.log(index)
        this.tabs2Current = index;
        // 设置滚动位置
        let into = 0;
        if(this.tabs2.length - 2 < index){
          into = this.tabs2.length - 1;
        }else if(index > 1){
          into = index - 2;
        }
        this.tabs2IntoView = `tabs-${into}`
      }
    }
  }
</script>