? ?? ?? ???? ??? ? SQL ?? ?? ?????? ???? ???? ???? ???? ???.

??? ??? ??? ???? ?? ? ?? ???? ???? ??? ?????. ???? ?? ??? ????? ????? ????.

? ???? ??? ? ?? 8? ??

$pagesize=8;

?? ?? ???? ???? ?? ??? ?? ?????. $pagecount

<?php
$pagesize = 8; //每頁(yè)顯示數(shù)
$SQL = "SELECT * FROM yx_books";
$rs = mysqli_query($link,$sql);
$recordcount = mysqli_num_rows($rs);
//mysql_num_rows() 返回結(jié)果集中行的數(shù)目。此命令僅對(duì) SELECT 語(yǔ)句有效。
$pagecount = ($recordcount-1)/$pagesize+1;  //計(jì)算總頁(yè)數(shù)
$pagecount = (int)$pagecount;
?>

?? ??? ???? $pageno

?? ???? ?? ??? ????? ? ?? ????? ?? ?? ? ?? ???? ?????.

?? ??? ?? ?? ??? ??? ? ?? ?? ??? ?? ??? ???? ?????.

? ???? ???? ??? ??? ?????.

<?php
$pageno = $_GET["pageno"];   //獲取當(dāng)前頁(yè)
if($pageno == "")
{
   $pageno=1;   //當(dāng)前頁(yè)為空時(shí)顯示第一頁(yè)
}
if($pageno<1)
{
   $pageno=1;    //當(dāng)前頁(yè)小于第一頁(yè)時(shí)顯示第一頁(yè)
}
if($pageno>$pagecount)  //當(dāng)前頁(yè)數(shù)大于總頁(yè)數(shù)時(shí)顯示總頁(yè)數(shù)
{
   $pageno=$pagecount;
}
$startno=($pageno-1)*$pagesize;  //每頁(yè)從第幾條數(shù)據(jù)開(kāi)始顯示
$sql="select * from yx_books order by id desc limit $startno,$pagesize";
$rs=mysqli_query($link,$sql);
?>

while ?? ???? HTML ??? ??????? ?? ? ??? ?????? ?????.

<?php
while($rows=mysqli_fetch_assoc($rs))
{
   ?>
   <tr align="center">
      <td class="td_bg" width="6%"><?php echo $rows["id"]?></td>
      <td class="td_bg" width="25%" height="26"><?php echo $rows["name"]?></td>
      <td class="td_bg" width="11%" height="26"><?php echo $rows["price"]?></td>
      <td class="td_bg" width="16%" height="26"><?php echo $rows["uploadtime"]?></td>
      <td width="11%" height="26" class="td_bg"><?php echo $rows["type"]?></td>
      <td width="11%" height="26" class="td_bg"><?php echo $rows["total"]?></td>
      <td class="td_bg" width="20%">
         <a href="update.php?id=<?php echo $rows['id'] ?>" class="trlink">修改</a>&nbsp;&nbsp;
         <a href="del.php?id=<?php echo $rows['id'] ?>" class="trlink">刪除</a>
      </td>
   </tr>
   <?php
}
?>

????? ????, ?? ???, ?? ??? ? ??? ??? ?? ?????.

?? ???? ? ?? ???? ?? ?? ???? ??? ??? ??? ?????.

?? ???? ?? ??? ?? ??, ????? ?? ???? ??? ?????.

??? ??? ????? ?????.

<tr>
   <th height="25" colspan="7" align="center" class="bg_tr">
      <?php
      if($pageno==1)
      {
         ?>
         首頁(yè) | 上一頁(yè) | <a href="?pageno=<?php echo $pageno+1?>&id=<?php echo $id?>">下一頁(yè)</a> |
         <a href="?pageno=<?php echo $pagecount?>&id=<?php echo $id?>">末頁(yè)</a>
         <?php
      }
      else if($pageno==$pagecount)
      {
         ?>
         <a href="?pageno=1&id=<?php echo $id?>">首頁(yè)</a> |
         <a href="?pageno=<?php echo $pageno-1?>&id=<?php echo $id?>">上一頁(yè)</a> | 下一頁(yè) | 末頁(yè)
         <?php
      }
      else
      {
         ?>
         <a href="?pageno=1&id=<?php echo $id?>">首頁(yè)</a> |
         <a href="?pageno=<?php echo $pageno-1?>&id=<?php echo $id?>">上一頁(yè)</a> |
         <a href="?pageno=<?php echo $pageno+1?>&id=<?php echo $id?>" class="forumRowHighlight">下一頁(yè)</a> |
         <a href="?pageno=<?php echo $pagecount?>&id=<?php echo $id?>">末頁(yè)</a>
         <?php
      }
      ?>
      &nbsp;頁(yè)次：<?php echo $pageno ?>/<?php echo $pagecount ?>頁(yè)&nbsp;共有<?php echo $recordcount?>條信息
   </th>
</tr>