:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/crm/quatation/**
:: Editing File: delete_vendor_invoice.php
<?php include 'db.php'; include_once("session.php"); // ✅ Validate the request if (!isset($_GET['id']) || !is_numeric($_GET['id'])) { $_SESSION['error'] = "Invalid request."; header("Location: vendor_invoice_list.php"); exit; } $invoice_id = (int)$_GET['id']; mysqli_begin_transaction($conn); try { // 🔹 If you have ON DELETE CASCADE set for related tables, // deleting from vendor_invoice will also remove child rows automatically. $sql = "DELETE FROM vendor_invoice WHERE id = $invoice_id"; if (!mysqli_query($conn, $sql)) { throw new Exception("Delete failed: " . mysqli_error($conn)); } mysqli_commit($conn); $_SESSION['success'] = "Vendor invoice deleted successfully."; header("Location: vendor_invoice_list.php"); exit; } catch (Exception $e) { mysqli_rollback($conn); $_SESSION['error'] = "Error deleting vendor invoice: " . $e->getMessage(); header("Location: vendor_invoice_list.php"); exit; } ?>