Event Management System Using PHP and MySQL

Eventra – Event Management System in PHP and MySQL is a full campus event booking platform that replaces messy registration sheets and double-booked seats with a single, transaction-safe system. Students discover events, reserve a seat with capacity enforced at the database level, and receive a scannable QR ticket, while administrators run everything — events, venues, users, bookings and reviews — from an analytics-driven dashboard. Built in plain PHP 8.1 with no framework, it stays fully readable for academic submission while covering enough real-world depth (offline QR generation, transaction-safe booking, role-based access) to hold up in a viva or a placement interview.

Key Features

• Event discovery with search by name, venue or keyword, plus filters for category, date range and price.
• Detailed event pages showing live seat availability, venue information and related event suggestions.
• One-click booking with seat capacity enforced safely at the database level to prevent overselling.
• Unique, printable QR tickets generated entirely offline, with admin-side verification.
• Booking management covering upcoming, attended and cancelled bookings, with cancellation before the event starts.
• Reviews and star ratings for events actually attended.
• Email booking and cancellation confirmations, logged locally when no mail server is present.
• Profile management for updating name, email, phone and password.
• Admin analytics dashboard with booking trends, category breakdowns, recent activity and a low-sales watchlist.
• Full event, venue, user and booking management with review moderation.
• Light and dark themes, full responsiveness, and accessibility support including keyboard navigation and ARIA labels.

Technology Stack

System Requirements

• PHP 8.1 or newer with pdo_mysql, gd and mbstring extensions
• MySQL 5.7+ or MariaDB 10.4+
• Apache web server (a standard XAMPP install has everything enabled by default)
• No Composer, Node.js or additional packages required

How It Works

A student registers and logs in through session-based authentication, then browses published events using category, date and price filters. Booking a seat runs inside a database transaction so the seat count stays accurate even under load, and a unique QR ticket is generated instantly for the student to print or show at the venue. Admins verify tickets through a QR verification link and manage every event, venue, user and booking from the dashboard, tracking activity through built-in analytics. After attending, students can leave a star rating and review, which admins can moderate.

Perfect For

This project suits BCA, MCA, B.Tech CS/IT, M.Tech and MBA final-year students who want a submission that goes well beyond basic CRUD. Two distinct roles with full create/read/update/delete operations, prepared statements, bcrypt password hashing, CSRF protection and transaction-safe booking give strong, defensible talking points for a viva — and the polished, responsive interface with light/dark themes makes it a genuinely resume-worthy portfolio piece.

Future Enhancements

The modular structure makes it straightforward to extend with online payment gateway integration for paid events, live QR scanning through a mobile check-in app, SMS/WhatsApp booking notifications, a waiting list with automatic seat allocation on cancellation, a separate organiser role for managing individual events, calendar export, downloadable PDF/Excel analytics reports, and multi-language support.

More Details & Full Documentation

For complete project details, screenshots, demo video and setup guide, visit the official project page.

🔗 View Full Project Details – UpdateGadh