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