PHP简单分页

来源：互联网发布：阳春网络问政主页编辑：程序博客网时间：2024/05/17 01:45

<?php

//改变数据库名之后即可使用的分页

    include 'conn.php';  //这里添加一个数据库连接即可，变换成自己设定的链接
    $page=$_GET['page']; //翻页选项首页，下一页，上一页，尾页
   $current= $_GET['current']; //当前页数

mysql_select_db("leaveword");//使用的数据名
$result=mysql_query("select * from msgs",$connection);//改变数据

         $total=mysql_num_rows($result);
        $pagesize=3;
                    if   (($total%$pagesize)!=0)
                    $totalpage=intval($total/$pagesize)+1;

                    else
                    $totalpage=intval($total/$pagesize);
                    if   ($page=="")
                    $current=1;
                    else{
                    switch($page){
                    case   "首页":
                    $current=1;
                    break;
                    case   "上一页":
                    $current=intval($current)-1;

                    break;
                    case   "下一页":
                    $current=intval($current)+1;
                    break;
                    case   "尾页":
                    $current=$totalpage;
                    break;}
                    }
    if($total<>0){
                        mysql_data_seek($result,(($current-1)*$pagesize));
                                              }

          $i=1;

          ?>
          <?php
          echo "<div align='center'>留言薄</div><br>";
        while($row=mysql_fetch_array($result))
        {

        ?>
      这里是数据库读取的数据，可替换相应数据
       <table width="70%" align="center">
<tr>

    <td>Author:<?php echo $row["author"] ?></td>
</tr>
<tr>
    <td><?php echo $row["message"]?></td>
</tr>
<tr align="right">
    <td align="right"><?php echo $row["postTime"]?></td>
</tr>
</table>
<hr></hr>
<?php


      $i++;
            if   ($i>$pagesize)
          break;

            else
              continue;
                    }
          ?>
         <?php

echo "共".$totalpage."页当前第".$current."页         " ;

          echo   "<a   href=".$_SERVER['PHP_SELF']."?page=首页>首页</a>   ";
       if   ($current>1){

        echo   "<a   href=".$_SERVER['PHP_SELF']."?page=上一页&current=".$current.">上一页</a>   ";   }
     if   ($current!=$totalpage){

        echo   "<a   href=".$_SERVER['PHP_SELF']."?page=下一页&current=".$current.">下一页</a>   ";   }

        echo   "<a   href=".$_SERVER['PHP_SELF']."?page=尾页>尾页</a>   ";

         ?>