tzgl.php

论坛管理系统php＋mysql

<?php session_start();include ("../conn.php");  
?>
<?php
 $quer="select * from hw_zqxx where bz='$username'";
   $result=mysql_query($quer);
   $myrow=mysql_fetch_array($result);
  ?>
<style type="text/css">
<!--
.style1 {
	font-size: 20px;
	font-family: "宋体";
	font-weight: bold;
	}
.style2 {
	font-size: 13px;
	font-family: "宋体";
	font-weight: bold;
}
.style3 {
	font-size: 12px;
	font-family: "宋体";
}
.style4 {font-size: 13px;
	font-family: "宋体";
	font-weight: normal;
}
-->
</style>
<table width="590" border="0" cellpadding="0" cellspacing="0">

  <tr>
    <td height="30"  colspan="4" align="center"><span class="style1">主 题 管 理</span></td>
    
  </tr>
	
  <tr align="center" bgcolor="#CEFFCE">
    <td width="130" height="25"><span class="style3">主 题</span></td>
    
    <td width="80" class="style3">作 者</td>
	<td width="80">时间</td>
	<td width="50">屏蔽</td>
	<td width="50">冻结</td>
	<td width="40">锁定</td>
	<td width="80">回复帖子</td>
	<td width="40">修改</td>
    <td width="40" class="style3">删 除</td>
  </tr>
  
  <?php 
    
  if($page){
       $page_size=8;
       $query="select count(*)total from hw_tzxx 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_tzxx where zq='$myrow[zq]' order by id desc limit $offset,$page_size";
	   $result=mysql_query($query);
	   if($result){
	   while($myrow=mysql_fetch_array($result)){
  ?>
  <tr align="center" onMouseDown="this.bgColor='#C4E1FF'" onMouseOut="this.bgColor='#FFE1E1'" onMouseMove="this.bgColor='#DDFFFF'">
    <td height="30"><span class="style3"><a href="showtz.php?zhuti=<?php echo urlencode($myrow[zhuti]);?>&recid=<?php echo $myrow[id];?>" target="_blank"><?php echo $myrow[zhuti];?></a></span></td>
    
    <td class="style3"><?php echo $myrow[username];?></td>
	<td class="style3"><?php echo $myrow[fbsj];?></td>
	<td class="style3"><?php echo $myrow[pb];?></td>
	<td class="style3"><?php echo $myrow[dj];?></td>
	<td class="style3"><?php echo $myrow[sd];?></td>
	 <td><a href="hftz.php?id=<?php echo $myrow[id];?>">查看</a></td>
	<td><a href="changetz.php?id=<?php echo $myrow[id];?>">更改</a></td>
    <td class="style2"><a href="delete.php?tz=<?php echo urlencode(帖子管理);?>&id=<?php echo $myrow[id];?>" class="style3">删除</a></td>
  </tr>
  <?php }}}?>
  <tr>
    <td height="30" colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr class="style4">
        <td width="50%" class="#ff0000">&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>