Maison >développement back-end >tutoriel php >PHP自练项目之数字分页效果,php练项目分页_PHP教程
学习要点:
1.LIMIT 用法
2.各种参数
3.超链接调用
第一:先在文件中设置数字分页模块;我的文件是(blog.php)
<span>//</span><span>分页模块</span> <span>$_page</span> = <span>$_GET</span>['page'<span>]; </span><span>$_pagesize</span> = 10<span>; </span><span>$_pagenum</span> = (<span>$_page</span> - 1) * <span>$_pagesize</span><span>; </span><span>//</span><span>首页要得到所有的数据总和</span> <span>$_num</span>=<span>mysql_num_rows</span>(_query("SELECT tg_id FROM tg_user"<span>)); </span><span>$_pageabsolute</span>=<span>$_num</span> / <span>$_pagesize</span>;
要注意的是在数据库中取集的时候
//我们必须每次重新读取结果集,而不是从新去执行SQL语句。
$_result = _query("SELECT tg_username,tg_sex,tg_face FROM tg_user ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize");
设置分页循环的效果
<span><div id="page_num"> <ul> <?php <span>for</span>(<span>$i</span>=0;<span>$i</span><<span>$_pageabsolute</span>;<span>$i</span>++<span>){ </span><span>if</span> (<span>$_page</span> == (<span>$i</span>+1<span>)) { </span><span>echo</span> '<li><a href="blog.php?page='.(<span>$i</span>+1).'" class="selected">'.(<span>$i</span>+1).'</a></li>'<span>; }</span><span>else</span><span>{ </span><span>echo</span> '<li><a href="blog.php?page='.(<span>$i</span>+1).'">'.(<span>$i</span>+1).'</li>'<span>; } } </span>?> </ul> </div></span>
相对应的CSS
#page_num { height:20px; clear:both; padding:10px 0; position:relative; } #page_num ul { position:absolute; right:30px; height:20px; } #page_num ul li { float:left; width:26px; height:20px; } #page_num ul li a { display:block; width:20px; height:20px; line-height:20px; border:1px solid #333; text-align:center; text-decoration:none; } #page_num ul li a:hover,#page_num ul li a.selected { background:#666; font-weight:bold; color:#fff; }