zqgl.php

论坛管理系统php＋mysql

<?php session_start(); include "../conn.php"; ?>
<?php $zqtb1=("image/zqtb/zqtb1.gif");
	   $zqtb2=("image/zqtb/zqtb2.gif");
	   date_default_timezone_set('PRC');
       $date=date("Y-m-d h:i:s");
       if($zhuijia=="追加专区"){
	       if($zq=="")
		  { echo "<script>alert('请输入专区名称！！');history.back();;</script>";
	      }
		 else 
		 {if($bz=="")
		  { $quer="select * from hw_user where banzhu='否' order by jf desc";
		     $result=mysql_query($quer);
			 $myrow=mysql_fetch_array($result);
			 $bz=$myrow[username];
			 }
			 $quer="select * from hw_user where username='$bz'";
			 $result=mysql_query($quer);
			 $myrow=mysql_fetch_array($result);
			 if($myrow[id]==""){echo "<script>alert('版主不存在，请重新输入！！');history.back();;</script>";}
			 else
	     
		 { $query="insert into hw_zqxx (bz,zq,tb,cjsj)values('$bz','$zq','$tb','$date')";
	      $result=mysql_query($query);
		  if($result){
		    echo "<meta http-equiv=\"refresh\" content=\"0;url=$furl\">";
		  }else{  echo "追加失败!!";} 
		  }	 
	   }
	   }
	   
?>
<style type="text/css">
<!--
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
.style1 {
	font-size: 13px;
	font-family: "宋体";
	font-weight: normal;
}
-->
</style>
<table width="590" border="1" cellpadding="0" cellspacing="0">
  <form name="myform" method="post" action="index.php?lmbs=专区管理" enctype="multipart/form-data">
    <tr>
      <td height="30" colspan="2" align="center">专区管理</td>
      <td width="220">&nbsp;</td>
    </tr>
    <tr>
      <td width="170" height="30" align="center"><span class="style1">版主:
          <input name="bz" type="text" id="bz" size="15">
      </span></td>
      <td width="200" align="center" class="style1">所属专区:      
        <label>
        <input name="zq" type="text" id="zq" size="15">
      </label></td>
      <td align="center" valign="middle" class="style1">图标:
          <input type="radio" name="tb" value="<?php echo $zqtb1;?>">
        <img src='image/zqtb/zqtb1.gif' width='24' height='24'>
          <input type="radio" name="tb" value="<?php echo $zqtb2;?>">
		  <img src='image/zqtb/zqtb2.gif' width='24' height='24'>
      </td>
    </tr>
    <tr>
      <td colspan="2">&nbsp;</td>
      <td class="style1"><input name="zhuijia" type="submit" id="zhuijia" value="追加专区"></td>
    </tr>
  </form>
</table>
<table width="590" border="0" cellpadding="0" cellspacing="0">
  <tr align="center" bgcolor="#D0E8FF" class="style1">
    <td width="70" height="30">图 标</td>
    <td width="100">专区名称</td>
    <td width="80" bgcolor="#D0E8FF">版 主</td>
    <td width="80">时间</td>
	<td width="50">屏蔽</td>
	<td width="50">冻结</td>
	<td width="50">锁定</td>
	<td width="50">修改</td>
    <td width="60">删除</td>
  </tr>
<?php  $query="select * from hw_zqxx where id";
        $result=mysql_query($query);
        if($result){
        while($myrow=mysql_fetch_array($result)){  ?>
  <tr align="center" class="style1">
    <td height="30"><?php echo "<img src=\"$myrow[tb]\">";?></td>
    <td><?php echo $myrow[zq];?></td>
    <td><?php echo $myrow[bz];?></td>
    <td><?php echo $myrow[cjsj];?></td>
	<td><?php echo $myrow[pb];?></td>
	<td><?php echo $myrow[dj];?></td>
	<td><?php echo $myrow[sd];?></td>
	<td><a href="changebk.php?id=<?php echo $myrow[id];?>">更改</a></td>
    <td><a href="delete.php?lmbs=<?php echo urlencode(专区管理);?>&id=<?php echo $myrow[id];?>">删除</a></td>
  </tr>
  <?php }}?>
</table>