manage.php

php模块设计。。。里面的模块很有学习价值

<?
	include("db_conn.php");
	include("db_func.php");

	// 使用 JOIN 语句将 member、member_info 及 level 三个 table 整
        // 合为一个 Table BEGIN
	$SQLStr = "SELECT member.*,member_info.*,level.* FROM member AS member ";
	$SQLStr .= "LEFT JOIN member_info AS member_info ON member.m_id = member_info.m_id ";
	$SQLStr .= "LEFT JOIN level AS level ON member.m_level = level.m_level WHERE is_licenced = '$lic' AND is_deleted='$del'";
	$res = db_query($SQLStr);
	// 使用 JOIN 语句将 member、member_info 及 level 三个 table 整
        // 合为一个 Table END

	$nums = db_num_rows($res);
?>
<?include("up.htm")?>
<script>

<!-------------- 打开查询会员的新窗口 BEGIN -------------->
function memberCheck()
{
	var Name = document.form1.username1.value;
	window.open("member_detail.php?name="+Name,"Check","width=640,height=480,status=0,scrollbars=0,resizable=1,menubar=0,toolbar=0,location=0");
}
<!---------------- 打开查询会员的新窗口 END --------------->

<!----- 将所有 checkbox 都勾选或取消的 Script 函数 BEGIN ----->
function select_all(formName, elementName, selectAllName)
{
	if(!document.forms[formName].elements[elementName])
		return;
	if(document.forms[formName].elements[selectAllName].checked)
		for(var i = 0; i < document.forms[formName].elements[elementName].length; i++)
			document.forms[formName].elements[elementName][i].checked = true;
	else
		for(var i = 0; i < document.forms[formName].elements[elementName].length; i++)
				document.forms[formName].elements[elementName][i].checked = false;
}
<!------ 将所有 checkbox 都勾选或取消的 Script 函数 END ------>

<!------ 利用按钮勾选所有 checkbox 的 Script 函数 BEGIN ------>
function select_button(formName, elementName)
{
		for(var i = 0; i < document.forms[formName].elements[elementName].length; i++)
			document.forms[formName].elements[elementName][i].checked = true;
		document.form1.submit();
}
<!------- 利用按钮勾选所有 checkbox 的 Script 函数 END ------->

</script>

<form name="form1" method="post" action="member_process.php">
    <table width="600" border="0" bgcolor="#8BC1CD" align="center">
        <tr> 
            <td height="30"> 
              <div align="center"><a href="manage.php?lic=1&del=0">会员管理首页</a></div>
            </td>
            <td>
               <div align="center"><a href="manage.php?lic=0&del=0">待审核会员</a></div>
            </td>
            <td>
               <div align="center"><a href="manage.php?lic=1&del=1">被冻结会员</a></div>
            </td>
        </tr>
    </table>
    <table width="600" border="0" align="center">
      <tr> 
        <td colspan="4" bgcolor="#0066CC"> 
          <div align="center"><font size="3" color="#FFFFFF">查询特定会员： 
            <input type="text" name="username1">
            <input type="button" name="submit3" value="送出" onclick="javascript:memberCheck();">
            </font> </div>
        </td>
      </tr>
      <tr> 
        <td width="42"><font size="3"></font></td>
        <td width="226"><font size="3"></font></td>
        <td width="110"><font size="3"></font></td>
        <td width="204"><font size="3"></font></td>
      </tr>
      <tr bgcolor="#0066CC"> 
        <td width="80"> 
          <div align="center"><font size="3" color="#FFFFFF"><input type="checkbox" name="all" onclick="select_all('form1','m_id[]',this.name);">全选</font></div>
        </td>
        <td width="188"> 
          <div align="center"><font size="3" color="#FFFFFF">账号姓名</font></div>
        </td>
        <td width="110"> 
          <div align="center"><font size="3" color="#FFFFFF">权限等级</font></div>
        </td>
        <td width="204"> 
          <div align="center"><font size="3" color="#FFFFFF">权限变动</font></div>
        </td>
      </tr>
<?
	if ($nums>0) // 若表内有会员信息
	{
	  for ($i=0;$i<$nums;$i++)
	  {
            // 判断目前行数来决定背景颜色 BEGIN
	    $row = db_fetch_array($res);
		if ($i%2 == 0)
 			echo"<tr bgcolor='#E3F0F4'>";
		else
 			echo"<tr>";
            // 判断目前行数来决定背景颜色 END

	    echo "<td width='80' align='center'><input type='checkbox' name='m_id[]' value='" . $row['m_id'] . "'></td>\n";
	    echo "<td width='188' align='center'><a href='member_detail.php?name=" . $row['m_username'] . "' target='_blank'>" . $row['m_username'] . "(" . $row['m_surname'] . $row['m_frontname'] . ")</a></td>\n";
	    echo "<td width='110'><select name='level[]'>";
	    echo "<option value='" . $row['m_level'] . "'>" . $row['levelname'] . "</option>";
    	    echo "<option value='1'>管理员</option>";
    	    echo "<option value='2'>版主</option>";
    	    echo "<option value='3'>版主助理</option>";
    	    echo "<option value='4'>高级会员</option>";
    	    echo "<option value='5'>付费会员</option>";
    	    echo "<option value='6'>一般会员</option>";
    	    echo "<option value='7'>新手</option>";
  	    echo "</select></td>";
	    echo "<td width='204' align='center'>";

            //按下更改级别按钮时会将所有的 checkbbox 勾选起来
            echo "<input type='button' name='submitlevel' value='更改级别' onClick=\"select_button('form1','m_id[]');\"></td></tr>";
	  }
	  // 利用 hidden 方法将会员列表的数目送给下一页
	  echo "<input type='hidden' name='nums' value='" . $nums ."'>";
	}

?>
      <tr> 
        <td align="center"> 
<?
	if ($lic==1&$del==0) 
	{
          echo "<input type='submit' name='submitprocess' value='冻结会员资格'>";

	  // 利用 hidden 方法将 del=1 参数送出
	  echo "<input type='hidden' name='del' value='1'>";
	}
	if ($lic==1&$del==1)
	{
          echo "<input type='submit' name='submitprocess' value='回复会员资格'>";

	  // 利用 hidden 方法将 del=0 参数送出
	  echo "<input type='hidden' name='del' value='0'>";
	}
	if ($lic==0)
	{
	  echo "<input type='submit' name='submitprocess' value='确认会员资格'>";

	  // 利用 hidden 方法将 lic=1 参数送出
	  echo "<input type='hidden' name='lic' value='1'>";
	}
?>
	</td>
     </tr>
    </table>
    <br>
  </div>
</form>
<?include("down.htm")?>