<?
extract($_GET);
$connect=mysql_connect("localhost","root","");
$select=mysql_select_db("mu",$connect);
$result=mysql_db_query("mu","select * from son");
$total=mysql_num_rows($result);
$pic= '<img src="images/real.gif">';
$pagesize=10;
if (($total%$pagesize)!=0)
$totalpage=intval($total/$pagesize)+1;
else
$totalpage=intval($total/$pagesize);
if ($page=="")
$current=1;
else{
switch($page){
case "首页":
$current=1;
break;
case "上一页":
$current=$curpage-1;
break;
case "后一页":
$current=$curpage+1;
break;
case "尾页":
$current=$totalpage;
break;}
}
?>
<b>第<?=$current;?>页,共<?=$totalpage;?>页.......共<?=$total;?>条记录
<?
if($total<>0){
mysql_data_seek($result,(($current-1)*$pagesize));
}
$i=1;
?>
<table border="1" bgcolor="#F0FEE7" bordercolor="#336666">
<?
while($row=mysql_fetch_row($result))
{
?>
<tr>
<td><?=$row[0];?></td>
<td><?=$row[1];?></td>
<td><?=$row[2];?></td>
<td><?=$row[3];?></td>
<td><a href="play.php?id=<?=$row[0];?>"><?=$pic;?></a></td>
</tr>
<?
$i++;
if ($i>$pagesize)
break;
else
continue;
}
?>
</table>
<form name="form1" method="post" action="<?=$_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="curpage" value="<?echo $current;?>">
<input type="submit" name="page" value="首页">
<? if($current>1):?>
<input type="submit" name="page" value="上一页">
<? endif;
if($current<>$totalpage):?>
<input type="submit" name="page" value="后一页">
<? endif;?>
<input type="submit" name="page" value="尾页">
</form>
改为extract($_POST);以后可以实现分页了
但是当我点击上一页时会显示如下错误;
PHP Warning: mysql_data_seek(): Offset -10 is invalid for MySQL result index 2 (or the query data is unbuffered) in c:\website\music\index.php on line 34