Using jQuery+Ajax in PHP to implement paging query function

The following editor will bring you an article using jQuery+Ajax to implement multi-function paging query in PHP (example explanation). The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.

1. First make the main page Ajax_pag.php

The code is as follows:

  
    
    
    
    
    
    
  

  
  
    

      关键字：
      
      
      
    
    

      

        

          
地区代号
          
地区名称
          
父级代号
        
      
      


      
    

    

      


      
    


     

2. Then do 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: Total page processing page zyschuli.php

##
StrQuery($sql,0);
The effect is as shown

Keyword query: 

The above is the detailed content of Using jQuery+Ajax in PHP to implement paging query function. For more information, please follow other related articles on the PHP Chinese website!