product_stat.php

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

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

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

<br>
<table width="720" border="0" align="center">
  <tr>
    <td>
<table width="354" border="1" cellpadding="0" cellspacing="0" bordercolor="#669966">
  <tr>
    <td>
      <table width="353" border="0">
        <tr> 
          <td colspan="2" bgcolor="#99FF99">最受注目产品</td>
        </tr>
        <tr> 
          <td align="center">产品名称</td>
          <td align="center">点击数</td>
        </tr>
<?

	// 利用 p_hot 字段递减排序, 列出点击数最高的前三个产品 BEGIN
	$SQLStr = "SELECT * FROM product ORDER BY p_hot DESC";
	$res = db_query($SQLStr);
	for ($i=0; $i<3; $i++)
	{
	  $row = db_fetch_array($res);
          echo "<tr><td>" . ($i+1) . "、<a href=product_detail.php?p_id=" . $row['p_id'] . ">" . $row['p_name'] . "</td>";
          echo "<td align='center'>" . $row['p_hot'] . "</td></tr>";
	}
	// 利用 p_hot 字段递减排序, 列出点击数最高的前三个产品 END
?>
      </table>
    </td>
  </tr>
</table>
      <br>
<table width="354" border="1" cellpadding="0" cellspacing="0" bordercolor="#669966">
  <tr>
    <td>
      <table width="353" border="0">
        <tr> 
          <td colspan="2" bgcolor="#99FF99">最佳销售产品</td>
        </tr>
        <tr> 
          <td align="center">产品名称</td>
          <td align="center">销售量</td>
        </tr>
<?
	// 利用 p_sell 字段递减排序, 列出点击率最高的前三个产品 BEGIN
 	$SQLStr = "SELECT * FROM product ORDER BY p_sell DESC";
	$res = db_query($SQLStr);
	for ($i=0; $i<3; $i++)
	{
	  $row = db_fetch_array($res);
          echo "<tr><td>" . ($i+1) . "、<a href=product_detail.php?p_id=" . $row['p_id'] . ">" . $row['p_name'] . "</a></td>";
          echo "<td align='center'>" . $row['p_sell'] . "</td></tr>";
	}
	// 利用 p_sell 字段递减排序, 列出点击率最高的前三个产品 END
?>
      </table>
    </td>
  </tr>
</table>
      <br>
<table width="354" border="1" cellpadding="0" cellspacing="0" bordercolor="#669966">
  <tr>
    <td>
      <table width="353" border="0">
        <tr> 
          <td colspan="2" bgcolor="#99FF99">最高利润比产品</td>
        </tr>
        <tr> 
          <td align="center">产品名称</td>
          <td align="center">利润比</td>
        </tr>
<?
	// 将售价字段除以成本字段, 并递减排序之, 
        // 即可得知哪些产品的利润比最高 BEGIN
 	$SQLStr = "SELECT *, (p_price/p_cost) AS p_ben FROM product ORDER BY p_ben DESC";
	$res = db_query($SQLStr);
	for ($i=0; $i<3; $i++)
	{
	  $row = db_fetch_array($res);
          echo "<tr><td>" . ($i+1) . "、<a href=product_detail.php?p_id=" . $row['p_id'] . ">" . $row['p_name'] . "</a></td>";

          echo "<td align='center'>" . substr($row['p_ben'], 0, 5) . "</td></tr>";
	}
	// 将售价字段除以成本字段, 并递减排序之, 
        // 即可得知哪些产品的利润比最高 END
?>
      </table>
    </td>
  </tr>
</table>
    </td>
    <td>
<table width="354" border="1" cellpadding="0" cellspacing="0" bordercolor="#FF99FF">
  <tr>
    <td>
      <table width="353" border="0">
        <tr> 
          <td colspan="2" bgcolor="#FFCCCC">最不热门的产品</td>
        </tr>
        <tr> 
          <td align="center">产品名称</td>
          <td align="center">点击数</td>
        </tr>
<?
 	$SQLStr = "SELECT * FROM product ORDER BY p_hot ASC";
	$res = db_query($SQLStr);
	for ($i=0; $i<3; $i++)
	{
	  $row = db_fetch_array($res);
          echo "<tr><td>" . ($i+1) . "、<a href=product_detail.php?p_id=" . $row['p_id'] . ">" . $row['p_name'] . "</a></td>";
          echo "<td align='center'>" . $row['p_hot'] . "</td></tr>";
	}
?>
      </table>
    </td>
  </tr>
</table>
      <br>
<table width="354" border="1" cellpadding="0" cellspacing="0" bordercolor="#FF99FF">
  <tr>
    <td>
      <table width="353" border="0">
        <tr> 
          <td colspan="2" bgcolor="#FFCCCC">销售最差产品</td>
        </tr>
        <tr> 
          <td align="center">产品名称</td>
          <td align="center">销售量</td>
        </tr>
<?
	// 利用 p_hot 字段递增排序, 列出点击数最低的前三个产品 BEGIN
 	$SQLStr = "SELECT * FROM product ORDER BY p_sell ASC";
	$res = db_query($SQLStr);
	for ($i=0; $i<3; $i++)
	{
	  $row = db_fetch_array($res);
          echo "<tr><td>" . ($i+1) . "、<a href=product_detail.php?p_id=" . $row['p_id'] . ">" . $row['p_name'] . "</a></td>";
          echo "<td align='center'>" . $row['p_sell'] . "</td></tr>";
	}
	// 利用 p_hot 字段递增排序, 列出点击数最低的前三个产品 END
?>

      </table>
    </td>
  </tr>
</table>
      <br>
<table width="354" border="1" cellpadding="0" cellspacing="0" bordercolor="#FF99FF">
  <tr>
    <td>
      <table width="353" border="0">
        <tr> 
          <td colspan="2" bgcolor="#FFCCCC">利润比最低产品</td>
        </tr>
        <tr> 
          <td align="center">产品名称</td>
          <td align="center">利润比</td>
        </tr>
<?
	// 将售价字段除以成本字段, 并递减排序之, 
        // 即可得知哪些产品的利润比最低 BEGIN
 	$SQLStr = "SELECT *, (p_price/p_cost) AS p_ben FROM product ORDER BY p_ben ASC";
	$res = db_query($SQLStr);
	for ($i=0; $i<3; $i++)
	{
	  $row = db_fetch_array($res);
          echo "<tr><td>" . ($i+1) . "、<a href=product_detail.php?p_id=" . $row['p_id'] . ">" . $row['p_name'] . "</a></td>";

          echo "<td align='center'>" . substr($row['p_ben'], 0, 5) . "</td></tr>";
	}
	// 将售价字段除以成本字段, 并递减排序之, 
        // 即可得知哪些产品的利润比最低 END
?>
      </table>
    </td>
  </tr>
</table>
    </td>
  </tr>
</table>
<? include("down.htm"); ?>