class_add.php

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

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

	if ($check == add) 
	{
		// 将类别增加至数据库中 BEGIN
		$SQLStr = "INSERT INTO class (c_id, c_name) VALUES('', '$c_name')";
		db_query($SQLStr);
		// 将类别增加至数据库中 END
	}

	// 取出所有类别 BEGIN	
	$SQLStr = "SELECT * FROM class"; 
	$res = db_query($SQLStr);
	// 取出所有类别 END
?>

<?
	include("up.htm"); // 外挂上方的功能栏
?>

<form name="form1" method="post" action="class_add.php?check=add">
  <table width="750" border="1" cellpadding="0" cellspacing="0" align="center" bordercolor="#0000FF">
    <tr> 
      <td bgcolor="#FFFFCC"> 
        <table width="400" border="0" align="center">
          <tr> 
            <td width="60%" bgcolor="#9933FF" align="center"> 
             <font color="#FFFFFF">增加列别</font>
            </td>
            <td width="25%" bgcolor="#9966FF">&nbsp;</td>
            <td width="10%" bgcolor="#9999FF">&nbsp;</td>
            <td width="3%" bgcolor="#9999FF">&nbsp;</td>
            <td width="2%" bgcolor="#99CCFF">&nbsp;</td>
          </tr>
        </table>
  <table width="750" border="1" cellspacing="0" cellpadding="0" bordercolor="#9999FF">
    <tr>
      <td>
        <table width="750" border="1" cellspacing="0" bgcolor="#FFFFFF">
          <tr> 
            <td bgcolor="#CCCCCC" align="center">现有类别</td>
          </tr>
<?
	// 取出所有类别名称并呈现于网页上 BEGIN
	$num = db_num_rows($res);
	for ($i=0;$i<$num;$i++)
	{
	$row = db_fetch_array($res);
	echo "<tr><td align='center'>" . $row['c_name'] . "</td></tr>";
	}
	// 取出所有类别名称并呈现于网页上 END
?>
          <tr> 
            <td bgcolor="#99CCFF" align="center">增加类别： 
                <input type="text" name="c_name">
                <input type="submit" name="Submit" value="增加">
            </td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
</table>
</form>
<? include("down.htm"); ?>