This article mainly shares with you how to implement simple paging with PHP and jQuery. I hope it can help you.
HTML page:
<!DOCTYPE html>
<html>
<head>
<title>jquery ajax分页</title>
</head>
<body>
<p>
<p>下面是获取的内容</p>
<ul id="data">
<!-- 这里是显示的内容 -->
</ul>
</p>
<p id="page">
<a href="javascript:void(0)" name="first">首页</a>
<a href="javascript:void(0)" name="up">上一页</a>
<a href="javascript:void(0)" name="next">下一页</a>
<a href="javascript:void(0)" name="last">尾页</a>
</p>
<p>
<input type="text" id="p" value="1"><!-- 当前页 -->
<input type="text" id="pageLast" value=""><!-- 总页数 -->
</p>
</body>
</html>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.12.4.js"></script>
<!-- 偷懒+方便用了线上的jquery文件 -->
<script type="text/javascript">
$(function(){//页面加载显示当前页的内容
var p = $("#p").val();//获取当前页
ajax(p); //调用ajax方法
})
$('#page>a').click(function(){//页码的点击事件
var name = $(this);
//获取pagenow当前页和总页数pagelast，记得使用parseInt，转换整型
var pn = parseInt($("#p").val());
var pl = parseInt($("#pageLast").val());
switch(name.attr('name')){ //根据a标签内的name属性判断跳转方向
case "first": p = 1;break;
case "up": p = pn-1;break;
case "next": p = pn+1;break;
case "last": p = pl;break;
}
if (p<1 || p>pl) {
return;
}else{
ajax(p);
}
})
function ajax(p){//ajax方法，与后台交互
$.ajax({
type:"post",
datatype:"json",
url:"tb.php",
data:{p:p},
success:function(msg){
$('#data').empty();
aa = $.parseJSON(msg); //转换json格式（在返回值有小的问题的时候可以使用）
pageNow = parseInt(aa[0].page);
pn = $("#p").val(pageNow);//赋值当前页
pageLast = parseInt(aa[0].lastpage);
pl = $("#pageLast").val(pageLast);//赋值总页数
$.each(aa,function(k,v){//标签内追加内容
$('#data').append('<li>id为：'+v.tb_id+';名称为：'+v.name+'</li>')
})
}
})
}
</script>Backend PHP code:
<?php
$pdo = new PDO("mysql:host=127.0.0.1;dbname=school",'root','root');
$sql = "select * from tb";
$count = $pdo->query($sql)->rowCount();//当前数据总条数
$p = isset($_POST['p'])?$_POST['p']:1;//页码
$dataPerpage = 5;//每页显示条数
$offset = ($p-1)*$dataPerpage;//偏移量
$last = ceil($count/$dataPerpage);//总页数
$sql2 = "select * from tb limit $offset,$dataPerpage";
$data = $pdo->query($sql2)->fetchAll(PDO::FETCH_ASSOC);
//把当前页和总页数发送给前台
$data[0]['page'] = $p;
$data[0]['lastpage'] = $last;
echo json_encode($data); Related recommendations:
php simple paging program 1/ 5 pages_PHP tutorial
php quite simple paging class_PHP tutorial
The above is the detailed content of PHP and jQuery implement simple paging. For more information, please follow other related articles on the PHP Chinese website!
What is the best way to send an email using PHP?May 08, 2025 am 12:21 AMThebestapproachforsendingemailsinPHPisusingthePHPMailerlibraryduetoitsreliability,featurerichness,andeaseofuse.PHPMailersupportsSMTP,providesdetailederrorhandling,allowssendingHTMLandplaintextemails,supportsattachments,andenhancessecurity.Foroptimalu
Best Practices for Dependency Injection in PHPMay 08, 2025 am 12:21 AMThe reason for using Dependency Injection (DI) is that it promotes loose coupling, testability, and maintainability of the code. 1) Use constructor to inject dependencies, 2) Avoid using service locators, 3) Use dependency injection containers to manage dependencies, 4) Improve testability through injecting dependencies, 5) Avoid over-injection dependencies, 6) Consider the impact of DI on performance.
PHP performance tuning tips and tricksMay 08, 2025 am 12:20 AMPHPperformancetuningiscrucialbecauseitenhancesspeedandefficiency,whicharevitalforwebapplications.1)CachingwithAPCureducesdatabaseloadandimprovesresponsetimes.2)Optimizingdatabasequeriesbyselectingnecessarycolumnsandusingindexingspeedsupdataretrieval.
PHP Email Security: Best Practices for Sending EmailsMay 08, 2025 am 12:16 AMThebestpracticesforsendingemailssecurelyinPHPinclude:1)UsingsecureconfigurationswithSMTPandSTARTTLSencryption,2)Validatingandsanitizinginputstopreventinjectionattacks,3)EncryptingsensitivedatawithinemailsusingOpenSSL,4)Properlyhandlingemailheaderstoa
How do you optimize PHP applications for performance?May 08, 2025 am 12:08 AMTooptimizePHPapplicationsforperformance,usecaching,databaseoptimization,opcodecaching,andserverconfiguration.1)ImplementcachingwithAPCutoreducedatafetchtimes.2)Optimizedatabasesbyindexing,balancingreadandwriteoperations.3)EnableOPcachetoavoidrecompil
What is dependency injection in PHP?May 07, 2025 pm 03:09 PMDependencyinjectioninPHPisadesignpatternthatenhancesflexibility,testability,andmaintainabilitybyprovidingexternaldependenciestoclasses.Itallowsforloosecoupling,easiertestingthroughmocking,andmodulardesign,butrequirescarefulstructuringtoavoidover-inje
Best PHP Performance Optimization TechniquesMay 07, 2025 pm 03:05 PMPHP performance optimization can be achieved through the following steps: 1) use require_once or include_once on the top of the script to reduce the number of file loads; 2) use preprocessing statements and batch processing to reduce the number of database queries; 3) configure OPcache for opcode cache; 4) enable and configure PHP-FPM optimization process management; 5) use CDN to distribute static resources; 6) use Xdebug or Blackfire for code performance analysis; 7) select efficient data structures such as arrays; 8) write modular code for optimization execution.
PHP Performance Optimization: Using Opcode CachingMay 07, 2025 pm 02:49 PMOpcodecachingsignificantlyimprovesPHPperformancebycachingcompiledcode,reducingserverloadandresponsetimes.1)ItstorescompiledPHPcodeinmemory,bypassingparsingandcompiling.2)UseOPcachebysettingparametersinphp.ini,likememoryconsumptionandscriptlimits.3)Ad
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Dreamweaver Mac version
Visual web development tools
WebStorm Mac version
Useful JavaScript development tools
Dreamweaver CS6
Visual web development tools
SublimeText3 English version
Recommended: Win version, supports code prompts!
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
