select * from table_name ... limit start_pos, item_counts;
start_pos : 开始位置, item_counts : 操作条数
<table width="60%" border="1" cellpadding="5" cellspacing="1" bgcolor="#add3ef">
<?
// 1 connect to database
$link = @
mysql_connect("localhost", "root", "") or die ("connect to mysql failed");
@mysql_select_db("csxdb", $link) or die ("not find db student");
mysql_query("set names 'GBK'");
// 2 path of local page
$url = $_SERVER["REQUEST_URI"];
$arr = parse_url($url);
$path = $arr[path];
// 3 total num of records
$rset = mysql_query("select * from student");
$nums = mysql_num_rows($rset);
// 4 some initialized variable
$nPageSize = 5; // page size
$nsPos = 0; // start postion of record
$nPage = 1; // current page order
// 5 if request
if ($_GET[page])
{
$nPage = $_GET[page];
$nsPos = ($nPage-1) * $nPageSize;
}
// 6 echo the link text
if ($nums > $nPageSize)
{
$nTmp = ceil($nums/$nPageSize);
echo "共".$nTmp."页"." 第".$nPage."页 "
."<a href=$path?page=".($nPage<=1?1:$nPage-1).">上一页</a> "
."<a href=$path?page=".($nPage<$nTmp?$nPage+1:$nTmp)
.">下一页</a><br>";
}
// 7 select data from db and show it on page
$rset = mysql_query("select * from student limit $nsPos, $nPageSize");
while ($row = mysql_fetch_array($rset))
{
?>
<tr>
<td><?=$row[sno]?></td>
<td><?=$row[sname]?></td>
<td><?=$row[sage]?></td>
<td><?=$row[saddr]?></td>
</tr>
<?
}
mysql_close($link);
?>
</table>
