Event Management System Project In Php

Creating an Event Management System involves several components, including a MySQL database schema, file structure, layout design using Bootstrap 5, and complete PHP scripts for user authentication and management. Below is a comprehensive guide to help you set up your system.

Project Introduction

The Event Management System is a comprehensive web application designed to facilitate the planning, organization, and management of events. This platform allows event organizers to create and manage events, sell tickets, and track registrations efficiently. Attendees can register for events, provide feedback, and receive notifications about upcoming events. With features for managing agendas and vendor services, the system aims to enhance the overall event experience for both organizers and attendees.

Project Objectives

To develop a secure and user-friendly platform for managing events and attendee registrations.
To implement a comprehensive database schema that supports user management, event creation, ticket sales, and feedback collection.
To provide functionalities for managing event agendas and scheduling sessions with speakers.
To facilitate payment processing for ticket registrations and track payment statuses.
To ensure timely notifications for attendees regarding event updates and important information.
To create a responsive design that enhances user experience across various devices.

Project Modules

User Management: Handles user registration, authentication, and role assignments (admin, organizer, attendee, vendor).
Event Management: Allows organizers to create, update, and manage events, including details like date, location, and description.
Ticket Management: Manages ticket types, pricing, and availability for each event.
Registration Management: Facilitates attendee registrations for events, including ticket selection and payment processing.
Agenda Management: Manages event agendas, including session titles, speakers, and scheduling.
Feedback Collection: Allows attendees to provide ratings and comments on events to improve future experiences.
Notification System: Sends alerts and messages to users regarding important updates and event information.
Vendor Management: Manages vendor information, including contact details and service types for events.

1. MySQL Database Schema


CREATE DATABASE event_management_system;
USE event_management_system;
-- Table for users
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    role ENUM('admin', 'organizer', 'attendee', 'vendor') DEFAULT 'attendee',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Table for events
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    organizer_id INT NOT NULL,
    event_name VARCHAR(255) NOT NULL,
    event_date DATETIME NOT NULL,
    location VARCHAR(255) NOT NULL,
    description TEXT,
    category VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (organizer_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for tickets
CREATE TABLE tickets (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    ticket_type VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    availability INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE
);
-- Table for registrations
CREATE TABLE registrations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    attendee_id INT NOT NULL,
    ticket_id INT NOT NULL,
    registration_date DATETIME DEFAULT CURRENT_TIMESTAMP,
    payment_status ENUM('pending', 'completed', 'failed') DEFAULT 'pending',
    FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE,
    FOREIGN KEY (attendee_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (ticket_id) REFERENCES tickets(id) ON DELETE CASCADE
);
-- Table for agendas
CREATE TABLE agendas (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    session_title VARCHAR(255) NOT NULL,
    speaker VARCHAR(255),
    start_time DATETIME NOT NULL,
    end_time DATETIME NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE
);
-- Table for feedback
CREATE TABLE feedback (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    attendee_id INT NOT NULL,
    rating INT CHECK (rating >= 1 AND rating <= 5),
    comments TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE,
    FOREIGN KEY (attendee_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for notifications
CREATE TABLE notifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    message TEXT NOT NULL,
    is_read BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for vendors
CREATE TABLE vendors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    contact_info VARCHAR(255),
    service_type VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

2. File and Folder Structure


event_management_system/
│
├── config/
│   └── db.php
│
├── public/
│   ├── index.php
│   ├── login.php
│   ├── register.php
│   ├── dashboard.php
│   ├── events.php
│   ├── tickets.php
│   ├── registrations.php
│   ├── agendas.php
│   ├── feedback.php
│   ├── notifications.php
│   ├── vendors.php
│   └── admin_dashboard.php
│
├── includes/
│   ├── header.php
│   ├── footer.php
│   └── functions.php
│
├── assets/
│   ├── css/
│   │   └── styles.css
│   ├── js/
│   │   └── scripts.js
│   └── images/
│
└── vendor/
    └── (Bootstrap and other libraries)

3. Layout Based Design with Bootstrap 5

Header (includes/header.php)


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="assets/css/styles.css">
    <title>Event Management System</title>
</head>
<body>
    <div class="container">
        <header class="my-4">
            <h1>Event Management System</h1>
        </header>
        <nav class="navbar navbar-expand-lg navbar-light bg-light">
            <div class="container-fluid">
                <a class="navbar-brand" href="index.php">Home</a>
                <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="collapse navbar-collapse" id="navbarNav">
                    <ul class="navbar-nav">
                        <li class="nav-item">
                            <a class="nav-link" href="events.php">Events</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="tickets.php">Tickets</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="registrations.php">Registrations</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="agendas.php">Agendas</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="feedback.php">Feedback</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="notifications.php">Notifications</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="vendors.php">Vendors</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="login.php">Login</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="register.php">Register</a>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
        <main class="my-4">

Footer (includes/footer.php)


        </main>
        <footer class="text-center my-4">
            <p>© 2023 Event Management System. All rights reserved.</p>
        </footer>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

4. PHP Code for User Authentication

Registration (public/register.php)


<?php
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
    $role = $_POST['role'];
    $stmt = $conn->prepare("INSERT INTO users (username, email, password, role) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssss", $username, $email, $password, $role);
    $stmt->execute();
    $stmt->close();
    header("Location: login.php");
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="email" class="form-label">Email</label>
        <input type="email" class="form-control" id="email" name="email" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <div class="mb-3">
        <label for="role" class="form-label">Role</label>
        <select class="form-select" id="role" name="role">
            <option value="attendee">Attendee</option>
            <option value="organizer">Organizer</option>
            <option value="admin">Admin</option>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Register</button>
</form>
<?php require '../includes/footer.php'; ?>


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $password = $_POST['password'];
    $stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
    $stmt->bind_param("s", $username);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    if ($user && password_verify($password, $user['password'])) {
        $_SESSION['user_id'] = $user['id'];
        $_SESSION['role'] = $user['role'];
        header("Location: dashboard.php");
    } else {
        echo "Invalid credentials.";
    }
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Login</button>
</form>
<?php require '../includes/footer.php'; ?>

5. Additional PHP Scripts

Dashboard (public/dashboard.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
$user_id = $_SESSION['user_id'];
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>
<h2>Welcome, <?php echo $user['username']; ?></h2>
<p>Your role: <?php echo ucfirst($user['role']); ?></p>
<?php require '../includes/footer.php'; ?>

Event Management (public/events.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'organizer') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $event_name = $_POST['event_name'];
    $event_date = $_POST['event_date'];
    $location = $_POST['location'];
    $description = $_POST['description'];
    $category = $_POST['category'];
    $stmt = $conn->prepare("INSERT INTO events (organizer_id, event_name, event_date, location, description, category) VALUES (?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("isssss", $_SESSION['user_id'], $event_name, $event_date, $location, $description, $category);
    $stmt->execute();
    $stmt->close();
    header("Location: events.php");
}
?>
<h2>Create Event</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="event_name" class="form-label">Event Name</label>
        <input type="text" class="form-control" id="event_name" name="event_name" required>
    </div>
    <div class="mb-3">
        <label for="event_date" class="form-label">Event Date</label>
        <input type="datetime-local" class="form-control" id="event_date" name="event_date" required>
    </div>
    <div class="mb-3">
        <label for="location" class="form-label">Location</label>
        <input type="text" class="form-control" id="location" name="location" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" id="description" name="description" required></textarea>
    </div>
    <div class="mb-3">
        <label for="category" class="form-label">Category</label>
        <input type="text" class="form-control" id="category" name="category" required>
    </div>
    <button type="submit" class="btn btn-primary">Create Event</button>
</form>
 <h3>Existing Events</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event Name</th>
            <th>Date</th>
            <th>Location</th>
            <th>Description</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT * FROM events WHERE organizer_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($event = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $event['id']; ?></td>
            <td><?php echo $event['event_name']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($event['event_date'])); ?></td>
            <td><?php echo $event['location']; ?></td>
            <td><?php echo $event['description']; ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Ticket Management (public/tickets.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'organizer') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $event_id = $_POST['event_id'];
    $ticket_type = $_POST['ticket_type'];
    $price = $_POST['price'];
    $availability = $_POST['availability'];
    $stmt = $conn->prepare("INSERT INTO tickets (event_id, ticket_type, price, availability) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("isdi", $event_id, $ticket_type, $price, $availability);
    $stmt->execute();
    $stmt->close();
    header("Location: tickets.php");
}
?>
<h2>Create Ticket</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="event_id" class="form-label">Event</label>
        <select class="form-select" id="event_id" name="event_id" required>
            <?php
            $stmt = $conn->prepare("SELECT * FROM events WHERE organizer_id = ?");
            $stmt->bind_param("i", $_SESSION['user_id']);
            $stmt->execute();
            $result = $stmt->get_result();
            while ($event = $result->fetch_assoc()): ?>
            <option value="<?php echo $event['id']; ?>"><?php echo $event['event_name']; ?></option>
            <?php endwhile; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="ticket_type" class="form-label">Ticket Type</label>
        <input type="text" class="form-control" id="ticket_type" name="ticket_type" required>
    </div>
    <div class="mb-3">
        <label for="price" class="form-label">Price</label>
        <input type="number" class="form-control" id="price" name="price" required>
    </div>
    <div class="mb-3">
        <label for="availability" class="form-label">Availability</label>
        <input type="number" class="form-control" id="availability" name="availability" required>
    </div>
    <button type="submit" class="btn btn-primary">Create Ticket</button>
</form>
<h3>Existing Tickets</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Ticket Type</th>
            <th>Price</th>
            <th>Availability</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT t.*, e.event_name FROM tickets t JOIN events e ON t.event_id = e.id WHERE e.organizer_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($ticket = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $ticket['id']; ?></td>
            <td><?php echo $ticket['event_name']; ?></td>
            <td><?php echo $ticket['ticket_type']; ?></td>
            <td><?php echo $ticket['price']; ?></td>
            <td><?php echo $ticket['availability']; ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Registration Management (public/registrations.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $event_id = $_POST['event_id'];
    $ticket_id = $_POST['ticket_id'];
    $attendee_id = $_SESSION['user_id'];
    $stmt = $conn->prepare("INSERT INTO registrations (event_id, attendee_id, ticket_id) VALUES (?, ?, ?)");
    $stmt->bind_param("iii", $event_id, $attendee_id, $ticket_id);
    $stmt->execute();
    $stmt->close();
    header("Location: registrations.php");
}
?>
<h2>Register for Event</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="event_id" class="form-label">Event</label>
        <select class="form-select" id="event_id" name="event_id" required>
            <?php
            $stmt = $conn->prepare("SELECT * FROM events");
            $stmt->execute();
            $result = $stmt->get_result();
            while ($event = $result->fetch_assoc()): ?>
            <option value="<?php echo $event['id']; ?>"><?php echo $event['event_name']; ?></option>
            <?php endwhile; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="ticket_id" class="form-label">Ticket Type</label>
        <select class="form-select" id="ticket_id" name="ticket_id" required>
            <?php
            $stmt = $conn->prepare("SELECT * FROM tickets");
            $stmt->execute();
            $result = $stmt->get_result();
            while ($ticket = $result->fetch_assoc()): ?>
            <option value="<?php echo $ticket['id']; ?>"><?php echo $ticket['ticket_type']; ?></option>
            <?php endwhile; ?>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Register</button>
</form>
<h3>Your Registrations</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Ticket Type</th>
            <th>Registration Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT r.*, e.event_name, t.ticket_type FROM registrations r JOIN events e ON r.event_id = e.id JOIN tickets t ON r.ticket_id = t.id WHERE r.attendee_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($registration = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $registration['id']; ?></td>
            <td><?php echo $registration['event_name']; ?></td>
            <td><?php echo $registration['ticket_type']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($registration['registration_date'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Agenda Management (public/agendas.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'organizer') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $event_id = $_POST['event_id'];
    $session_title = $_POST['session_title'];
    $speaker = $_POST['speaker'];
    $start_time = $_POST['start_time'];
    $end_time = $_POST['end_time'];
    $stmt = $conn->prepare("INSERT INTO agendas (event_id, session_title, speaker, start_time, end_time) VALUES (?, ?, ?, ?, ?)");
    $stmt->bind_param("issss", $event_id, $session_title, $speaker, $start_time, $end_time);
    $stmt->execute();
    $stmt->close();
    header("Location: agendas.php");
}
?>
<h2>Create Agenda</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="event_id" class="form-label">Event</label>
        <select class="form-select" id ="event_id" name="event_id" required>
            <?php
            $stmt = $conn->prepare("SELECT * FROM events WHERE organizer_id = ?");
            $stmt->bind_param("i", $_SESSION['user_id']);
            $stmt->execute();
            $result = $stmt->get_result();
            while ($event = $result->fetch_assoc()): ?>
            <option value="<?php echo $event['id']; ?>"><?php echo $event['event_name']; ?></option>
            <?php endwhile; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="session_title" class="form-label">Session Title</label>
        <input type="text" class="form-control" id="session_title" name="session_title" required>
    </div>
    <div class="mb-3">
        <label for="speaker" class="form-label">Speaker</label>
        <input type="text" class="form-control" id="speaker" name="speaker" required>
    </div>
    <div class="mb-3">
        <label for="start_time" class="form-label">Start Time</label>
        <input type="datetime-local" class="form-control" id="start_time" name="start_time" required>
    </div>
    <div class="mb-3">
        <label for="end_time" class="form-label">End Time</label>
        <input type="datetime-local" class="form-control" id="end_time" name="end_time" required>
    </div>
    <button type="submit" class="btn btn-primary">Create Agenda</button>
</form>
<h3>Existing Agendas</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Session Title</th>
            <th>Speaker</th>
            <th>Start Time</th>
            <th>End Time</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT a.*, e.event_name FROM agendas a JOIN events e ON a.event_id = e.id WHERE e.organizer_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($agenda = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $agenda['id']; ?></td>
            <td><?php echo $agenda['event_name']; ?></td>
            <td><?php echo $agenda['session_title']; ?></td>
            <td><?php echo $agenda['speaker']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($agenda['start_time'])); ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($agenda['end_time'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Feedback Management (public/feedback.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $event_id = $_POST['event_id'];
    $rating = $_POST['rating'];
    $comments = $_POST['comments'];
    $attendee_id = $_SESSION['user_id'];
    $stmt = $conn->prepare("INSERT INTO feedback (event_id, attendee_id, rating, comments) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("iiis", $event_id, $attendee_id, $rating, $comments);
    $stmt->execute();
    $stmt->close();
    header("Location: feedback.php");
}
?>
<h2>Provide Feedback</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="event_id" class="form-label">Event</label>
        <select class="form-select" id="event_id" name="event_id" required>
            <?php
            $stmt = $conn->prepare("SELECT * FROM events");
            $stmt->execute();
            $result = $stmt->get_result();
            while ($event = $result->fetch_assoc()): ?>
            <option value="<?php echo $event['id']; ?>"><?php echo $event['event_name']; ?></option>
            <?php endwhile; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="rating" class="form-label">Rating</label>
        <select class="form-select" id="rating" name="rating" required>
            <option value="1">1</option>
            <option value="2">2</option>
            <option value="3">3</option>
            <option value="4">4</option>
            <option value="5">5</option>
        </select>
    </div>
    <div class="mb-3">
        <label for="comments" class="form-label">Comments</label>
        <textarea class="form-control" id="comments" name="comments"></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Submit Feedback</button>
</form>
<h3>Your Feedback</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Rating</th>
            <th>Comments</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT f.*, e.event_name FROM feedback f JOIN events e ON f.event_id = e.id WHERE f.attendee_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($feedback = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $feedback['id']; ?></td>
            <td><?php echo $feedback['event_name']; ?></td>
            <td><?php echo $feedback['rating']; ?></td>
            <td><?php echo $feedback['comments']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($feedback['created_at'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Notification Management (public/notifications.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $message = $_POST['message'];
    $user_id = $_SESSION['user_id'];
    $stmt = $conn->prepare("INSERT INTO notifications (user_id, message) VALUES (?, ?)");
    $stmt->bind_param("is", $user_id, $message);
    $stmt->execute();
    $stmt->close();
    header("Location: notifications.php");
}
?>
<h2>Send Notification</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="message" class="form-label">Message</label>
        <textarea class="form-control" id="message" name="message" required></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Send Notification</button>
</form>
<h3>Your Notifications</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Message</th>
            <th>Status</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT * FROM notifications WHERE user_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($notification = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $notification['id']; ?></td>
            <td><?php echo $notification['message']; ?></td>
            <td><?php echo $notification['is_read'] ? 'Read' : 'Unread'; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($notification['created_at'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Vendor Management (public/vendors.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $name = $_POST['name'];
    $contact_info = $_POST['contact_info'];
    $service_type = $_POST['service_type'];
    $stmt = $conn->prepare("INSERT INTO vendors (name, contact_info, service_type) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $name, $contact_info, $ service_type);
    $stmt->execute();
    $stmt->close();
    header("Location: vendors.php");
}
?>
<h2>Add Vendor</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="name" class="form-label">Vendor Name</label>
        <input type="text" class="form-control" id="name" name="name" required>
    </div>
    <div class="mb-3">
        <label for="contact_info" class="form-label">Contact Information</label>
        <input type="text" class="form-control" id="contact_info" name="contact_info" required>
    </div>
    <div class="mb-3">
        <label for="service_type" class="form-label">Service Type</label>
        <input type="text" class="form-control" id="service_type" name="service_type" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Vendor</button>
</form>
<h3>Existing Vendors</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Contact Info</th>
            <th>Service Type</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT * FROM vendors");
        $stmt->execute();
        $result = $stmt->get_result();
        while ($vendor = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $vendor['id']; ?></td>
            <td><?php echo $vendor['name']; ?></td>
            <td><?php echo $vendor['contact_info']; ?></td>
            <td><?php echo $vendor['service_type']; ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>