query($sql);
// Check if there are any pono values available
if ($result->num_rows > 0) {
// Display the form to select an pono
?>
query($sql);
// Display the sup_invhead data for the selected invoice
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
?>
No PO:
Supplier Reg No:
CF No:
Job No:
Inv Date:
Inv Due Date:
Tax Amt:
Tot Amt:
Tot Pay:
Invoice Details
Code
Detail
Amount
Tax
Tax Amount
data_seek(0);
while ($row = $result->fetch_assoc()) {
?>
>
query($sql);
// Check for errors
if (!$result) {
echo '';
exit;
}
// Insert data into sup_invdet table
$sql = "DELETE FROM sup_invdet WHERE pono = '$pono'";
$result = $conn->query($sql);
// Check if the data was successfully inserted into both tables
if ($result) {
echo '';
header("Refresh:0");
exit();
} else {
echo "Error: " . $sql . " " . $conn->error;
}
}
if (isset($_POST['print'])) {
// Get the selected pono
$pono = $_POST['pono'];
// Redirect to the print.php file, passing the pono as a parameter in the URL
header("Location: TCPDF/examples/purchase_order.php?pono='$pono'");
exit;
}
// Include footer file
include 'footer.php';
?>