PHP native pull-up loading and click-to-load more implementation methods (code examples)-PHP Tutorial-php.cn

PHP native pull-up loading and click-to-load more implementation methods (code examples)

不言

Release： 2023-04-05 09:54:02

forward

4344 people have browsed it

The content this article brings to you is about the implementation methods (code examples) of PHP native pull-up loading and click loading. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you. helped.

Design purpose

When a website has a lot of data, it needs to be divided into pages for easy browsing. In order to facilitate page turning, we abandon the traditional click to turn pages and directly Scroll down to load the data automatically, making it easier to read.

Design principle

Initiate a page turning request through ajax to the back-end interface, send the page number, the back-end receives the page number, returns json data, and the front-end jquery parses the json and splices it into the original Based on some data!

Code

index.html

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0,viewport-fit=cover">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="format-detection" content="telephone=no">
    <title>jquery+ajax上拉加载更多</title>
    <style>
        *{margin:0;padding: 0;}
        #text p{
            width: 80%;
            padding: 5px 5px;
            background: #eee;
            margin:5px auto;
        }
        #loadmore{
            width: 120px;
            background: #eee;
            height: 45px;
            border-radius: 100px;
            margin:20px auto;
            line-height: 45px;
            text-align: center;
            cursor: pointer;
        }

        #loading{
            text-align: center;
        }
    </style>
</head>
<body>
    <h3 id="loading"></h3>
    <div id="text"></div>
    <div id="loadmore">点击加载更多</div>
</body>
</html>

<!--引入jquery库-->
<script type="text/javascript" src="http://www.yilingsj.com/skin/yilingsj/js/jquery-1.8.3.min.js"></script>
<script>
// 定义一个变量，等会用来控制多次触发
var i=0;
$(window).scroll(function(){
  //获取滚动时距离浏览器顶部的值
　var t=$(this).scrollTop();
  //获取当前窗口的高度
　var h=$(this).height();
  //获取按钮距离浏览器顶部的值
　var h1=$('#loadmore').offset().top;
  //用按钮的值-滚动条的值与窗口高度进行比较，如果小时，则表示按钮进入可视区，同时也表示滚动条即将到达底部
　if(h1-t<h){
    //防止快速下拉时多次触发
　　if(i==0){
      //改变i的值
　　　i=1;
　　　//触发点击事件
　　　$(&#39;#loadmore&#39;).click();
　　}
　}
});

// 加载初始数据
var p = 1;
$.ajax({
　　type:"get",
　　url:&#39;server.php?page=&#39; + p,
　　data:{},
　　dataType:"json",
　　success:function(data){
      for (var a in data){
          $(&#39;#text&#39;).append("<p>"+data[a].resname+"</p>");
          $("#loading").remove();
      }

　　　i=0;
      
　　},
    error:function(data){

　　},
    beforeSend:function(data){
        $('#loading').append("加载中");
    }
　});

// 加载更多
$('#loadmore').click(function(){
  p++;
　$.ajax({
　　type:"get",
　　url:'server.php?page=' + p,
　　data:{},
　　dataType:"json",
　　success:function(data){
      for (var a in data){
          $('#text').append("<p>"+data[a].resname+"</p>");
          $("#loading").remove();
      }
　　　i=0;
　　},
    error:function(data){
　　　$('#text').append("<p>"+服务器错误+"</p>");
　　},
    beforeSend:function(data){
        $('#loading').append("加载中");
    }
　});
});
</script>

Copy after login

server.php

<?php
header("Content-type:application/json");
header(&#39;Access-Control-Allow-Origin:*&#39;);
// 连接数据库
$con = mysql_connect("数据库地址","数据库账号","数据库密码");
if (!$con){die(&#39;Could not connect: &#39; . mysql_error());}

mysql_select_db("数据库名", $con);
mysql_query("SET NAMES UTF8");

// 每页显示条数
$pageLine = 5;

// 计算总记录数
$ZongPage = mysql_query("select count(*) from 表名");

// 计算总页数
$sum = mysql_fetch_row($ZongPage);
$pageCount = ceil($sum[0]/$pageLine);   
 
// 定义页码变量
@$tmp = $_GET[&#39;page&#39;];

 
// 计算分页起始值
$num = ($tmp - 1) * $pageLine;
 
// 查询语句
$result = mysql_query("SELECT 字段 FROM  表名 ORDER BY id DESC LIMIT " . $num . ",$pageLine");

//遍历输出
$results = array();
while ($row = mysql_fetch_assoc($result)) {
$results[] = $row;
}
echo json_encode($results);

//分页按钮
//上一页
$lastpage = $tmp-1;
//下一页
$nextpage = $tmp+1;

//防止翻过界
if (@$tmp > $pageCount) {
    echo "[{\"result\":\"没有了\"}]";
}

// 关闭数据库连接
mysql_close($con);
?>

Copy after login

The above is the detailed content of PHP native pull-up loading and click-to-load more implementation methods (code examples). For more information, please follow other related articles on the PHP Chinese website!