| Invoice ID |
' . $Invoice_ID . ' |
| Business Name |
' . $NAME . ' |
| Total Items |
' . $Total_Quantity . ' |
| Total billed |
' . $Billed_Amount . ' |
| Date Ordered |
' . $Date_Ordered . ' |
| Date Recived |
' . $Date_Recived . ' |
| Items on Invoice |
| Product ID |
Product Name |
Quantity |
Price |
Edit |
';
mysqli_close($link);
include "../Config/config.php";
$SQL = "SELECT recived_stock.Recived_Stock_ID, recived_stock.Invoice_ID, recived_stock.Product_ID, products.Product_Name, recived_stock.Quantity, recived_stock.Price
FROM recived_stock
LEFT JOIN products ON recived_stock.Product_ID = products.Product_ID
WHERE recived_stock.Invoice_ID = '" . $ID . "';";
//mysqli_stmt_bind_param($stmt, "s", $ID);
$stmt = mysqli_query($link, $SQL);
while ($row = mysqli_fetch_array($stmt)) {
$Table = $Table . '
| ' . $row["Product_ID"] . ' |
' . $row["Product_Name"] . ' |
' . $row["Quantity"] . ' |
' . $row["Price"] . ' |
Delete |
';
}
}
} else {
echo "something went wrong, try again later.";
}
}
$Table = $Table . "";
?>
Dashboard