Table of Contents
关于php,mysql,html的数字分页和文本分页的两种分页样式供大家参考
page
请勿盗版,转载请加上出处http://blog.csdn.net/yanlintao1
请勿盗版,转载请加上出处http://blog.csdn.net/yanlintao1
首先进行样式展示希望对大家有所帮助,也希望大家给出意见和建议:
第一种:数字分页
第二种:为文本分页
php分页函数(我写在下面引入的common.inc.php公共文件中):
/* *_page()分页的相关参数 *@param int $_pagesize 每页存有几个好友 *@param $_sql 获取所有字段 * */ function _page($_sql,$_size){ global $_pagenum,$_pagesize,$_pageabsolute,$_num,$_page; //分页模块以及容错处理 //第几页 if(isset( $_GET['page'])){ $_page = $_GET['page']; if(empty($_page)$_page<0!is_numeric($_page)){ $_page = 1; }else{ $_page = intval($_page); } }else{ $_page = 1; } //每页有几个好友 $_pagesize = $_size; //得到所有数据综合 $_num = _num_rows(_query($_sql)); //ceil见大于等于1就进位,计算有多少页 if($_num == 0){ $_pageabsolute = 1; }else{ $_pageabsolute = ceil($_num/$_pagesize); } if($_page>$_pageabsolute){ $_page=$_pageabsolute; } //从数据库的第几条数据开始 $_pagenum = ($_page-1)*$_pagesize; } /* * _paging分页函数 * @access public 表示函数对外公开 * @param int $_type 若为1则按数字分页,若为2按文本形式分页 * $_pageabsolute 共多少页 * $_page 第几页 * $_num 一共有多少条数据 * */ function _paging($_type){ global $_pageabsolute,$_page,$_num; if($_type==1){ echo '<p id="page_num">'; echo '<ul>'; for($i=0;$i<$_pageabsolute;$i++){ if($_page==($i+1)){ echo '<li>'.($i+1).'</li>'; }else{ echo '<li>'.($i+1).'</li>'; } } echo '</ul>'; echo '</p>'; }elseif($_type==2){ echo '<p id="page_text">'; echo '<ul>'; echo '<li>'.$_page.'/'.$_pageabsolute.'页 </li>'; echo '<li>共有<strong>'.$_num.'</strong>条数据 </li>'; if($_page==1){ echo '<li>首页 </li>'; echo '<li>下一页 </li>'; echo '<li>尾页 </li>'; }elseif($_page==$_pageabsolute){ echo '<li>首页 </li>'; echo '<li>上一页 </li>'; echo '<li>尾页 </li>'; }else{ echo '<li>首页 </li>'; echo '<li>上一页 </li>'; echo '<li>下一页 </li>'; echo '<li>尾页 </li>'; } echo '</ul>'; echo '</p>'; } }
Copy after login
html代码:
*/ //引入公共文件 require './includer/common.inc.php'; //分页模块,第一个参数获取总条数,第二个参数获得每页有几个好友 global $_pagenum,$_pagesize; _page("SELECT tg_id FROM tg_guest", 2); //从数据库中取数据,按照注册时间顺序排列 $_result = _query("SELECT tg_username,tg_sex,tg_face,tg_id FROM tg_guest ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>博友</title> <?php require ROOT_PATH.'includer/title.inc.php'; ?> <script type="text/javascript" src="js/blog_message.js"></script> </head> <body> <?php require ROOT_PATH.'includer/header.inc.php'; ?> <p id="blog"> <h2 id="博友界面">博友界面</h2> <?php while(!!$_rows=_fetch_array_list($_result,MYSQL_ASSOC)){ $_html = array(); $_html['tg_username'] = $_rows['tg_username']; $_html['tg_face'] = $_rows['tg_face']; $_html['tg_sex'] = $_rows['tg_sex']; $_html['tg_id'] = $_rows['tg_id']; $_html = _html($_html); ?> <dl> <dt class="user"><?php echo $_html['tg_username']?>(<?php echo $_html['tg_sex']?>)</dt> <dt>" alt="<?php echo $_html['tg_username']?>"></img></dt> <dd class="message">">发消息</dd> <dd class="friend">加好友</dd> <dd class="guest">写留言</dd> <dd class="flower">送鲜花</dd> </dl> <?php }?> <?php //销毁结果集 _free_result($_result); //1为数字分页,2为文本分页 _paging(2); ?> </p> <?php require ROOT_PATH.'includer/footer.inc.php'; ?> </body>
Copy after login
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

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
Assassin's Creed Shadows: Seashell Riddle Solution
3 weeks ago
By DDD
What's New in Windows 11 KB5054979 & How to Fix Update Issues
2 weeks ago
By DDD
Where to find the Crane Control Keycard in Atomfall
3 weeks ago
By DDD
Roblox: Dead Rails - How To Complete Every Challenge
4 weeks ago
By DDD
Atomfall guide: item locations, quest guides, and tips
4 weeks ago
By DDD

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics
CakePHP Tutorial
1393
52


nyt mini crossword answers
37
110

