manage.php

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

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

	// 取出所有产品的数据 BEGIN
	$SQLStr = "SELECT * FROM product";
	$res = db_query($SQLStr);
	// 取出所有产品的数据 END
?>

<script>

<!------ 增加查询产品窗口的 Script 语句 BEGIN ------>
function productCheck()
{
var Name = document.form1.p_name.value;
window.open("product_detail.php?p_id="+Name,"Check","width=785,height=570,status=0,scrollbars=0,resizable=1,menubar=0,toolbar=0,location=0");
}
<!------- 增加查询产品窗口的 Script 语句 END ------->

<!--- 将画面中的 checkbox 全部勾选/取消的 Script 语句 BEGIN --->
function select_all(formName, elementName, selectAllName)
{
	if(!document.forms[formName].elements[elementName])
		return;
	if(document.forms[formName].elements[selectAllName].checked)
	{	
		if(document.forms[formName].elements[elementName].length == '')
  			document.forms[formName].elements[elementName].checked = true;
		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 ---->

</script>

<form name="form1" method="post" action="product_process.php">

<?
	include("up.htm"); // 载入功能栏
?>
  <table width="720" border="1" align="center" cellspacing="0" cellpadding="0" bordercolor="#99CCFF">
    <tr> 
      <td align="center">
<?
	if($res) // 若产品表内有数据
	{
		if(!isset($stop_num)) // 判断目前的开始及结束的笔数
			$stop_num = 10;
		if(!isset($start_num))
			$start_num = 0;
		if(db_num_rows($res) > 0)
		{
			// 将笔数导入页面, 并抓取表中的结果列 BEGIN
			$pages = ceil(db_num_rows($res) / $stop_num) - 1;
			$start_num = ($_GET['start_num'] > $pages)? 0:$_GET['start_num'];
			if(db_num_rows($res) >= ($start_num * $stop_num))
				@db_data_seek($res, $start_num * $stop_num);
			else
				@db_data_seek($res, 0);
			// 将笔数导入页面, 并抓取表中的结果列 END
		}
	}
?>
             <!-------- 选择页次 -------->
             到第<select name="sel1" onChange="location.href='<?php echo $PHP_SELF; ?>?start_num='+(this.value-1)+'&stop_num=<?php echo $stop_num; ?>'">
<?
	for($i = 0;$i < $pages+1;$i++)
		echo "<option value='" . ($i+1) . "'" . (($start_num == $i)?' selected':'') . ">" . ($i+1) . "</option>\n";
?>
              </select>页, 每页显示
              <!------ 选择呈现笔数 ------>
              <select name="sel2" onChange="location.href='<?php echo $PHP_SELF; ?>?start_num=<?php echo $start_num; ?>&stop_num='+this.value+''">
<?
	for($i = 0;$i < 5;$i++) // 将笔数定义为五种选择
	{
		$tmp_stop = ($i+1)*10;
		echo "<option value='" . $tmp_stop . "'" . (($stop_num == $tmp_stop)?' selected':'') . ">" . $tmp_stop . "</option>\n";
	}
?>
              </select>笔, 共<?php echo db_num_rows($res); ?>笔产品信息&nbsp;&nbsp;
      </td>
      <td bgcolor="#FFFFCC" align="right">产品查询： 
          <input type="text" name="p_name" size="20">

            <!------ 调用打开查询窗口的 Script 语句 ------>
            <input type="button" name="submit3" value="送出" onClick="javascript:productCheck();">
          </font>
      </td>
    </tr>
  </table>
  <table width="720" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#99CCFF">
    <tr> 
      <td> 
        <table width="720" border="0" align="center" bordercolor="#99CCFF">
          <tr> 
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">全选 </font>

              <!------ 调用全选/取消 checkbox 的 Script 语句 ------>
              <input type="checkbox" name="all" onClick="select_all('form1','p_id[]',this.name);">

            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">是否上架</font>
            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">是否推荐</font>
            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">序号</font>
            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">名称</font>
            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">售价</font>
            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">成本</font>
            </td>
              <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">已销售</font>
            </td>          
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#0000FF">库存</font>
            </td>
            <td bgcolor="#99CCFF" align="center"> 
              <font color="#CC0000">热门度</font>
            </td>
          </tr>
<? 
	if (db_num_rows($res)>0) // 判断是否有从数据库读到数据
	{
		$num = db_num_rows($res);
		for ($i=0;$i<$stop_num;$i++)
		{
			$row = db_fetch_array($res);
		if(!$row)
			break;

			// 将偶数列的背景颜色设为灰色, 以方便阅读 BEGIN
			if ($i%2 == 0)
				echo "<tr bgcolor='#DDDDDD'>";
			else
				echo "<tr>";
			// 将偶数列的背景颜色设为灰色, 以方便阅读 END

			echo "<td align='center'><input type='checkbox' name='p_id[]' value='$row[p_id]'></td>";
			echo "<td align='center'><select name='p_actival[]'>\n";

			// 处理产品的上下架状态 BEGIN
			if ($row['p_actival'] == 1) 
			{
                	  echo "<option value='1'>上架中</option>\n";
               		  echo "<option value='0'>产品下架</option>\n";
			}
			else
			{
                  	echo "<option value='0'>下架中</option>\n";
                  	echo "<option value='1'>产品上架</option>\n";
			}
			// 处理产品的上下架状态 END

                	echo "</select>";
			echo "<td align='center'><select name='p_commend[]'>\n";

			// 处理产品的推荐状态 BEGIN
			if ($row['p_commend'] == 1)
			{
                  	echo "<option value='1'>推荐</option>\n";
                  	echo "<option value='0'>不推荐</option>\n";
			}
			else
			{
                  	echo "<option value='0'>不推荐</option>\n";
                  	echo "<option value='1'>推荐</option>\n";
			}
			// 处理产品的推荐状态 END

                	echo "</select>";

			// 抓取表中其他数据并呈现 BEGIN
			echo "<td align='center'>" . $row['p_id'] . "</td>\n";
			echo "<td align='center'><a href='product_detail.php?p_id=" . $row[p_id] . "'>" . $row['p_name'] . "</a></td>\n";
			echo "<td align='center'>" . $row['p_price'] . "</td>\n";
			echo "<td align='center'>" . $row['p_cost'] . "</td>\n";
			echo "<td align='center'>" . $row['p_sell'] . "</td>\n";
			echo "<td align='center'>" . $row['p_numbers'] . "</td>\n";
			echo "<td align='center'>" . $row['p_hot'] . "</td>\n";
			// 抓取表中其他数据并呈现 END

			echo "</tr>";
		}
	}
?>
          <tr> 
            <td colspan="9" align="center">
                <input type="submit" name="del" value="删除项目">
                <input type="submit" name="upd" value="套用更改">
            </td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
  <center><br>
    <font color="#FF0000">(※某产品成本如有变动, 请将其以新的产品输入处理)</font>
</form>
<? include("down.htm"); ?>