Home >Backend Development >PHP Tutorial > php简略翻页代码
php简单翻页代码
php简单翻页代码
<style type="text/css"> *{ margin:0; padding:0; } #lay{ margin:100px 100px 100px 100px; } a{ padding:5px; font-size:13px; text-decoration:none; } span{ font-size:13px; } table{ border:1px solid red; border-collapse:collapse; } </style> <div id="lay"> <table border="1" align="center" cellpadding="0" cellpadding="0"> <tr align="center" bgcolor="#ffcc"> <td width="200px;">id</td> <td width="200px;">值</td> </tr> <?php $link = mysql_connect("localhost","root","admin"); //连接数据库 mysql_select_db("pagelist");//选择哪个数据库 mysql_query("set names gbk"); //设置数据库字符编码为中文 $sql = mysql_query("select *from v_char"); $pagesize = 10; // $sum = mysql_num_rows($sql); //一共有多少条数据 $count = ceil($sum/$pagesize);//求出一共有多少页 $pages = $count; //显示最后一页 $init = 1; $page_len = 7; $max_p = $count; if(empty($_GET["page"]) || $_GET["page"]<0){ $page = 1; }else{ $page = $_GET["page"]; } $off = ($page-1)*$pagesize; //求出数据库查询的第一个数据 $he = mysql_query("select *from v_char limit $off,$pagesize");//按照off开始,到pagesize规律显示 while($row = mysql_fetch_array($he)){ ?> <tr align="center"> <td><?php echo $row["id"];?></td> <td><?php echo $row["name"];?></td> </tr> <?php } $page_len = ($page_len%2)?$page_len:$page_len+1;//如果余为1则为真,为0则为假 $pageoffset = ($page_len-1)/2;//页码偏移量 if($page!=1){ $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=1"."\">第一页 </a></span>"; $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页 </a></span>"; }else{ $key.="<span>第一页 </span>"; $key.="<span>上一页 </span>"; } if($pages>$page_len){ if($page<=$pageoffset){ $init=1; $max_p = $page_len; }else{ if($page+$pageoffset>=$pages+1){ $init = $pages - $page_len+1; }else{ $init = $page-$pageoffset; $max_p = $page + $pageoffset; } } } for($i=$init;$i<$max_p;$i++){ if($i==$page){ $key.="[ ".$i." ]"; }else{ $key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">$i</a>"; } } if($i!=$page){ $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a></span>"; $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=".$pages."\">最后一页</a></span>"; }else{ $key.="<span>下一页</span>"; $key.="<span>最后一页</span>"; } ?> <tr align="center"> <td colspan="2"><?php echo $key;?></td> </tr> </table> </div>