Cricket Match Ticket Booking System PHP & MySQL

The Cricket Match Ticket Booking System is a webbased application that allows users to book tickets for cricket matches online. It includes:
Built with PHP, MySQL, JavaScript, Bootstrap 5, and TCPDF, this system is ideal for college projects or smallscale event management.
✨ Key Features
👥 User Features
User Registration & Login
Secure password hashing (bcrypt)
Profile management (name, address, DOB)
Password reset functionality
Match Ticket Booking
View upcoming matches
Select ticket type (Normal/VIP/VVIP)
Choose quantity and calculate total price
Realtime seat availability check
User Dashboard
View booking history
Print/download tickets as PDF
Edit profile information
Ticket Management
Unique booking IDs for each transaction
🛠️ Admin Features
Admin Authentication
Secure admin login
Session based access control
Match Management
Add/edit/delete matches
Set ticket prices and availability
Manage match dates and venues
User Management
View all registered users
Edit user details
Delete users (with confirmation)
Sales & Reporting
View all bookings
Filter by date range
Revenue analytics dashboard
Ticket Inventory
Track available tickets
Prevent overbooking
Update ticket counts
🖥️ Technical Stack
Frontend | HTML5, CSS3, Bootstrap 5, JavaScript |
Backend | PHP (Procedural) |
Database | MySQL |
PDF Generation | TCPDF Library |
Security | Password hashing, Prepared statements, Session management |
Server | XAMPP (Apache, MySQL) |
🚀 How to Run?
Setup XAMPP/WAMP
Import `cricket_tickets.sql` into PHPMyAdmin
Configure database in `includes/config.php`
Access the System
User Side: `http://localhost/cricketticketbooking/`
Admin Panel: `http://localhost/cricketticketbooking/admin/login.php`
(Default admin: `admin` / `12345678`)
🎯 Ideal For
✅ College PHP/MySQL projects
✅ Event management systems
✅ Sports club ticket booking
✅ Learning fullstack web development
Demo Video

Detailed Project Description

Cricket Match Ticket Booking System PHP & MySQL digitises the day-to-day records and workflows of an organisation so data is stored once, retrieved instantly and reported accurately.

How It Works
1. Role-based login separates admin, staff and end users.
2. Each module (records, bookings, transactions, reports) provides full CRUD operations with validation.
3. Data lives in a relational database with proper relationships between entities.
4. Reports and search views summarise the stored information.

Technology Roles
- Java
- PHP
- JavaScript
- MySQL

Implementation Steps
1. Define requirements and draw the ER / class diagram and screen flow.
2. Set up the environment (Java, PHP, JavaScript) and create the project skeleton.
3. Design the database schema / data model and seed it with sample data.
4. Implement the core modules with validation and role-based access where needed.
5. Build the user interface and connect it to the backend / data layer.
6. Test each module (unit + manual), fix edge cases and secure inputs (SQL injection, XSS, auth).
7. Prepare documentation, screenshots and a demo build.

Key Features
- Role-based access
- CRUD modules
- Search and filters
- Reports / export
- Validation and error handling

Expected Output
On completion the student will have a multi-user application with organised records and printable/exportable reports.

Deliverables
- Complete source code with comments
- Database schema / data model and screen flow
- Project report with screenshots and results
- Demonstration-ready build