search
HomeWeb Front-endJS TutorialHow to implement paging function with jquery+ajax

This time I will show you how to implement the paging function in jquery ajax. What are the precautions for jquery ajax to implement the paging function. The following is a practical case, let’s take a look.

HTML

<p> 
 </p>
       

    CSS

     #list{width:680px; height:530px; margin:2px auto; position:relative} 
    #list ul li{float:left;width:220px; height:260px; margin:2px} 
    #list ul li img{width:220px; height:220px} 
    #list ul li p{line-height:22px} 
    #pagecount{width:500px; margin:10px auto; text-align:center} 
    #pagecount span{margin:4px; font-size:14px} 
    #list ul li#loading{width:120px; height:32px; border:1px solid #d3d3d3; 
    position:absolute; top:35%; left:42%; text-align:center; background:#f7f7f7 
    url(loading.gif) no-repeat 8px 8px;-moz-box-shadow:1px 1px 2px rgba(0,0,0,.2); 
    -webkit-box-shadow:1px 1px 2px rgba(0,0,0,.2); box-shadow:1px 1px 2px rgba(0,0,0,.2);}

    jQuery

    We declare the variables first, and the following variables will be used in the subsequent code.

    var curPage = 1; //当前页码 
    var total,pageSize,totalPage; //总记录数,每页显示数,总页数

    Next, we define a function : getData() to obtain the current page data. In the function, we use $.ajax() to send a POST asynchronous request to the background pages.php, and pass the current page number to the background in JSON format.

    //获取数据 
    function getData(page){ 
     $.ajax({ 
     type: 'POST', 
     url: 'pages.php', 
     data: {'pageNum':page-1}, 
     dataType:'json', 
     beforeSend:function(){ 
     $("#list ul").append("
  • loading...
  • ");//显示加载动画   },   success:function(json){   $("#list ul").empty();//清空数据区   total = json.total; //总记录数   pageSize = json.pageSize; //每页显示条数   curPage = page; //当前页   totalPage = json.totalPage; //总页数   var li = "";   var list = json.list;   $.each(list,function(index,array){ //遍历json数据列   li += "
  • How to implement paging function with jquery+ajax"+array['title']   +"
  • ";   });   $("#list ul").append(li);   },   complete:function(){ //生成分页条   getPageBar();                        当点击分页条中的分页链接时,调用getData(page)加载对应页码的数据。               $("#pagecount span a").on('click',function(){          var rel = $(this).attr("rel");         if(rel){        getData(rel);         }            });     },   error:function(){   alert("数据加载失败");   }   });  }

    After the request is successful, the data will be returned, the corresponding data will be attached to the variable, and the returned product data list will be displayed in a loop to the corresponding container #list ul. When the data is completely loaded, call the paging bar function getPageBar() to generate a paging bar.

    //获取分页条 
    function getPageBar(){ 
     //页码大于最大页数 
     if(curPage>totalPage) curPage=totalPage; 
     //页码小于1 
     if(curPage共"+total+"条<span>"+curPage 
     +"/"+totalPage+"</span>"; 
     
     //如果是第一页 
     if(curPage==1){ 
     pageStr += "<span>首页</span><span>上一页</span>"; 
     }else{ 
     pageStr += "<span><a>首页</a></span> 
     <span><a>上一页</a></span>"; 
     } 
     
     //如果是最后页 
     if(curPage>=totalPage){ 
     pageStr += "<span>下一页</span><span>尾页</span>"; 
     }else{ 
     pageStr += "<span><a> 
     下一页</a></span><span><a>尾页</a> 
     </span>"; 
     } 
     
     $("#pagecount").html(pageStr); 
    }

    Finally, when the page is loaded for the first time, we load the first page of data, which is getData(1),

    $(function(){ 
     getData(1); 
     
    });

    PHP

    pages .php receives each ajax request for the front-end page, obtains data from mysql database based on the submitted page number pageNum value, calculates the total number of records and total number of pages, reads the data list under the corresponding page number, and Return the final result to the front-end page in JSON format.

    include_once('connect.php'); //连接数据库,略过,具体请下载源码查看 
    $page = intval($_POST['pageNum']); //当前页 
     
    $result = mysql_query("select id from food"); 
    $total = mysql_num_rows($result);//总记录数 
    $pageSize = 6; //每页显示数 
    $totalPage = ceil($total/$pageSize); //总页数 
     
    $startPage = $page*$pageSize; //开始记录 
    //构造数组 
    $arr['total'] = $total; 
    $arr['pageSize'] = $pageSize; 
    $arr['totalPage'] = $totalPage; 
    $query = mysql_query("select id,title,pic from food order by id asc limit 
    $startPage,$pageSize"); //查询分页数据 
    while($row=mysql_fetch_array($query)){ 
     $arr['list'][] = array( 
     'id' => $row['id'], 
     'title' => $row['title'], 
     'pic' => $row['pic'], 
     ); 
    } 
    echo json_encode($arr); //输出JSON数据

    Finally, attach the Mysql table structure

    CREATE TABLE IF NOT EXISTS `food` ( 
     `id` int(11) NOT NULL AUTO_INCREMENT, 
     `title` varchar(100) NOT NULL, 
     `pic` varchar(255) NOT NULL, 
     PRIMARY KEY (`id`) 
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    Wonderful topic sharing:jquery paging function operation JavaScript paging function operation

    I believe I have read the case in this article You have mastered the method. For more exciting information, please pay attention to other related articles on the php Chinese website!

    Recommended reading:

    Detailed explanation of jQuery's operation of html element click events

    text() val() and html in jQuery What are the differences in the use of ()

    The above is the detailed content of How to implement paging function with jquery+ajax. For more information, please follow other related articles on the PHP Chinese website!

    Statement
    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
    JavaScript in Action: Real-World Examples and ProjectsJavaScript in Action: Real-World Examples and ProjectsApr 19, 2025 am 12:13 AM

    JavaScript's application in the real world includes front-end and back-end development. 1) Display front-end applications by building a TODO list application, involving DOM operations and event processing. 2) Build RESTfulAPI through Node.js and Express to demonstrate back-end applications.

    JavaScript and the Web: Core Functionality and Use CasesJavaScript and the Web: Core Functionality and Use CasesApr 18, 2025 am 12:19 AM

    The main uses of JavaScript in web development include client interaction, form verification and asynchronous communication. 1) Dynamic content update and user interaction through DOM operations; 2) Client verification is carried out before the user submits data to improve the user experience; 3) Refreshless communication with the server is achieved through AJAX technology.

    Understanding the JavaScript Engine: Implementation DetailsUnderstanding the JavaScript Engine: Implementation DetailsApr 17, 2025 am 12:05 AM

    Understanding how JavaScript engine works internally is important to developers because it helps write more efficient code and understand performance bottlenecks and optimization strategies. 1) The engine's workflow includes three stages: parsing, compiling and execution; 2) During the execution process, the engine will perform dynamic optimization, such as inline cache and hidden classes; 3) Best practices include avoiding global variables, optimizing loops, using const and lets, and avoiding excessive use of closures.

    Python vs. JavaScript: The Learning Curve and Ease of UsePython vs. JavaScript: The Learning Curve and Ease of UseApr 16, 2025 am 12:12 AM

    Python is more suitable for beginners, with a smooth learning curve and concise syntax; JavaScript is suitable for front-end development, with a steep learning curve and flexible syntax. 1. Python syntax is intuitive and suitable for data science and back-end development. 2. JavaScript is flexible and widely used in front-end and server-side programming.

    Python vs. JavaScript: Community, Libraries, and ResourcesPython vs. JavaScript: Community, Libraries, and ResourcesApr 15, 2025 am 12:16 AM

    Python and JavaScript have their own advantages and disadvantages in terms of community, libraries and resources. 1) The Python community is friendly and suitable for beginners, but the front-end development resources are not as rich as JavaScript. 2) Python is powerful in data science and machine learning libraries, while JavaScript is better in front-end development libraries and frameworks. 3) Both have rich learning resources, but Python is suitable for starting with official documents, while JavaScript is better with MDNWebDocs. The choice should be based on project needs and personal interests.

    From C/C   to JavaScript: How It All WorksFrom C/C to JavaScript: How It All WorksApr 14, 2025 am 12:05 AM

    The shift from C/C to JavaScript requires adapting to dynamic typing, garbage collection and asynchronous programming. 1) C/C is a statically typed language that requires manual memory management, while JavaScript is dynamically typed and garbage collection is automatically processed. 2) C/C needs to be compiled into machine code, while JavaScript is an interpreted language. 3) JavaScript introduces concepts such as closures, prototype chains and Promise, which enhances flexibility and asynchronous programming capabilities.

    JavaScript Engines: Comparing ImplementationsJavaScript Engines: Comparing ImplementationsApr 13, 2025 am 12:05 AM

    Different JavaScript engines have different effects when parsing and executing JavaScript code, because the implementation principles and optimization strategies of each engine differ. 1. Lexical analysis: convert source code into lexical unit. 2. Grammar analysis: Generate an abstract syntax tree. 3. Optimization and compilation: Generate machine code through the JIT compiler. 4. Execute: Run the machine code. V8 engine optimizes through instant compilation and hidden class, SpiderMonkey uses a type inference system, resulting in different performance performance on the same code.

    Beyond the Browser: JavaScript in the Real WorldBeyond the Browser: JavaScript in the Real WorldApr 12, 2025 am 12:06 AM

    JavaScript's applications in the real world include server-side programming, mobile application development and Internet of Things control: 1. Server-side programming is realized through Node.js, suitable for high concurrent request processing. 2. Mobile application development is carried out through ReactNative and supports cross-platform deployment. 3. Used for IoT device control through Johnny-Five library, suitable for hardware interaction.

    See all articles

    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 Tools

    Atom editor mac version download

    Atom editor mac version download

    The most popular open source editor

    SublimeText3 Linux new version

    SublimeText3 Linux new version

    SublimeText3 Linux latest version

    SublimeText3 Mac version

    SublimeText3 Mac version

    God-level code editing software (SublimeText3)

    SublimeText3 English version

    SublimeText3 English version

    Recommended: Win version, supports code prompts!

    SAP NetWeaver Server Adapter for Eclipse

    SAP NetWeaver Server Adapter for Eclipse

    Integrate Eclipse with SAP NetWeaver application server.