Online DJ Booking Management System Using PHP and MySQL

• Admin login and logout
• Admin dashboard with users, DJs, bookings, revenue, reports, and recent activity
• DJ category CRUD management
• Add DJ category
• Edit DJ category
• Delete DJ category
• Activate/deactivate DJ category
• DJ profile CRUD management
• Add DJ profile
• Edit DJ details
• Delete DJ profile
• Upload DJ image
• Manage DJ pricing
• Manage DJ specialization
• Manage DJ experience
• Manage DJ availability status
• Service package CRUD management
• Add DJ service package
• Edit package price, duration, and description
• Delete package
• Activate/deactivate package
• DJ availability management
• Block unavailable DJ date and time slots
• Edit availability records
• Delete availability records
• Booking management
• View all customer bookings
• Search and filter bookings
• Approve booking requests
• Reject booking requests
• Confirm bookings
• Mark bookings as completed
• Cancel bookings
• Print booking details
• Payment management
• View payment records
• Verify payment submissions
• Update payment status
• Track advance and remaining payment
• User management
• View registered users
• Activate/deactivate users
• Delete users
• Enquiry management
• View user enquiries
• Reply to enquiries
• Mark enquiries as resolved
• Feedback and review moderation
• Approve reviews
• Hide reviews
• Delete inappropriate feedback
• Contact message management
• View contact form submissions
• Mark messages as read/resolved
• Delete contact messages
• Website content management
• Manage site name, tagline, about content, contact info, hero text, and booking terms
• Banner CRUD management
• FAQ CRUD management
• Booking report generation
• Payment report generation
• Revenue report generation
• Print reports
• Admin profile update
• Admin password change

• User registration
• User login and logout
• User dashboard with booking statistics and quick actions
• Browse DJs
• Search DJs by name or specialization
• Filter DJs by category
• Filter DJs by price range
• Filter DJs by availability
• Sort DJ listings
• View DJ profile details
• View DJ experience and specialization
• View DJ packages
• View approved DJ reviews
• Book a DJ
• Select service package
• Enter event type
• Enter event date and time
• Enter venue details
• Enter guest count
• Add special instructions
• Real-time DJ availability check using AJAX
• Submit booking request
• View active bookings
• Search and filter bookings by status
• View booking details
• View booking timeline
• Cancel pending booking
• Print booking confirmation
• View booking history
• Rebook completed/cancelled events
• Submit payment details
• View payment summary
• Print payment receipt
• Submit feedback and rating for completed bookings
• View own feedback status
• Submit enquiries
• View enquiry history
• View admin replies
• Contact support
• Profile update
• Change password

• Complete online DJ booking management system source code
• Suitable for final year project, major project, and minor project
• Project report content can be prepared from included modules
• Public Website, User Panel, and Admin Panel
• Booking status flow: Pending → Approved → Confirmed → Completed
• Extra booking statuses: Rejected, Cancelled
• Payment status flow: Pending → Partial → Paid
• DJ availability checking through AJAX
• Currency formatting in Indian Rupees ₹
• DJ image upload support
• Flash success/error messages
• Reusable UI components
• Client-side and server-side validation
• PDO prepared statements
• Password hashing using password_hash() and password_verify()
• Session-based authentication
• Protected user and admin routes
• Input sanitization using htmlspecialchars
• Users can access only their own bookings, payments, and feedback
• Admin route protection using requireAdmin()
• File upload restrictions for DJ images
• Seed data with admin, users, DJ categories, DJs, packages, bookings, payments, enquiries, reviews, FAQs, banners, and website settings
• Useful for viva, source code review, project report writing, and project demonstration

• Copy the project folder into:

  C:\xampp\htdocs\online-dj-booking-system\

• Start Apache and MySQL from XAMPP.

• Import database file:

  database/database.sql

• Edit database configuration:

  config/db.php

• Set database details:

  define('DB_HOST', 'localhost');
  define('DB_NAME', 'dj_booking_system');
  define('DB_USER', 'root');
  define('DB_PASS', '');
  define('DB_CHARSET', 'utf8mb4');

• Edit application URL if needed:

  config/constants.php

• Set:

  define('APP_URL', 'http://localhost/online-dj-booking-system');

• Ensure DJ upload folder exists and is writable:

  assets/uploads/djs/

• Open application:

  http://localhost/online-dj-booking-system/

Admin Account

• Email: [email protected]
• Password: Admin@123
• Login: Open login.php and select Admin toggle

Sample User Account

• Email: [email protected]
• Password: User@123