Maison > Article > développement back-end > 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> <ul> <?php <span>for(<span>$i</span>=0;<span>$i</span>$_pageabsolute;<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>%24i</span>+1).'">'.(<span>$i</span>+1).'</a></li>'<span>; }</span><span>else</span><span>{ </span><span>echo</span> '<li><a href="blog.php?page='.(<span>%24i</span>+1).'">'.(<span>$i</span>+1).'</a></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; }
在其中可能会由于编码出现容错误,解决的方法是
<span><span>//</span><span> 分页模块</span><span>if</span> (<span>isset</span> ( <span>$_GET</span> ['page'<span>] )) { </span><span>//</span><span> 在数据不再数据范围内出错的解决方法</span><span>$_page</span> = <span>$_GET</span>['page'<span>]; </span><span>//</span><span> 是否为空,是否小于0,是否不是数字。//如果其中有一个是,那么就=1</span><span>if</span> (<span>empty</span> ( <span>$_page</span> )||<span>$_page</span> is_numeric</span>( <span>$_page</span><span> )) { </span><span>$_page</span> = 1<span>; } </span><span>else</span><span> { </span><span>$_page</span> = <span>intval</span> ( <span>$_page</span> ); <span>//</span><span> 如果是数字,但是小数,那么就$_page = intval($_page);转换成整数</span><span> } } </span><span>else</span><span> { </span><span>$_page</span> = 1<span>; } </span><span>$_pagesize</span> = 10<span>; </span><span>$_num</span> = _num_rows( _query ( "SELECT tg_id FROM tg_user"<span> ) ); </span><span>if</span> (<span>$_num</span>==0<span>) { </span><span>$_pageabsolute</span>=1<span>; }</span><span>else</span><span>{ </span><span>$_pageabsolute</span>=<span>ceil</span>(<span>$_num</span>/<span>$_pagesize</span><span>); } </span><span>//</span><span>当页码大于总页码的时候,就会返回到总页码的最后一页</span><span>if</span> (<span>$_page</span>><span>$_pageabsolute</span><span>) { </span><span>$_page</span>=<span>$_pageabsolute</span><span>; } </span><span>$_pagenum</span> = (<span>$_page</span> - 1) * <span>$_pagesize</span>;
以上就介绍了PHP自练项目之数字分页效果,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。