<?php

require_once '../include.php';

header("content-type:text/html;charset=utf-8");

$sql="select * from imooc_admin";

$totalRows=getResultNum($sql);

$pageSize=3;

//得到總頁碼數

$totalPage=ceil($totalRows/$pageSize);

$page=$_REQUEST['page']?(int)$_REQUEST['page']:1;

if($page<1||$page==null||!is_numeric($page)){

$page=1;

}

if($page>=$totalPage)$page=$totalPage;

$offset=($page-1)*$pageSize;

$sql="select * from imooc_admin limit{$offset},{$pageSize}";

$rows=fetchAll($sql);

print_r($rows);

foreach($rows as $row){

echo "編號:".$row['id'],"<br/>";

echo "管理員的名稱:".$row['username'],"<hr/>";

}

$url=$_SERVER['PHP_SELF'];

$index=($page==1)?"首頁":"<a href='{$url}?page=1' >首頁</a>";

$last=($page==$totalPage)?"尾頁":"<a href='{$url}?page={$totalPage}'>尾頁</a>";

$prev=($page==1)?"上一頁":"<a href='{$url}?page=".($page-1)."'>上一頁</a>";

$next=($page==$totalPage)?"下一頁":"<a href='{$url}?page=".($page+1)."'>下一頁</a>";

$str="總共{$totalPage}頁/當前是第{$page}頁";

for($i=1;$i<=$totalPage;$i++){

if($page==$i){

//當前頁無連接

$p.="[{$i}]";

}else{

$p.="<a href='{$url}?page={$i}'>[{$i}]</a>";

}

}

echo $str.$index.$prev.$p.$next.$last;