| order ID |
' . $OrderID . ' |
| Customers Full Name |
' . $cForename . ' ' . $cSurname . ' |
| employees full name |
' . $sforename . $sSurname . ' |
| Price |
' . $price . ' |
| discounted |
' . $discount . ' |
| VAT |
' . $VAT . ' |
| placed on |
' . $Placed . ' |
| expected delivery date |
' . $Deliverydate . ' |
| House number |
' . $HouseNo . ' |
| Street Name |
' . $street . ' |
| City |
' . $city . ' |
| postcode |
' . $postC . ' |
| status |
' . $delStat . ' |
| Items on order |
| Product Name |
Quantity |
Price |
Discount |
VAT |
';
mysqli_close($link);
include "../Config/config.php";
$SQL = "SELECT ordered_stock.Order_ID, ordered_stock.Product_ID, products.Product_Name, ordered_stock.Quantity, ordered_stock.Price, ordered_stock.Discount, ordered_stock.VAT
FROM ordered_stock
LEFT JOIN products ON ordered_stock.Product_ID = products.Product_ID
WHERE ordered_stock.Order_ID = '" . $ID . "';";
//mysqli_stmt_bind_param($stmt, "s", $ID);
$stmt = mysqli_query($link, $SQL);
while ($row = mysqli_fetch_array($stmt)) {
$Table = $Table . '
| ' . $row["Product_Name"] . ' |
' . $row["Quantity"] . ' |
' . $row["Price"] . ' |
' . $row["Discount"] . ' |
' . $row["VAT"] . ' |
';
}
}
} else {
echo "something went wrong, try again later.";
}
}
$Table = $Table . "";
?>
Dashboard