prepare("SELECT i.*, b.booking_id as booking_no, p.name as package_name FROM invoices i JOIN bookings b ON i.booking_id = b.id JOIN packages p ON b.package_id = p.id WHERE i.customer_id = ? ORDER BY i.created_at DESC");
$stmt->bind_param("i", $_SESSION['customer_id']); $stmt->execute();
$invoices = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
define('PAGE_TITLE', 'My Invoices');
include 'dashboard-header.php'; ?>
My Invoices
| Invoice No | Booking | Date | Total | Paid | Balance | Status | Action |
|---|
| () |
| | |
| |
|