prepare("SELECT p.*, b.booking_id as booking_no, b.package_id, pk.name as package_name FROM payments p JOIN bookings b ON p.booking_id = b.id JOIN packages pk ON b.package_id = pk.id WHERE p.customer_id = ? ORDER BY p.created_at DESC");
$stmt->bind_param("i", $_SESSION['customer_id']); $stmt->execute();
$payments = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
define('PAGE_TITLE', 'My Payments');
include 'dashboard-header.php'; ?>
My Payments
| Booking | Amount | Type | Date | Status | Receipt |
|---|
| () | |
| |
|
' : '-' ?> |