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);
?>
|
|
$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 "";
echo "| " . $row['p_id'] . " | ";
echo "" . $row['p_name'] . " | ";
// 以圖形呈現產品銷售比例
echo " $per | ";
echo "NT$ " . $row['p_price'] . " | ";
echo "" . $row['p_sell'] . " | ";
echo " ";
}
// 處理每一筆產品資料的比例尺呈現 END
echo "
| ";
echo "| 總銷售數量: | ";
echo "" . $sellall . " | ";
?>
|
}
?>