product_related.php

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

<?
	// 取出此产品的类别 BEGIN
	$SQLStr = "SELECT c_id FROM product WHERE p_id='$p_id'";
	$res = db_query($SQLStr);
	$row = db_fetch_array($res);
	// 取出此产品的类别 END

	// 将 c_id 参数指定为此一产品的类别
	$c_id = $row['c_id'];
	
	// 取出 product 及 class JOIN 过后的数据 BEGIN
	$SQLStr = "SELECT product.*, class.* FROM product AS product ";
	$SQLStr .= "LEFT JOIN class AS class ON product.c_id = class.c_id WHERE product.c_id='$c_id'";
	$res_all = db_query($SQLStr);
	// 取出 product 及 class JOIN 过后的数据 END
?>

          <table width="100%" border="1">
            <tr>
              <td>其他产品</td>
            </tr>
<?
	$num_all = db_num_rows($res_all);
	for ($i=0;$i<$num_all;$i++)
	{
		$row_all = db_fetch_array($res_all);
		if ($row_all['p_id'] != $p_id)
		{
		  echo "<tr><td><a href='product_show.php?p_id=" 
                        . $row_all['p_id'] . "'>" . $row_all['p_name'] 
                        .  " - ￥" . $row_all['p_price'] . "</a></td></tr>";
		}
	}
?>

              <td></td>
            </tr>
          </table>