php+mysql分页优化版
时间:2022-03-10 17:32
1 <table align="center" cellspacing="2">
2 <?php
3 include(‘conn/conn2.php‘);
4 $pagesize=10;
5 $url=$_SERVER["REQUEST_URI"];//取当前url路径
6 $url=parse_url($url); //查询当前路径所以值
7 $url=$url[path];//查询当前路径path的值
8
9 $numq=mysql_query("select * from tb_article");
10 $num=mysql_num_rows($numq); //总数
11
12 if($_GET[page]){
13 $pageval=$_GET[page]; //获取当前页
14 $page=($pageval-1)*$pagesize; //从第几条记录开始
15 $page.=‘,‘;
16 }
17
18 $pageceil=ceil($num/$pagesize); //共有几页记录
19
20 $sql="select * from tb_article order by now desc limit $page $pagesize";
21 $query=mysql_query($sql);
22
23 while($res_article=mysql_fetch_array($query)){
24 ?>
25 <tr>
26 <td colspan="3" border-radius:10px 10px 10px 10px;;text-align:center;-moz-box-shadow: 0 0 2px #888;
28 -webkit-box-shadow: 0 0 2px#888;
29 box-shadow: 0 0px 0px #EFEFEF;" class="article_little"><?php echo csubstr($res_article[‘title‘],0,100);?></div></a></div></h3></td>
30 </tr>
31 <tr>
32 <td colspan="3">
33 <div alt="复制代码" src="/img/fz.gif">
php+mysql分页优化版,布布扣,bubuko.com