hftzgl.php

论坛管理系统php＋mysql

<?php session_start();include "../conn.php";if ($page=="") {$page=1;}?>


 <table bgcolor="#FFFFFF" width="590" height="25"><tr bgcolor="#FFFFFF"><td align="center" >回复帖子管理</td></tr></table> 
  <?php 
    $id=$_GET[id];
	  if($page){
       $page_size=8;
       $query="select count(*)total from hw_hftz where id";
	   $result=mysql_query($query);
	   $message_count=mysql_result($result,0,"total");
	   $page_count=ceil($message_count/$page_size);
	   $offset=($page-1)*$page_size;
	   $query="select * from hw_hftz where id order by id desc limit $offset,$page_size";
	   $result=mysql_query($query);
	   if($result){
	   while($myrow=mysql_fetch_array($result)){
  ?>
  <form name="form1"  enctype="multipart/form-data" method="post" action="savehftz.php?id=<?php echo $myrow[id];?>" onSubmit="return chkinput(this)">
  <table width="590" border="0" cellpadding="0" cellspacing="1" bgcolor="#6C6C6C">

  <tr align="center" bgcolor="#ffffff">
    <td width="290" height="25"><span class="style3">主 题：<input type="text" name="zhuti" size="25" class="inputcss" value="<?php echo $myrow[hfzt];?>"> </div></td>
    
    <td width="150" class="style3">作 者：<?php echo $myrow[username];?></td>
	<td width="150">时间：<?php echo $myrow[hfsj];?></td>
	</tr>
	<tr bgcolor="#FFFFFF" height="50">
	<td colspan="3" class="style1"><span style="style1"><textarea name="neirong" cols="81" rows="8"><?php echo $myrow[hfnr];?></textarea></td>
	</tr>
	<tr bgcolor="#FFFFFF">
	<td  colspan="3" height="25" valign="middle">&nbsp;&nbsp;屏蔽：<select name="pb" class="inputcss">
                  <option value="是" <?php if(trim($myrow[pb])=="是"){echo "selected";}?>>是</option>
                  <option value="否" <?php if(trim($myrow[pb])=="否"){echo "selected";}?>>否</option>
                  
                  
                </select>&nbsp;*&nbsp：被屏蔽的回复前台不能显示
            </div></td>
		</tr>
		<tr bgcolor="#FFFFFF" height="25" valign="middle">
	<td  colspan="3">&nbsp;&nbsp;锁定：<select name="sd" class="inputcss">
                  <option value="是" <?php if(trim($myrow[sd])=="是"){echo "selected";}?>>是</option>
                  <option value="否" <?php if(trim($myrow[sd])=="否"){echo "selected";}?>>否</option>
                  
                  
                </select>&nbsp;*&nbsp：被锁定的版块普通用户无权浏览
				</td>
	</tr>
	<tr bgcolor="#FFFFFF"  align="center" height="25" valign="middle">
	<td width="290"></td>
	<td width="150" ><input type="submit" class="buttoncss" value="更改"></td>
	</form>
	<form name="form"  enctype="multipart/form-data" method="post" action="deletehftz.php?id=<?php echo $myrow[id];?>" onSubmit="return chkinput(this)">
  
    <td width="150" class="style3"><input type="submit" class="buttoncss" value="删除"></td>
  
  </tr>
  </table>
  <table height="10">
  <tr><td></td></tr></table>
 </form>
  <?php }}}?>
  </td>
 
  
  <tr>
    <td height="30" colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr class="style4" >
        <td width="50%" class="#ff0000" align="right">&nbsp;&nbsp;页次：<font class="#ff0000"><?php echo $page;?></font> / <font class="#ff0000"><?php echo $page_count;?> </font>页 记录：<font class="#ff0000"><?php echo $message_count;?> </font>条&nbsp; </td>
        <td width="39%" class="#ff0000"> 分页：
            <?php
			    $lm=urlencode($lmbs);
       	        $xsoudh="lmbs=$lm";
				$next=$ljjl*10;
				$n=$ljjl-1;
				$m=$ljjl+1;	
                $prev_page=$page-10;						
					if ($ljjl==0){
                    echo "<img src=\"images/02.jpg\" width=\"8\" height=\"9\" title=\"首页\">";					
					}else
					{
                     echo "<a href='$PATH_INFO?vv=0&ljjl=0&page=1&$xsoudh'><img src=\"images/02.jpg\" width=\"8\" height=\"9\" border=\"0\" title=\"首页\"></a>&nbsp;";
					 $ccc=$vv-10;
                     echo "<a href='$PATH_INFO?vv=$ccc&ljjl=$n&page=$prev_page&$xsoudh' class=\"heise01\"><img src=\"images/01.jpg\" width=\"8\" height=\"9\" title=\"上十页\"></a>";
					}?>
            <?php	
 		        for ($j=1;$j<=$page_count;$j++) {
				       $pnext=$next+$j;
				       if ($mm==10){
					       break;
					   }
						if ($mm>$page_count){
							break;
						}
						if ($page_count-$vv<10){
	  						if ($mm>=$page_count-$vv){
								break;
							}									
						}
						?>
            <?php
                        echo "<a href='$PATH_INFO?vv=$vv&ljjl=$ljjl&page=$pnext&$xsoudh' class=\"huise01\"> $pnext </a>";											
              	        $mm=$mm+1;						
	     	     }
				 ?>
        </td>
        <td width="11%">
          <?php
				$vv=$vv+$mm;
				       if ($page_count-$vv<=0){
	                       echo "<img src=\"images/03.jpg\" width=\"8\" height=\"9\" title=\"尾页\">";					
					   }else{
	                       echo "<a href='$PATH_INFO?vv=$vv&ljjl=$m&page=$pnext&$xsoudh' class=\"huise01\"><img src=\"images/03.jpg\" width=\"8\" height=\"9\" title=\"下十页\"></a>";														
					   }
                if ($message_count==0){
					     echo "<font class=\"huise01\">没有记录!</font>";
				}
?>
        </td>
      </tr>
    </table></td>
  </tr>
</table>