！！！！！！！！！！！！！如何实现分页显示！！！！！！！！！！！！

<?php
$masterip="127.0.0.1";
if ($REMOTE_ADDR==$masterip)
{
?>
<html>
<head>
<title>学籍管理系统</title>
</head>
<body bgcolor="#004784" text="#ffffff">
<?php
if (isset($name)and isset($num)and isset($sex) and isset($age)and isset($dep)and isset($regtime))
{
$con=mysql_connect("localhost","root","");
mysql_select_db("xuejiguanli");
 $query="insert into student(name,num,sex,age,dep,regtime,id)
 values ('$name','$num','$sex','$age','$dep','$regtime','$id')";
 $stmt = mysql_query($query,$con);

 }
/******************分页显示*****************/
$con=mysql_connect("localhost","root","");
mysql_select_db("xuejiguanli");
$query="select name,num,sex,age,dep,regtime,id";
$query.="from student";
$result=mysql_query("$query",$con);
if (empty($offset)) {
$offset=0;
}
$number=mysql_num_rows($result);
$see=$offset/4+1;
$all=$number/4;
$all=(int)$all+1;
$query="select name,num,sex,age,dep,regtime,id";
$query.="from student order by id limit $offset,4 ";
$result=mysql_query("$query",$con);
/******************分页显示*****************/echo " <center>朋友有空来坐坐 ";
echo "<table border='1' width='800' height='100'>";
$con=mysql_connect("localhost","root","");
mysql_select_db("xuejiguanli");
$query="select name,num,sex,age,dep,regtime,id ";
$query.="from student";
$result=mysql_query("$query",$con);
$number=mysql_num_rows($result);
echo "<center>目前有$number 位朋友在学籍管理系统中:";
echo " ";
echo "<tr>";
echo "<tr>";
echo "<tr>";
echo "<tr>";
echo "<td align='left'>选择</td>";
echo "<td align='left'>序号</td>";
echo "<td align='left'>姓名</td>";
echo "<td align='left'>学号</td>";
echo "<td align='left'>性别</td>";
echo "<td align='left'>年龄</td>";
echo "<td align='left'>系别</td>";
echo "<td align='left'>注册时间</td>";
echo "</tr>";
?>
<form method="post" action="submit.php">
<?php
$ttt=0;
while ($r=mysql_fetch_row($result)) {
$ttt++;
$name=$r[0];
$num=$r[1];
$sex=$r[2];
$age=$r[3];
$id=$r[6];
$dep=$r[4];
$regtime=$r[5];
echo "<tr>"; ?>
<td><input type=radio checked name=selected value=<?php echo $id ?>>
<?php
echo "<td align='left'>$ttt</td>";
echo "<td align='left'>$name</td>";
echo "<td align='left'>$num</td>";
echo "<td align='left'>$sex</td>";
echo "<td align='left'>$age</td>";
echo "<td align='left'>$dep</td>";
echo "<td align='left'>$regtime</td>";
echo "</tr>";}
echo "</table>";
mysql_close($con);
?>
 
<input type=submit name=submit value=添加记录>
<input type=submit name=submit value=删除记录>
<input type=submit name=submit value=修改记录>
<input type=submit name=submit value=退出系统>
</form>
<?/************上下翻页的超级链接********************************/?>
<?php
if($offset>0)
{
$preoffset=$offset-4;
echo "<a href=list.php?offset=$preoffset>前一页</a> \n";}
if (($offset+4)<$number) {
$newoffset=$offset+4;
echo "<a href=list.php?offset=$newoffset>下一页</a> \n";
}
?>
<?php
echo "
</body>
</html>";
}
else
{
?>
<html>
<head>
<title>学籍管理系统</title>
</head>
<body bgcolor="#004784" text="#ffffff">
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("xuejiguanli");
if (isset($name)and isset($num)and isset($sex) and isset($age)and isset($dep)and isset($regtime)and ($name!="")and ($num!="") and ($sex!="") and ($age!="") and ($dep!="") and ($regtime!=""))
{
 $query="insert into student(name,num,sex,age,dep,regtime,id)
 values ('$name','$num','$sex','$age','$dep','$regtime',null)";
 $stmt = mysql_query($query,$con);

 }
echo " <center>朋友有空来坐坐 ";
echo "<table border='1' width='800' height='100'>";
$query="select name,num,sex,age,dep,regtime,id ";
$query.="from student";
$result=mysql_query("$query",$con);
$rownumber=mysql_num_rows($result);
echo "<center>目前有$rownumber位朋友在学籍管理系统中:";
echo " ";
echo "<tr>";
echo "<tr>";
echo "<tr>";
echo "<tr>";
echo "<td align='left'>选择</td>";
echo "<td align='left'>序号</td>";
echo "<td align='left'>姓名</td>";
echo "<td align='left'>学号</td>";
echo "<td align='left'>性别</td>";
echo "<td align='left'>年龄</td>";
echo "<td align='left'>系别</td>";
echo "<td align='left'>注册时间</td>";
echo "</tr>";?>
<form method="post" action="submit.php">
<?php
$ttt=0;
while ($r=mysql_fetch_row($result)) {
$ttt++;
$name=$r[0];
$num=$r[1];
$sex=$r[2];
$age=$r[3];
$id=$r[6];
$dep=$r[4];
$regtime=$r[5];
echo "<tr>"; ?>
<td><input type=radio checked name=selected value=<?php echo $id ?>>
<?php
echo "<td align='left'>$ttt</td>";
echo "<td align='left'>$name</td>";
echo "<td align='left'>$num</td>";
echo "<td align='left'>$sex</td>";
echo "<td align='left'>$age</td>";
echo "<td align='left'>$dep</td>";
echo "<td align='left'>$regtime</td>";
echo "</tr>";}
echo "</table>";
mysql_close($con);
?>
</form>
</body>
</html>
<?php
}
?>可以了吗？

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

surfchen老师
这几处/******************分页显示*****************/
为了能使各位老师看清我的程序，我临时自己加上的。运行时我会删掉，错误不在这，我觉的在程序当中。
可是我没查出来。
您好人做到底吧，还麻烦您再帮着查一次。上次ip验证您给调通了，谢了
试试
/******************分页显示*****************/
$con = mysql_connect("localhost","root","");
mysql_select_db("xuejiguanli");
$query = "select name,num,sex,age,dep,regtime,id";
$query.= "from student";
$result = mysql_query("$query",$con);
$offset = $_GET['offset'];
if (!isset($offset)||$offset=='')
{
    $offset=0;
}
$number = @mysql_num_rows($result);
$see = $offset/4+1;
$all = $number/4;
$all = (int)$all+1;
$query = "select name,num,sex,age,dep,regtime,id";
$query.= "from student order by id limit $offset,4 ";
$result = @mysql_query("$query",$con);
/******************分页显示*****************/
ustb老师您修改后的程序调试后，屏幕不再显示错误信息，但是无法实现分页功能。surfchen老师按照以前的做法。系统提示：Warning: Supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\dzy\list.php on line 30
你的SQL语句不正确，或者是查询中有错误，错误不在分页
你的数据库中有数据了吗？如果没有，当然没有分页了，同时也会出现你说所的错误。
如果有数据了，那么就是你的查询语句有错误了。ustb给的方法只是不让错误显示在浏览器上。(加@)