php·ÖÒ³

<?php
//·ÖÒ³
$link=mysql_connect("localhost","root","root");
$db=mysql_select_db("bustest",$link);
$res=mysql_query("select * from info");
//Ò»¹²¶àÉÙÌõ
$count=mysql_num_rows($res);
//ÿҳ5ÌõÐÅÏ¢
$perpage=5;
//Ò»¹²¶àÉÙÒ³
$pagecount=ceil($count/$perpage);
//´«¹ýÀ´µÄÒ³Êý
$pagenum=$_REQUEST['page'];
//ÅжÏ$pagenumÊÇ·ñÓÐÖµ
if(!isset($pagenum)){
 $pagenum=1;
}elseif($pagenum>$pagecount){
$pagenum=$pagecount;
}elseif($pagenum<=0){
$pagenum=1;
}
//²éѯ
$sql="select * from info limit ".($pagenum-1)*$perpage.",".$perpage;
$resc=mysql_query($sql);
print("<table border='1'>");
print("<tr><th>ID</th><th>NAME</th></tr>");
while($row=mysql_fetch_array($resc)){
 print("<tr><td>");
 print $row["id"];
 print("</td><td>");
 print $row["name"];
 print("</td></tr>");
 }
 print("</table>");
 mysql_free_result($resc);
mysql_free_result($res);
mysql_close($link);
print("<a href=".$_SERVER["PHP_SELF"]."?page=".($pagenum+1).">ÏÂÒ»Ò³</a>");
print("<a href=".$_SERVER["PHP_SELF"]."?page=".($pagenum-1).">ÉÏÒ»Ò³</a>");
?>