简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

PHP paging principle analysis and PHP paging code design

WBOY
Release： 2016-07-25 08:52:49
Original
1307 people have browsed it

  3. //php分页代码

  4. // bbs.it-home.org
  5. include("conn.php");
  6. $pagesize=5;//每页显示记录
  7. $startrow=0;//当前页记录头
  8. if(empty($_GET['pageno'])){
  9. if($startrow==0){
  10. $pageno=$startrow+1;
  11. }
  12. }else{
  13. $pageno=$_GET['pageno'];
  14. $startrow=($pageno-1)*$pagesize;
  15. }
  16. $sql="select * from test";
  17. $result1=mysql_query($sql,$conn);
  18. $resultcount=mysql_num_rows($result1);
  19. if($resultcount%$pagesize==0){
  20. $maxpage=$resultcount/$pagesize;
  21. }else{
  22. $maxpage=ceil($resultcount/$pagesize);
  23. }

  24. $result=mysql_query("select * from test LIMIT $startrow,$pagesize");

  25. while($row=mysql_fetch_array($result)){
  26. echo $row["name"].'
    ';
  27. }
  28. ?>
  29. 共页
  30. 首页
  31. 上一页
  32. 下一页
  33. 末页

复制代码


Related labels：
php分页原理分析与php分页代码设计
source：php.cn
Previous article：A PHP paging code (with renderings) Next article：PHP simple paging principle and paging code examples
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Parsing and dealing with the eval function in PHP Disclaimer: This is just an example for learning PHP code injection, not production code t...
From 2023-08-13 17:40:10
0
2
220
Running PHP project shows blank My main problem is that the php projects that used to be run using xampp cannot run now. T...
From 2021-01-20 12:50:46
0
1
903
这段 python 想改写成 PHP，怎么破？求解 python 代码 {代码...} php 自己尝试写的，但是失败了，麻烦帮忙分析下具体原因。 {代码...} intval转换的最大值是9223372036854775807，$...
From 2017-05-16 13:01:43
0
1
308
javascript - 有没有什么办法过滤掉数据库中的乱码？ 发现数据库中有一部分信息变成了中文乱码下面这种情况 娌挎捣鍥介檯涓績 网页设计 php或js有么有办法获取到这个字段的内容并检测出它包含乱码呢？ 现在想知道有没有办法可以匹配到这...
From 2017-04-17 16:48:30
0
2
273
php - 为什么发送ajax请求页面也会刷新呢？ {代码...} 点击按钮触发函数 set_chat_msg()部分： {代码...} 然后就是php接收到进行处理。 为什么我点击按钮后页面会被刷新一次呢？然后如果是在firefo...
From 2017-04-11 10:34:31
0
5
318
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！