请问如在在主题的留言里面进行分页显示留言? 我做了一个留言板,但属于论坛的着一种,可以发布主题,然后在主题里面可以对这个主题进行留言,现在遇到一个让我头疼的问题就是分页了,分页的第一页可以显示,然后按第二页的时候就为空显示了所以来这里请教大家,如何对主题的留言进行分页呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?phpheader("Content-type:text/html;charset=utf-8");include("db_conn.php");include("db_func.php");include("check.php");if(isset($_GET['page'])){ $page=$_GET['page'];}else{$page=1;}$pagesize=10;function csdy($table,$pagesize,$dyym){if(isset($_GET['page'])){ $page=$_GET['page'];}else{$page=1;}$sql="select * from revert WHERE PostID = '$_GET[id]'"; //这个是主题的ID$result=mysql_query($sql);$num=mysql_num_rows($result);if($num){ if($num<$pagesiz) { $pagecount=1; } if($num%$pagesize) { $pagecount=(int)($num/$pagesize)+1; } else { $pagecount=($num/$pagesize); }}else{$pagecount=0;}$fypage="共有".$num."条记录 ".$pagesize."条记录/页";$fypage.=" 当前:第".$page."/共".$pagecount."页 " ;if($page==1){$fypage.=' 首页 | 上一页 |';}else{$fypage.='<a href='.$dyym.'?page=1>首页</a> | <a href='.$dyym.'?page='.($page-1).'>上一页</a> |';}if($page==$pagecount||$pagecount==0){$fypage.=' 下一页 | 尾页 ';}else{$fypage.=' <a href='.$dyym.'?page='.($page+1).'> 下一页</a> | <a href='.$dyym.'?page='.$pagecount.'>尾页</a> ';}$fypage.='转到:<select name="select" onchange="javascript:window.location.href=this.options[this.selectedIndex].value">';$a=1;while($a<=$pagecount){ if($a==$page) { $fypage.="<option selected value=".$dyym."?page=".$a.">第".$a."页</option>"; } else { $fypage.="<option value=".$dyym."?page=".$a.">第".$a."页</option>"; } $a=$a+1;}$fypage.="</select>";echo $fypage;}?><html><head><link href="images/private.css" rel="stylesheet" type="text/css" /><script language='javascript' src='images/private.js'></SCRIPT> <SCRIPT language=javascript>function CheckAll(form){ for (var ii=0;ii<form.elements.length;ii++) { var e = form.elements[ii]; if (e.Name != "chkAll") e.checked = form.chkAll.checked; }}function Checked(){ var jj = 0 for(ii=0;ii < document.form.elements.length;ii++){ if(document.form.elements[ii].name == "adid[]"){ if(document.form.elements[ii].checked){ jj++; } } } return jj;}function DelAll(){ if(Checked() <= 0){ alert("您至少选择1条信息!"); } else{ if(confirm("确定要删除选择的信息吗?\n此操作不可以恢复!")){ form.action="delrevert.php?del=data"; form.submit(); } }}</SCRIPT><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>文章管理</title></head><body ><FORM name=form method=post> <table border=0 cellspacing=1 align=center class=navi> <tr> <th>当前位置:文章管理 >> 文章管理</th> </tr> </table><br><table width="75%" border="0" align="center" cellpadding="0" cellspacing="1" class="list"> <tr> <th width="100%" height="25" align="center" bgcolor="#FF0000" colspan="8"> 留言管理</th> </tr> <tr> <td width="3%" height="25" align="center" bgcolor="#FF0000"><span class="style1">ID</span></td> <td width="10%" align="center" bgcolor="#FF0000"><span class="style1">回复人</span></td> <td width="38%" align="center" bgcolor="#FF0000"><span class="style1">回复内容</span></td> <td width="14%" align="center" bgcolor="#FF0000">回复时间</td> <td width="9%" align="center" bgcolor="#FF0000"><span class="style1">操作</span></td> <td width="4%" align="center" bgcolor="#FF0000"> <input id=chkAll onClick=CheckAll(this.form) type=checkbox value=checkbox name=chkAll></td> </tr><?php$id=$_GET["id"];$sql="select * from revert WHERE PostID = '$id' order by RevertTime desc limit ".($page-1)*$pagesize.','.$pagesize;$result=mysql_query($sql);$i=0;while($rs=mysql_fetch_array($result,MYSQL_ASSOC)){$text_sql = "SELECT * FROM member WHERE UserID = '$rs[UserID]'";$ShowDetailResult = db_query($text_sql); $row = db_fetch_array($ShowDetailResult);$i=$i+1;?> <tr bgcolor="#FFFFFF"> <td height="22" align="center"><?php echo $rs['RevertID']; ?></td> <td align="center"><?php echo $row["UserName"]; ?></td> <td align="center"><?php echo $rs['RevertText']; ?></td> <td align="center"><?php echo date("Y-m-d H:i:s",$rs['RevertTime']+8*3600); ?></td> <td align="center"><a onClick="return confirm('确定删除?')" href="delrevert.php?id=<?php echo $rs['RevertID']; ?>" onClick="return confirm('确定是否删除')">删除</a></td> <td align="center"><input type="checkbox" name="adid[]" value="<?php echo $rs['RevertID']; ?>" onClick=Checked(form)></td> </tr> <?php } ?></table><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="list" height="31"> <tr bgcolor="#FFFFFF"> <td height="31" align="center"><?php csdy("revert",$pagesize,"revert.php"); ?></td><td width="100"> <p align="right"><INPUT title=删除 onclick=DelAll() type=button value=删除 name=Submit><INPUT title=返回 onclick="history.go(-1)" type=button value=返回 name=Submit1></td> </tr></table></form><% end ifrs.closeset rs=nothing%></body></html>以上是我的代码 如何用ajax实现无刷新更新图片 mysql_num_row()一直为0?????? PHP 循环一周的日历 招IVR工程师一名 rename函数,是不是就相当于剪切移动? 菜鸟求救!! 刚学PHP两天-----图片上传问题 急! 如何定位并取得指定网上的文件信息? 关于网上会议? isset怎么没有用啊! php-java-bridge配置问题 跪求:: 请求帮助,,,在线跪等
header("Content-type:text/html;charset=utf-8");
include("db_conn.php");
include("db_func.php");
include("check.php");if(isset($_GET['page']))
{
$page=$_GET['page'];
}
else
{
$page=1;
}$pagesize=10;function csdy($table,$pagesize,$dyym)
{if(isset($_GET['page']))
{
$page=$_GET['page'];
}
else
{
$page=1;
}$sql="select * from revert WHERE PostID = '$_GET[id]'"; //这个是主题的ID
$result=mysql_query($sql);
$num=mysql_num_rows($result);
if($num)
{
if($num<$pagesiz)
{
$pagecount=1;
} if($num%$pagesize)
{
$pagecount=(int)($num/$pagesize)+1;
}
else
{
$pagecount=($num/$pagesize);
}
}
else
{
$pagecount=0;
}$fypage="共有".$num."条记录 ".$pagesize."条记录/页";
$fypage.=" 当前:第".$page."/共".$pagecount."页 " ;if($page==1)
{
$fypage.=' 首页 | 上一页 |';
}
else
{
$fypage.='<a href='.$dyym.'?page=1>首页</a> | <a href='.$dyym.'?page='.($page-1).'>上一页</a> |';
}if($page==$pagecount||$pagecount==0)
{
$fypage.=' 下一页 | 尾页 ';
}
else
{
$fypage.=' <a href='.$dyym.'?page='.($page+1).'> 下一页</a> | <a href='.$dyym.'?page='.$pagecount.'>尾页</a> ';
}
$fypage.='转到:<select name="select" onchange="javascript:window.location.href=this.options[this.selectedIndex].value">';
$a=1;
while($a<=$pagecount)
{
if($a==$page)
{
$fypage.="<option selected value=".$dyym."?page=".$a.">第".$a."页</option>";
}
else
{
$fypage.="<option value=".$dyym."?page=".$a.">第".$a."页</option>";
}
$a=$a+1;
}
$fypage.="</select>";
echo $fypage;
}
?>
<html>
<head>
<link href="images/private.css" rel="stylesheet" type="text/css" />
<script language='javascript' src='images/private.js'></SCRIPT>
<SCRIPT language=javascript>
function CheckAll(form)
{
for (var ii=0;ii<form.elements.length;ii++)
{
var e = form.elements[ii];
if (e.Name != "chkAll")
e.checked = form.chkAll.checked;
}
}
function Checked()
{
var jj = 0
for(ii=0;ii < document.form.elements.length;ii++){
if(document.form.elements[ii].name == "adid[]"){
if(document.form.elements[ii].checked){
jj++;
}
}
}
return jj;
}function DelAll()
{
if(Checked() <= 0){
alert("您至少选择1条信息!");
}
else{
if(confirm("确定要删除选择的信息吗?\n此操作不可以恢复!")){
form.action="delrevert.php?del=data";
form.submit();
}
}
}
</SCRIPT>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>文章管理</title>
</head><body >
<FORM name=form method=post> <table border=0 cellspacing=1 align=center class=navi>
<tr>
<th>当前位置:文章管理 >> 文章管理</th>
</tr>
</table>
<br>
<table width="75%" border="0" align="center" cellpadding="0" cellspacing="1" class="list">
<tr>
<th width="100%" height="25" align="center" bgcolor="#FF0000" colspan="8">
留言管理</th>
</tr>
<tr>
<td width="3%" height="25" align="center" bgcolor="#FF0000"><span class="style1">ID</span></td>
<td width="10%" align="center" bgcolor="#FF0000"><span class="style1">回复人</span></td>
<td width="38%" align="center" bgcolor="#FF0000"><span class="style1">回复内容</span></td>
<td width="14%" align="center" bgcolor="#FF0000">回复时间</td>
<td width="9%" align="center" bgcolor="#FF0000"><span class="style1">操作</span></td>
<td width="4%" align="center" bgcolor="#FF0000">
<input id=chkAll
onClick=CheckAll(this.form) type=checkbox
value=checkbox name=chkAll></td>
</tr>
<?php
$id=$_GET["id"];
$sql="select * from revert WHERE PostID = '$id' order by RevertTime desc limit ".($page-1)*$pagesize.','.$pagesize;
$result=mysql_query($sql);
$i=0;
while($rs=mysql_fetch_array($result,MYSQL_ASSOC))
{
$text_sql = "SELECT * FROM member WHERE UserID = '$rs[UserID]'";
$ShowDetailResult = db_query($text_sql);
$row = db_fetch_array($ShowDetailResult);
$i=$i+1;
?>
<tr bgcolor="#FFFFFF">
<td height="22" align="center"><?php echo $rs['RevertID']; ?></td>
<td align="center"><?php echo $row["UserName"]; ?></td>
<td align="center"><?php echo $rs['RevertText']; ?></td>
<td align="center"><?php echo date("Y-m-d H:i:s",$rs['RevertTime']+8*3600); ?></td>
<td align="center"><a onClick="return confirm('确定删除?')" href="delrevert.php?id=<?php echo $rs['RevertID']; ?>" onClick="return confirm('确定是否删除')">删除</a></td>
<td align="center"><input type="checkbox" name="adid[]" value="<?php echo $rs['RevertID']; ?>" onClick=Checked(form)></td>
</tr>
<?php } ?>
</table>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="list" height="31">
<tr bgcolor="#FFFFFF">
<td height="31" align="center"><?php csdy("revert",$pagesize,"revert.php"); ?></td><td width="100">
<p align="right"><INPUT title=删除 onclick=DelAll() type=button value=删除 name=Submit><INPUT title=返回 onclick="history.go(-1)" type=button value=返回 name=Submit1></td> </tr>
</table></form>
<%
end if
rs.close
set rs=nothing
%>
</body>
</html>以上是我的代码