【小编推荐】php分页的制作

2015-08-25   |   发布者:梁国芳   |   查看:3320次

php
<?php
            $nowpage =(isset($_GET['page']))?$_GET['page']:1;
        $count =3;
        $start =($nowpage -1)* $count;
          
           $result =$db->query("select * FROM weixin_down_25 WHERE catid=47 limit $start,$count");
            while($res =$db->fetch_array($result)){
               
                   
            ?>
            <dd>
           
                <div class="s_tu">
                    <img src="<?php echo $res['thumb'];?>" />
                    <div class="s_ind">
                        <div class="s_ind_wen">
                            <p><?php echo $res['introduce'];?></p>
                        </div>
                    </div>
                </div>
                <div class="s_wen">
                    <h2>【<?php echo $res['school']; ?>】课程置换方案</h2>
                    <ul>
                        <li>实施院校:<?php echo $res['school']; ?></li>
                        <li>实施时间:<?php echo $res['schooltime'];?></li>
                        <li>方案提供方:<?php echo $res['giver'];?></li>
                    </ul>
                    <a href="<?php echo $res['fileurl'];?>">文档下载</a>
                </div>
            </dd>
           <?php }
          
           $cat = $db->query("select COUNT(*) AS num FROM weixin_down_25 WHERE catid=47");
           $r = $db->fetch_array($cat);
          
          
           $allpages =ceil($r['num']/$count);//计算出页数
          
           $prevpage =$nowpage >1 ? ($nowpage-1):1;
          
           $nextpage =$allpages > $nowpage ?($nowpage+1):$allpages;
          
          
           ?>
        </dl>
        <div class="yeshu">
        <span><a href="http://www.weixin-sx.com/xiazai/school.php?page=<?php echo $prevpage?>">上一页</a></span>
        |&nbsp;&nbsp;<a><?php echo $page?></a>/<a><?php echo $allpages?></a>&nbsp;&nbsp;|
        <span><a href="http://www.weixin-sx.com/xiazai/school.php?page=<?php echo $nextpage?>">下一页</a></span>
        </div>