微信小程式中PHP開發的列表捲動到底部實作方法

<?php
$currentPage = $_POST['currentPage'];
$pageSize = $_POST['pageSize'];
$offset = ($currentPage - 1) * $pageSize;

$sql = "SELECT * FROM table LIMIT $offset,$pageSize";
$result= mysqli_query($conn, $sql);

$response = array();
$data = array();
while($row = mysqli_fetch_assoc($result)){
      array_push($data, $row);
}
mysqli_free_result($result);
mysqli_close($conn);
$response['success'] = true;
$response['data'] = $data;
echo json_encode($response);
?>

wx.request({
  url: 'https://example.com/getList',
  data: {
    currentPage: currentPage,
    pageSize: pageSize
  },
  method: 'POST',
  header: {
    'content-type': 'application/x-www-form-urlencoded'
  },
  success: function (res) {
    // 处理返回数据
    if (res.data.success) {
      var l = res.data.data.length;
      var newData = l ? (that.data.list.concat(res.data.data)) : [];

      // 更新数据
      that.setData({
        list: newData      })
    } 
  }
})

// 监听页面滑动事件
onPageScroll: function(e) {
  // 滚动到底部，触发onReachBottom事件
  if(e.scrollHeight - e.scrollTop === e.clientHeight) {
    if(!this.data.loading) {
      this.setData({
        loading: true
      })
      // 加载下一页数据
      this.getList();
    }
  }
},

// onReachBottom事件：加载下一页数据
onReachBottom: function () {
  if (!this.data.loading) {
    this.setData({
      loading: true
    })
    // 加载下一页数据
    this.getList();
  }
},

// 获取列表数据
getList: function () {
  var that = this;
  var currentPage = that.data.currentPage + 1;
  var pageSize = that.data.pageSize;
  wx.request({
    url: 'https://example.com/getList',
    data: {
      currentPage: currentPage,
      pageSize: pageSize
    },
    method: 'POST',
    header: {
      'content-type': 'application/x-www-form-urlencoded'
    },
    success: function (res) {
      // 处理返回数据
      if(res.data.success) {
        var l = res.data.data.length;
        var newData = l ? (that.data.list.concat(res.data.data)) : [];
        // 更新数据
        that.setData({
          list: newData,
          currentPage: currentPage
        })
      }
      that.setData({
        loading: false
      })
    }
  })
}