Web-programming-Team-16/adminbooking.php at main · cerberus2078/Web-programming-Team-16 · 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
<?php
$title = "Admin booking Page";
include "adminheader.php";
?>

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/css/bootstrap.min.css"
    integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/js/bootstrap.min.js"
    integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM"
    crossorigin="anonymous"></script>
<style>
    .table {
        border-collapse: collapse;
        box-shadow: 0 10px 20px 0 rgba(0, 0, 0, 0.3);
        border-radius: 10px;
        margin: auto;
    }

    th,
    td {
        border: 1px solid #f2f2f2;
        padding: 8px 30px;
        text-align: center;
        color: grey;
    }

    th {
        text-transform: uppercase;
        font-weight: 500;
    }

    td {
        font-size: 13px;
    }

    h1 {
        text-align: center;
    }
</style>

<body>
    <h1>Customers Booking Information</h1>
    <div class="main">
        <div class="table-content">
            <table>
                <thead>
                    <tr>
                        <th>Events</th>
                        <th>First Name</th>
                        <th>Last Name</th>
                        <th>Email</th>
                        <th>Date</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    include "db.php";
                    $selectquery = "select * from bookinginfo";
                    $query = mysqli_query($conn, $selectquery);
                    while ($res = mysqli_fetch_array($query)) {
                        ?>
                        <tr>
                            <td>
                                <?php echo $res['events']; ?>
                            </td>
                            <td>
                                <?php echo $res['fname']; ?>
                            </td>
                            <td>
                                <?php echo $res['lname']; ?>
                            </td>
                            <td>
                                <?php echo $res['email']; ?>
                            </td>
                            <td>
                                <?php echo $res['date']; ?>
                            </td>
                        </tr>
                    <?php } ?>
                </tbody>
            </table>
        </div>
    </div>
</body>


<?php
include "adminfooter.php";
?>