PHP分页实现原理

<?php
$pageSize=10;
$page=isset($_GET['page'])?intval($_GET['page']):1;
//求總記錄數
$sql="select * from course_info";
$relut=mysql_query($sql);
$total=ceil(mysql_num_rows($relut)/$pageSize);
$sql="select * from course_info limit ".($page-1)*$pageSize.",".$pageSize;

$rows=mysql_query($sql);
while($row=mysql_fetch_array($rows))
{
?>
              <tr id="course_<?php echo $row['id']; ?>" οnmοuseοver="this.style.backgroundColor='#c4eafd';" οnmοuseοut="this.style.backgroundColor='#fff';">
              <td><?php echo $row['id']?></td><td><?php echo $row['cname']?></td><td><?php echo $row['ename']?></td>
              <td><img src="images/icon/icon_5.gif" width="16" height="16" />
              <a href="ctrl.php?ctrl=<?php echo $ctrl.'&id='.$row['id'].'&action=edit';?>">修改</a></td>
              <td><img src="images/icon/icon_6.gif" width="16" height="16" />
              <a href="javascript:void('0');" οnclick="del('<?php echo $row['id']; ?>');">刪除</a></td>
              </tr>
<?php } ?>
                      
            </table>
            <div class="cont_data_down">
            <div class="data_top_left"><img src="images/admin_cont_bg_11.jpg" width="5" height="30" /></div>
               <div class="data_top_right"><img src="images/admin_cont_bg_13.jpg" width="5" height="30" /></div>
               <table width="100%" height="29px;" style="text-align: center;">
                  <tr>
                    <td width="49%"><span>   當前第<?php echo $page;?>/<?php echo $total;?> 頁  </span></td><td width="51%">
<?php
if($page>1){
    echo "<a href='ctrl.php?ctrl=$ctrl&action=page&page=1'>[首頁]</a>";
}else {
   echo  "首頁&nbsp;";
}
if($page>1){
 echo "<a href='ctrl.php?ctrl=$ctrl&action=page&page=".($page-1)."'>[上一頁]&nbsp;</a>";
}else {
 echo  "上一頁&nbsp;";
 }

if($page<$total){
   echo "<a href='ctrl.php?ctrl=$ctrl&action=page&page=".($page+1)."'>[下一頁]&nbsp;</a>";
}else echo "下一頁&nbsp;";
echo "當前第".$page."頁/共".$total."頁";
if($page<$total){
echo "<a href='ctrl.php?ctrl=$ctrl&action=page&page=".$total."'>[尾頁]</a>";
}else{
 echo "尾頁";
}
?>