Using jQuery+Ajax in PHP to implement paging query function-PHP Tutorial-php.cn

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:

Ajax做分页

关键字：

Copy after login

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
        
         Copy after login

3. Finally, do the paging query processing page pagechuli.php

The code is as follows:

JsonQuery($sql,0)

Copy after login

Small plug-in: Total page processing page zyschuli.php

StrQuery($sql,0);

Copy after login

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!