| Products | Quantity | Price |
";
// get order details info
$dbQuerya = "SELECT * FROM order_Products where op_Order='".$_SESSION['active_order']."'";
$resulta = mysqli_query($sConn, $dbQuerya);
while($rowa = mysqli_fetch_array($resulta))
{
extract($rowa);
// get product info
$dbQuery = "SELECT * FROM products where prod_Id='$op_Product'";
$result = mysqli_query($sConn, $dbQuery);
while($row = mysqli_fetch_array($result))
{
extract($row);
if ($op_Color) { $colorvar="Color: $op_Color"; }
if ($op_Size) { $sizevar="Size: $op_Size"; }
$prodresults .="| $prod_Name $colorvar $sizevar |
| \$$prod_Price |
";
$price_var=($prod_Price*$op_Quant);
$price_arr[]=$price_var;
$ship_var=($prod_Shipping*$op_Quant);
$ship_arr[]=$ship_var;
unset($colorvar);
unset($sizevar);
}
}
// GET TOTAL
if (isset($price_arr)) {
$shipvar=array_sum($ship_arr);
$totalvar=array_sum($price_arr)+$shipvar;
} else { $totalvar = "0.00"; }
$prodresults .="
|
| Shipping: \$".number_format($shipvar,2,'.',',')." |
| Total: \$".number_format($totalvar,2,'.',',')." |
";
$prodresults .="
";
include('storehead.inc'); ?>
