How to use jQuery+Ajax to implement multi-functional paging query operations in PHP

1. First make the main page Ajax_pag.php

The code is as follows:

         
   
 关键字：   
 
 
 
 
地区代号
 
地区名称
 
父级代号
 
 
 
 
 
 
 
 
 
  

2. Then make the paging query JS page Ajax_pag.js

The code is as follows:

//ajax分页开始 var ts = 10; //每页显示的条数 var page = 1; //当前页 $(document).ready(function(e) { //页面加载数据 Load(); //加载分页列表 Loadlist(); $("#ck").click(function() { //页面加载数据 Load(); //加载分页列表 Loadlist(); } ) } ) //加载数据的方法 function Load() { var gjz = $("#key").val(); $.ajax( { async:false, url:"pagechuli.php", data: { page:page,ts:ts,gjz:gjz } ,//page是显示的页数；ts是显示的条数 type:"POST", dataType:"JSON", success: function(data) { var str =""; for(var k in data) { str +=""+data[k][0]+""+data[k][1]+""+data[k][2]+""; } $("#list").html(str); //把拼接好的字符串放到要显示的thody里面 } }) } //加载分页列表 function Loadlist() { var str =""; //上一页 str+="
« 
"; //加载列表 for(var i=page-4; i0 && i<=zys()) { //判断当前页 if(i==page) { str+= "
"+i+"
"; } else { str+= "
"+i+"
"; } } } //下一页 str+="
» 
"; $("#fenye").html(str); $("#prev").click(function() { if(page>1) { page--; } //页面加载数据 Load(); //加载分页列表 Loadlist(); } ) $(".item").click(function() { var p = $(this).text(); //取到的是字符串,转化为整数 page = parseInt(p); //页面加载数据 Load(); //加载分页列表 Loadlist(); } ) $("#next").click(function() { if(page
      
3. Finally, do the paging query processing page pagechuli.php
      
The code is as follows:
      
JsonQuery($sql,0)
      
Small plug-in: Processing page zyschuli for the total number of pages .php
      

##
      
StrQuery($sql,0);
      
The effect is as shown in the figure:
      

      
Keyword query:
      

      
The above is the detailed content of How to use jQuery+Ajax to implement multi-functional paging query operations in PHP. For more information, please follow other related articles on the PHP Chinese website!