query($sql);
// Check if there are any invno values available
if ($result->num_rows > 0) {
$query1 = "SELECT inccode, detail FROM inccode";
$result1 = mysqli_query($conn, $query1);
$sales_items = array();
while ($row1 = mysqli_fetch_assoc($result1)) {
$sales_items[] = $row1;
}
?>
query($sql);
// Display the invhead data for the selected invoice
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
?>
No Sebutharga:
Client Reg No:
CF No:
Inv Date:
Inv Due Date:
Tax Amt:
Tot Amt:
Tot Rec:
Invoice Details
Code
Detail
Amount
Tax
Tax Amount
EDIT
data_seek(0);
$i=0;
while ($row = $result->fetch_assoc()) {
$i++;
?>
>
×
Modal Header
query($sql);
// Check for errors
if (!$result) {
echo '';
exit;
}
// Insert data into invdet table
$sql = "DELETE FROM invdet WHERE invno = '$invno'";
$result = $conn->query($sql);
// Check if the data was successfully inserted into both tables
if ($result) {
echo '';
exit();
} else {
echo "Error: " . $sql . " " . $conn->error;
}
}
if (isset($_POST['print'])) {
// Get the selected invno
$invno = $_POST['invno'];
// Redirect to the print.php file, passing the invno as a parameter in the URL
header("Location: TCPDF/examples/invoice.php?invno='$invno'");
exit;
}
// Include footer file
include 'footer.php';
?>