Online Ticket Booking System Project In Php

Creating an Online Ticket Booking 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 Online Ticket Booking System is designed to provide a seamless platform for users to book tickets for various events. This system allows event organizers to create and manage events, while customers can browse events, select ticket types, and make bookings easily. With a robust MySQL database backend, the platform ensures secure data management and a user-friendly experience for all roles, including administrators, customers, and event organizers.

Project Objectives

To create a user-friendly interface for customers to browse and book tickets for events.
To enable event organizers to create, update, and manage their events effectively.
To support multiple ticket types for each event, allowing for flexible pricing and availability.
To implement a secure booking system that calculates total prices based on selected ticket types and quantities.
To allow users to leave reviews and ratings for events they have attended.
To provide promotional codes for discounts on ticket purchases.
To send notifications to users regarding their bookings, promotions, and event updates.

Project Modules

User Management: Handles user registration, login, and role-based access for admins, customers, and event organizers.
Event Management: Allows event organizers to create, edit, and delete events, including setting event details and categories.
Ticket Type Management: Enables the creation and management of different ticket types for each event, including pricing and availability.
Booking Management: Manages the booking process, including ticket selection, quantity, and total price calculation.
Review System: Collects and manages user reviews and ratings for events.
Promotion Management: Allows the creation and management of promotional codes for discounts on ticket purchases.
Notification System: Sends notifications to users regarding bookings, promotions, and event updates.
Admin Dashboard: Provides administrative tools for managing users, events, bookings, and overall platform performance.

1. MySQL Database Schema


CREATE DATABASE online_ticket_booking;
USE online_ticket_booking;
-- 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', 'customer', 'event_organizer') DEFAULT 'customer',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Table for events
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    organizer_id INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT NOT NULL,
    event_date DATETIME NOT NULL,
    location VARCHAR(255) NOT NULL,
    category VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (organizer_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for ticket types
CREATE TABLE ticket_types (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    type VARCHAR(50) 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 bookings
CREATE TABLE bookings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    event_id INT NOT NULL,
    ticket_type_id INT NOT NULL,
    quantity INT NOT NULL,
    total_price DECIMAL(10, 2) NOT NULL,
    booking_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE,
    FOREIGN KEY (ticket_type_id) REFERENCES ticket_types(id) ON DELETE CASCADE
);
-- Table for reviews
CREATE TABLE reviews (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    user_id INT NOT NULL,
    rating INT CHECK (rating >= 1 AND rating <= 5),
    comment TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for promotions
CREATE TABLE promotions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    code VARCHAR(50) NOT NULL UNIQUE,
    discount DECIMAL(5, 2) NOT NULL,
    start_date DATETIME NOT NULL,
    end_date DATETIME NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (event_id) REFERENCES events(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
);

2. File and Folder Structure


online_ticket_booking_system/
│
├── config/
│   └── db.php
│
├── public/
│   ├── index.php
│   ├── login.php
│   ├── register.php
│   ├── dashboard.php
│   ├── create_event.php
│   ├── edit_event.php
│   ├── view_event.php
│   ├── bookings.php
│   ├── reviews.php
│   ├── promotions.php
│   ├── notifications.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>Online Ticket Booking System</title>
</head>
<body>
    <div class="container">
        <header class="my-4">
            <h1>Online Ticket Booking 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="create_event.php">Create Event</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="bookings.php">My Bookings</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="reviews.php">My Reviews</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="promotions.php">Promotions</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="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 Online Ticket Booking 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="customer">Customer</option>
            <option value="event_organizer">Event 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'; ?>

Create Event (public/create_event.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'event_organizer') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $title = $_POST['title'];
    $description = $_POST['description'];
    $event_date = $_POST['event_date'];
    $location = $_POST['location'];
    $category = $_POST['category'];
    $organizer_id = $_SESSION['user_id'];
    $stmt = $conn->prepare("INSERT INTO events (organizer_id, title, description, event_date, location, category) VALUES (?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("isssss", $organizer_id, $title, $description, $event_date, $location, $category);
    $stmt->execute();
    $stmt->close();
    header("Location: dashboard.php");
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="title" class="form-label">Event Title</label>
        <input type="text" class="form-control" id="title" name="title" 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="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="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>
<?php require '../includes/footer.php'; ?>

View Event (public/view_event.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_GET['id'])) {
    header("Location: index.php");
    exit();
}
$event_id = $_GET['id'];
$stmt = $conn->prepare("SELECT * FROM events WHERE id = ?");
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
$event = $result->fetch_assoc ();
if (!$event) {
    echo "Event not found.";
    exit();
}
?>
<h2><?php echo $event['title']; ?></h2>
<p><?php echo $event['description']; ?></p>
<p><strong>Date:</strong> <?php echo $event['event_date']; ?></p>
<p><strong>Location:</strong> <?php echo $event['location']; ?></p>
<p><strong>Category:</strong> <?php echo $event['category']; ?></p>
<h3>Available Ticket Types</h3>
<?php
$stmt = $conn->prepare("SELECT * FROM ticket_types WHERE event_id = ?");
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
$ticket_types = $result->fetch_all(MYSQLI_ASSOC);
?>
<table class="table">
    <thead>
        <tr>
            <th>Type</th>
            <th>Price</th>
            <th>Availability</th>
            <th>Action</th>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($ticket_types as $ticket): ?>
        <tr>
            <td><?php echo $ticket['type']; ?></td>
            <td><?php echo $ticket['price']; ?></td>
            <td><?php echo $ticket['availability']; ?></td>
            <td>
                <a href="book_ticket.php?ticket_id=<?php echo $ticket['id']; ?>" class="btn btn-success">Book Now</a>
            </td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Bookings (public/bookings.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 bookings.*, events.title AS event_title, ticket_types.type AS ticket_type FROM bookings JOIN events ON bookings.event_id = events.id JOIN ticket_types ON bookings.ticket_type_id = ticket_types.id WHERE bookings.user_id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$bookings = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>My Bookings</h2>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Ticket Type</th>
            <th>Quantity</th>
            <th>Total Price</th>
            <th>Booking Date</th>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($bookings as $booking): ?>
        <tr>
            <td><?php echo $booking['id']; ?></td>
            <td><?php echo $booking['event_title']; ?></td>
            <td><?php echo $booking['ticket_type']; ?></td>
            <td><?php echo $booking['quantity']; ?></td>
            <td><?php echo $booking['total_price']; ?></td>
            <td><?php echo $booking['booking_date']; ?></td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Reviews (public/reviews.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 reviews.*, events.title AS event_title FROM reviews JOIN events ON reviews.event_id = events.id WHERE reviews.user_id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$reviews = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>My Reviews</h2>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Rating</th>
            <th>Comment</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($reviews as $review): ?>
        <tr>
            <td><?php echo $review['id']; ?></td>
            <td><?php echo $review['event_title']; ?></td>
            <td><?php echo $review['rating']; ?></td>
            <td><?php echo $review['comment']; ?></td>
            <td><?php echo $review['created_at']; ?></td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</ table>
</table>
<?php require '../includes/footer.php'; ?>

Promotions (public/promotions.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'event_organizer') {
    header("Location: login.php");
    exit();
}
$stmt = $conn->prepare("SELECT * FROM promotions");
$stmt->execute();
$result = $stmt->get_result();
$promotions = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Promotions</h2>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Event</th>
            <th>Code</th>
            <th>Discount</th>
            <th>Start Date</th>
            <th>End Date</th>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($promotions as $promotion): ?>
        <tr>
            <td><?php echo $promotion['id']; ?></td>
            <td><?php
                $event_stmt = $conn->prepare("SELECT title FROM events WHERE id = ?");
                $event_stmt->bind_param("i", $promotion['event_id']);
                $event_stmt->execute();
                $event_result = $event_stmt->get_result();
                $event = $event_result->fetch_assoc();
                echo $event['title'];
            ?></td>
            <td><?php echo $promotion['code']; ?></td>
            <td><?php echo $promotion['discount']; ?>%</td>
            <td><?php echo $promotion['start_date']; ?></td>
            <td><?php echo $promotion['end_date']; ?></td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Notifications (public/notifications.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
$user_id = $_SESSION['user_id'];
$stmt = $conn->prepare("SELECT * FROM notifications WHERE user_id = ? ORDER BY created_at DESC");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$notifications = $result->fetch_all(MYSQLI_ASSOC);
?>
<h3>Your Notifications</h3>
<ul class="list-group">
    <?php foreach ($notifications as $notification): ?>
    <li class="list-group-item <?php echo $notification['is_read'] ? 'list-group-item-secondary' : ''; ?>">
        <?php echo $notification['message']; ?>
        <small class="text-muted"><?php echo $notification['created_at']; ?></small>
    </li>
    <?php endforeach; ?>
</ul>
<?php require '../includes/footer.php'; ?>

Admin Dashboard (public/admin_dashboard.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();
}
$stmt = $conn->prepare("SELECT COUNT(*) AS user_count FROM users");
$stmt->execute();
$result = $stmt->get_result();
$user_count = $result->fetch_assoc()['user_count'];
$stmt = $conn->prepare("SELECT COUNT(*) AS event_count FROM events");
$stmt->execute();
$result = $stmt->get_result();
$event_count = $result->fetch_assoc()['event_count'];
$stmt = $conn->prepare("SELECT COUNT(*) AS booking_count FROM bookings");
$stmt->execute();
$result = $stmt->get_result();
$booking_count = $result->fetch_assoc()['booking_count'];
?>
<h2>Admin Dashboard</h2>
<p>Total Users: <?php echo $user_count; ?></p>
<p>Total Events: <?php echo $event_count; ?></p>
<p>Total Bookings: <?php echo $booking_count; ?></p>
<?php require '../includes/footer.php'; ?>