query("SELECT p.*, b.booking_id as booking_no, cu.name as cname, cu.email as cemail FROM payments p JOIN bookings b ON p.booking_id=b.id JOIN customers cu ON p.customer_id=cu.id ORDER BY p.created_at DESC")->fetch_all(MYSQLI_ASSOC);
?>
Payments
| ID | Booking | Customer | Amount | Type | Method | Date | Status | Action |
|---|
| |
|
| |
| |
|
|