本文章总结了目前常用的几种分页代码,比如说上一页,下一页之类的,还有一种数字分页,像1,2,3...之类的等
分页代码
代码如下 | 复制代码 |
//page当前页,num每页的页数 $page=isset($_GET['page'])?intval($_GET['page']):1; $num=5; $conn = mysql_connect('127.0.0.1','root',''); if (!$conn) { die('Could not connect:'.mysql_error()); } mysql_select_db('shop'); //获取记录总数 $total=mysql_num_rows(mysql_query("select * from user")); //计算页数 $pagenum=ceil($total/$num); //限制页数不能超出范围 If($page>$pagenum || $page == 0){ Echo 'Error : Can Not Found The page.'; Exit; } //语句“Select * from table limit 0,10”从table表提取十条信息,0为起点,10为提取的数目 //$offset为起点值,如当前页为第一页,每页5条,起点即为0,同理当前为第二页,起点将为5 $offset=($page-1)*$num; $result=mysql_query("select * from user limit $offset,$num"); while($it=mysql_fetch_array($result)){ echo 'id:'.$it['id'].' name:'.$it['name'].' '; } //显示链接页面切换链接,当前页无链接 for($i=1;$i $show=($i!=$page)?"$i":"$i"; echo $show." "; } echo $total.'条记录,每页5条,共'.$pagenum.'页'; mysql_free_result($result); mysql_close($conn); ?> |
实例2
代码如下 | 复制代码 |
//function.php 这里是主函数 if($page!=1) |
//conn.php 连接数据库
代码如下 | 复制代码 |
$id=mysql_connect("localhost","root","root")or dir('连接失败:' . mysql_error()); if(mysql_select_db("db_database06",$id)) |
//主程序,将上面俩个文件包含进来,再调用一个php_page()就可完成分页。:)
代码如下 | 复制代码 |
require_once("conn.php"); |
上在的一种是文字分页,比如说上一页,下一页之类的,还有一种数字分页,像1,2,3...之类的,这个比较简单,前者稍微复杂些.最后一种是他们2者结合
代码如下 | 复制代码 |
--> 1 //获取当前页数 |

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

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download
The most popular open source editor

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Zend Studio 13.0.1
Powerful PHP integrated development environment

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
