club-system/events.php at main · 2024645296-pixel/club-system · 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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<?php
session_start();
include 'includes/db.php';

if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

$role = $_SESSION['role'];

$search = "";

if (isset($_GET['search'])) {
    $search = $_GET['search'];

    $events = mysqli_query($conn, "
    SELECT * FROM events
    WHERE event_name LIKE '%$search%'
    OR location LIKE '%$search%'
    OR status LIKE '%$search%'
    ORDER BY event_id DESC
    ");
} else {
    $events = mysqli_query($conn, "SELECT * FROM events ORDER BY event_id DESC");
}
?>

<!DOCTYPE html>
<html>

<head>
    <title>Events</title>
    <link rel="stylesheet" href="assets/css/style.css?v=3">
</head>

<body>

    <?php include 'includes/sidebar.php'; ?>

    <div class="main">

        <h1>Club Events</h1>
        <p>View approved club events and register for available programs.</p>

        <br>

        <div class="card">

            <h2>Event List</h2>
            <br>

            <form method="GET">
                <input type="text" name="search" placeholder="Search event, location or status..."
                    value="<?php echo $search; ?>">
                <button type="submit">Search</button>
                <a href="events.php">
                    <button type="button">Reset</button>
                </a>
            </form>

            <br>

            <table>

                <tr>
                    <th>No</th>
                    <th>Event Name</th>
                    <th>Date</th>
                    <th>Time</th>
                    <th>Location</th>
                    <th>Budget</th>
                    <th>Status</th>

                    <?php if ($role == 'Student') { ?>
                        <th>Action</th>
                    <?php } ?>

                    <th>View</th>
                </tr>

                <?php
                $no = 1;

                if (mysqli_num_rows($events) > 0) {
                    while ($row = mysqli_fetch_assoc($events)) {
                        ?>

                        <tr>
                            <td><?php echo $no++; ?></td>
                            <td><?php echo $row['event_name']; ?></td>
                            <td><?php echo $row['event_date']; ?></td>
                            <td><?php echo $row['event_time']; ?></td>
                            <td><?php echo $row['location']; ?></td>
                            <td>RM <?php echo $row['budget']; ?></td>

                            <td>
                                <span class="badge badge-<?php echo strtolower($row['status']); ?>">
                                    <?php echo $row['status']; ?>
                                </span>
                            </td>

                            <?php if ($role == 'Student') { ?>
                                <td>
                                    <a href="register_event.php?id=<?php echo $row['event_id']; ?>">Register</a>
                                </td>
                            <?php } ?>

                            <td>
                                <a href="event_detail.php?id=<?php echo $row['event_id']; ?>">View</a>
                            </td>
                        </tr>

                        <?php
                    }
                } else {
                    ?>

                    <tr>
                        <td colspan="9">No event found.</td>
                    </tr>

                <?php } ?>

            </table>

        </div>

    </div>

</body>

</html>