0); // Repeat until a unique ID is found
return $EventID;
}
// Handle form submission for posting events
if (isset($_POST['submit'])) {
// Capture values from HTML form
$Location = $_POST['Location'];
$Description = $_POST['description'];
$Date = $_POST['date'];
$AdminID = $AccID;
// Generate a unique Event ID
$EventID = generateUniqueId($conn);
// Prepare SQL query
$sql = "INSERT INTO event (Event_ID, Admin_ID, Location, Description, Dates) VALUES ('$EventID', '$AdminID', '$Location', '$Description', '$Date')";
// Execute the query
$column = mysqli_query($conn, $sql) or die ("Error: " . mysqli_error($conn));
if ($column != 0) {
header('Location: postEvents.php');
exit();
}
}
// Handle event deletion
if (isset($_GET['delete'])) {
$eventIdToDelete = $_GET['delete'];
$deleteSql = "DELETE FROM event WHERE Event_ID = '$eventIdToDelete'";
mysqli_query($conn, $deleteSql) or die("Error: " . mysqli_error($conn));
header('Location: postEvents.php');
exit();
}
// Fetch event data
$sql = "SELECT * FROM event";
$data = mysqli_query($conn, $sql);
$events = [];
if (mysqli_num_rows($data) > 0) {
while ($row = mysqli_fetch_assoc($data)) {
$events[] = $row;
}
// Custom sort function to sort events by date
usort($events, function($a, $b) {
$dateA = strtotime($a['Dates']);
$dateB = strtotime($b['Dates']);
return $dateA - $dateB;
});
}
$uniqueEventID = generateUniqueId($conn);
mysqli_close($conn); // Data security purposes
?>
Event | UITM BAZAAR