hfztgl.php

论坛管理系统php＋mysql

 <?php include("../conn.php"); if($page==""){$page=1;};?>
<style type="text/css">
<!--
.style1 {font-size: 13px;
	font-family: "宋体";
	font-weight: normal;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
.style2 {font-size: 12px}
-->
</style>

       <table width="593"  border="1" align="center" cellpadding="0" cellspacing="0">
		   <?php 
			if($page){$d=
			    $page_size=10;
				$quer="select count(*) as total from hw_hftz where id";
				$resul=mysql_query($quer);
				$message_count=mysql_result($resul,0,'total');
				$page_count=ceil($message_count/$page_size);
				$offset=($page-1)*$page_size;
				$quer="select * from hw_hftz where id order by id desc limit $offset ,$page_size";
				$resul=mysql_query($quer);
				if($resul){
				while($myrow=mysql_fetch_array($resul)){
				$sss=$myrow[username];
				?>
         <tr onMouseMove="this.bgColor='#62B0FF'" onMouseOut="this.bgColor='#FFFFBF'">
              <td height="28" colspan="2" align="center" class="style1"> <table width="500" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="555" class="style1">&nbsp;&nbsp;主题:<?php echo $myrow[zhuti];?> </td>
                    <td width="112">&nbsp;</td>
                    <td width="87" class="style1"><a href="delete.php?lmbs=<?php echo urlencode(回复主题);?>&id=<?php echo $myrow[id]?>;">删 除</a></td>
                  </tr>
                </table></td>
              <td>&nbsp;</td>
         </tr>
            <tr>
			<?php
			$query="select * from hw_user where username='$myrow[username]'";
		    $result=mysql_query($query);
		    $xq=mysql_fetch_array($result);    
			   ?> 
			  <td width="115" height="119" align="center"><table width="115" height="110" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td height="26" align="center" valign="middle" class="style1"><?php echo $myrow[username];?></td>
                </tr>
                <tr>
                  <td height="64" align="center" valign="middle"><img src="../<?php echo $xq[tx];?>"width="60" height="60"></td>
                </tr>
              </table>
		      </td>
              <td width="480" align="left" valign="top"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="90%" height="30" class="style1">&nbsp;回复主题:<?php echo $myrow[hfzt];?>&nbsp;&nbsp;</td>
                  <td width="10">&nbsp;</td>
                </tr>
                <tr>
                  <td height="20" align="right" valign="middle" bgcolor="#CCCCCC" class="style1">发表时间:<?php echo $myrow[hfsj];?></td>
                  <td bgcolor="#CCCCCC">&nbsp;</td>
                </tr>
                <tr valign="middle">
                
                  <td colspan="2" class="style2"><span class="style2">&nbsp;回复内容：&nbsp;<?php echo $myrow[hfnr];?></span></td>
                </tr>
              </table></td>
              <td width="1">&nbsp;</td>
            </tr>
             <?php }}}?>
			  <tr>
              <td height="25" colspan="2" align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr class="style1">
                  <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>
              <td>&nbsp;</td>
            </tr>
</table>