ss.php

论坛管理系统php＋mysql

<?php include "hyyz.php"; session_start();
if ($record==1) {?>
<style type="text/css">
<!--
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
	color: #000000;
}
.style4 {font-size: 13px;
	font-family: "宋体";
	font-weight: normal;
}
.style5 {font-size: 13px}
.style6 {font-size: 12px}
-->
</style>  <table width="590" border="1" cellpadding="0" cellspacing="0" bgcolor="#EFF3FF">
 <form name="form1" method="post" action="index.php?lmbs=<?php echo urlencode(关键字);?>">
  <tr>
    <td height="30" colspan="3" align="center"><span class="style5">搜索非法主题和内容</span></td>
    <td align="center"><span class="style5">关键字:
    </span>      <input name="key" type="text" id="key">   </td>
    <td width="79"><input type="submit" name="Submit" value="搜索"></td>
  </tr>
  </form>
  <tr align="center" class="style5">
    <td width="86" height="30">用户名</td>
    <td width="110">主题</td>
    <td colspan="2">内容</td>
    <td>删除</td>
  </tr>
  <?php 
  if($page){
     $page_size=8;
	 $sound="hfzt like '%$key%' or (hfnr like '%$key%')";
	 $query="select count(*) total from hw_hftz where $sound";
	 $result=mysql_query($query);
	 $message_counts=mysql_result($result,0,"total");
	 $page_count=ceil($message_counts/$page_size);
	 $offset=($page-1)*$page_size;
	 $query="select * from hw_tzxx where $sound order by id desc limit $offset,$page_size";
	 $result=mysql_query($query);
	 if($result){
	 while($myrow=mysql_fetch_array($result)){
  ?>
  <tr align="center" onMouseMove="this.bgColor='#D7F2FF'" onMouseOut="this.bgColor='#FFD9D9'">
    <td height="30" class="style6"><?php echo $myrow[username];?></td>
    <td class="style6"><?php echo $myrow[hfzt];?></td>
    <td colspan="2" class="style6"><?php echo htmlspecialchars($myrow[hfnr]);?></td>
    <td><a href="delete.php?lmbs=<?php echo urlencode(回复主题);?>&id=<?php echo $myrow[id];?>" class="style6">删除</a></td>
  </tr>
    <?php }}}?>
    <?php 
  if($page){
     $page_size=7;
	 $soundh="zhuti like '%$key%' or (neirong like '%$key%')";
	 $query="select count(*) total from hw_tzxx where $soundh";
	 $result=mysql_query($query);
	 $message_countd=mysql_result($result,0,"total");
	 $page_count=ceil($message_countd/$page_size);
	 $offset=($page-1)*$page_size;
	 $query="select * from hw_tzxx where $soundh order by id desc limit $offset,$page_size";
	 $result=mysql_query($query);
	 if($result){
 while($myrow=mysql_fetch_array($result)){	
  ?>
  <tr align="center" onMouseMove="this.bgColor='#D7F2FF'" onMouseOut="this.bgColor='#FFD9D9'">
	<td height="30" class="style6"><?php echo $myrow[username];?></td>
    <td class="style6"><?php echo $myrow[zhuti];?></td>
    <td colspan="2" class="style6"><?php echo htmlspecialchars($myrow[neirong]);?></td>
    <td><a href="delete.php?lmbs=<?php echo urlencode(主题管理);?>&id=<?php echo $myrow[id];?>" class="style6">删除</a></td>
  </tr>
  <?php }}}?>
  <tr>
    <td height="30" colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr class="style4">
        <td width="45%" 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_counts+$message_countd;?> </font>条</td>
        <td width="40%" 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="15%">
          <?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_counts+$message_countd==0){
					     echo "<font class=\"huise01\">没有记录!</font>";
				}
?>
        </td>
      </tr>
    </table></td>
  </tr>
</table>
<?php }else{
include "yzdl.php";
}
?>