SkyLane/view_data.php at main · amna-2/SkyLane · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
<?php
// Connect to the database
$connection = mysqli_connect('localhost', 'root', '', 'book_db');

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Fetch data from the database
$query = "SELECT * FROM book_form";
$result = mysqli_query($connection, $query);

if (!$result) {
    die("Query failed: " . mysqli_error($connection));
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Booking Receipts</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f9f9f9;
            margin: 0;
            padding: 0;
        }
        .container {
            width: 90%;
            max-width: 800px;
            margin: 20px auto;
        }
        .receipt {
            background-color: #fff;
            border: 1px solid #ddd;
            border-radius: 10px;
            padding: 20px;
            margin-bottom: 200px;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
        }
        .receipt h2 {
            margin: 0 0 10px;
            color: #333;
            font-size: 20px;
            border-bottom: 1px dashed #ccc;
            padding-bottom: 10px;
        }
        .receipt p {
            margin: 5px 0;
            color: #555;
            font-size: 16px;
        }
        .receipt p span {
            font-weight: bold;
            color: #000;
        }
    </style>
</head>
<body>
    <div class="container">
        <h1 style="text-align: center; color: #333;">Booking Receipts</h1>

        <?php
        // Loop through the results and display each record as a receipt
        if (mysqli_num_rows($result) > 0) {
            while ($row = mysqli_fetch_assoc($result)) {
                echo '<div class="receipt">';
                echo '<h2>Receipt ID: ' . $row['ID'] . '</h2>';
                echo '<p><span>Name:</span> ' . $row['Name'] . '</p>';
                echo '<p><span>Email:</span> ' . $row['Email'] . '</p>';
                echo '<p><span>Phone:</span> ' . $row['Phone'] . '</p>';
                echo '<p><span>Address:</span> ' . $row['Address'] . '</p>';
                echo '<p><span>Destination:</span> ' . $row['Location'] . '</p>';
                echo '<p><span>Guests:</span> ' . $row['Guests'] . '</p>';
                echo '<p><span>Arrival Date:</span> ' . $row['Arrivals'] . '</p>';
                echo '<p><span>Leaving Date:</span> ' . $row['Leaving'] . '</p>';
                echo '<p><span>Total Price:</span> $' . $row['price'] . '</p>';
                echo '</div>';
            }
        } else {
            echo '<p style="text-align: center; color: #888;">No bookings found.</p>';
        }
        ?>

    </div>
</body>
</html>

<?php
// Close the database connection
mysqli_close($connection);
?>