字号:小 中 大 修改 #这是我写的PHP网页分页技术。很简约,很实用。网上也有,但多有错误,且复杂而难懂。数据库名,表名分别用,aaaa,bbb#b代了。有空再作注释了。 <?php $limit=2; #每页显示的数据记录数 $yesu=isset($_GET['start'])?intval($_GET['start']):0; $s=isset($_GET['s'])?intval($_GET['s']):0; $yyy=isset($_GET['yy'])?intval($_GET['yy']):1; echo '$yesu=$start='.$yesu."<br>"; echo '$s='.$s."<br>"; echo '不$yyy='.$yyy."<br>"; 下五行是数据库打开等操作 $liaos=mysql_connect("localhost","root","123456"); mysql_query("use aaaa"); $result = mysql_query("select * from bbbb",$liaos); $num = mysql_num_rows($result); echo 'num$roww='.$num."<br>"; $yes=$yesu-2; $resul = mysql_query("select (jil) as ji,(xin) as xi,(shiji) as sh,(nar) as na from bbbb order by jil DESC limit $yes,$limit",$liaos); while ($resu=mysql_fetch_array($resul,MYSQL_BOTH)) { echo $resu["xi"].":".$resu["na"]." ".$resu["sh"]."<br>"; } echo "页:"." "; if ($s>10) {if ($s==11) {$st=$s-11;} else {$st=$s-10;} $pstart=$st*$limit; echo "<a href=bc.php?start=$pstart&s=$st>前十页</a>"; } echo "<<"; $star=$start; for ($page=$s;$page<($num/$limit+4);$page++) { $start= $page*$limit; if ($page!=$star/$limit) { $ye=$page!=($yesu/$limit)?"<a href=bc.php?start=$start&s=$s&yy=$page>$page</a>":"<font size=+1><u><b>$page</b></u></font>"; echo $ye." "; } if ($page>0&&($page%10)==0) { if($s==0){$s=$s+11;} else {$s=$s+10;} $start = $start+$limit; if ((($num/$limit)-1)>$page) { echo ">><a href=bc.php?start=$start&s=$s>后十页</a>"; } break; } } mysql_close($liaos); 运行后显示的效果如下图: |
共0条信息 暂时没有信息 |