scale.php

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

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

 	// 利用 SQL 语句计算所有产品销售数量的总和 BEGIN
	$SQLSum = "SELECT SUM(p_sell) from product";
	$res = db_query($SQLSum);
	$row = db_fetch_array($res);
	$sellall = $row[0];
 	// 利用 SQL 语句计算所有产品销售数量的总和 END

	$SQLStr = "SELECT * FROM product";
	$res = db_query($SQLStr);

	if (db_num_rows($res)>0) // 若产品信息库中有数据
	{
	  $num = db_num_rows($res);
?>

<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" align='center'>
  <tr>
    <td>
	<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#99CCFF">
          <tr>
            <td align="center"><b><?=$subject?></b></td>
          </tr>
        </table>
    </td>
  </tr>
  <tr>
    <td>
      <table width="700" border="0" cellspacing="0" cellpadding="0" bgcolor="#DDDDDD">
        <tr> 
	  <td width='70' align='center'>产品编号</td>
          <td width='300' align='center'>产品名称</td>
          <td width='120' align='center'>产品销售比例</td>
          <td width='70' align='center'>售价</td>
          <td width='60' align='center'>售出数量</td>
        </tr>
      </table>
      <table width="700" border="0" cellspacing="0" cellpadding="0">
<?
	$num = db_num_rows($res);

	// 处理每一笔产品信息的比例尺呈现 BEGIN
	for ($i=0;$i<$num;$i++)
	{
		$row = db_fetch_array($res);

		// 计算产品销售比例
		$per = floor(($row['p_sell']/$sellall)*100) . "%";
		echo "<tr>";
		echo "<td width='70'>" . $row['p_id'] . "</td>";
		echo "<td width='300'>" . $row['p_name'] . "</td>";

		// 以图形呈现产品销售比例
		echo "<td width='120'><img src='images/bar1.gif' height='10' width='" . $per*2 ."'> $per </td>";

		echo "<td width='70' align='right'>NT$ " . $row['p_price'] . "</td>";
		echo "<td width='60' align='right'>" . $row['p_sell'] . "</td>";
		echo "</tr>";
	}
	// 处理每一笔产品信息的比例尺呈现 END

	echo "<tr><td colspan='5'><hr height='2'></td></tr>";
	echo "<tr><td colspan='4' align='right'>总销售数量：</td>";
	echo "<td align='center'>" . $sellall . "</td></tr>";
?>
      </table>
    </td>
  </tr>
</table>
<?
	}
?>