Online Railway Reservation System Final Year PHP Project

• Admin login for this final year project
• Admin dashboard with users, trains, upcoming trains, bookings, confirmed, and cancelled counts
• Release train with train number, name, journey date, AC coaches, and Sleeper coaches
• Duplicate train release prevention for same train number and date
• View all released trains
• Search released trains by train number or train name
• Filter released trains by All, Upcoming, and Past
• View train details with AC/Sleeper occupancy stats
• Edit train name and coach counts
• Prevent coach count reduction below already booked seats
• Delete train release only if no bookings exist
• Train status lookup by train number and journey date
• User list with booking counts
• Create passenger user accounts
• View passenger profile and booking history
• Edit passenger name, email, and address
• Reset passenger password
• Delete passenger users
• View all bookings with search and status filters
• View booking details with PNR, user, train, date, coach, seats, and passengers
• Admin booking cancellation
• Admin profile update
• Admin password change

• Passenger registration and login
• User dashboard with total, confirmed, and cancelled booking counts
• Recent bookings list
• PNR quick lookup
• Browse available released trains
• Search trains by train number or train name
• View AC and Sleeper availability bars
• Book ticket for selected train
• Select coach type: AC or Sleeper
• Choose 1 to 6 seats per booking
• Add passenger details dynamically
• Automatic sequential seat assignment
• PNR generation after successful booking
• Booking history with search and status filter
• View ticket by PNR
• Print-friendly ticket view
• Cancel confirmed future bookings
• Profile update with name, email, and address
• Change password

• Public landing page included in this final year project
• Public train search
• Public upcoming train list
• Public PNR ticket lookup
• Separate user and admin sessions
• PDO prepared statements
• CSRF token protection on POST forms
• Bcrypt password hashing
• HTML output escaping
• HTTP-only session cookies
• Database stored procedure sp_release_train
• Database stored procedure sp_train_status
• Database trigger trg_bookings_before_insert
• Database-level seat availability validation
• AC coach default: 54 seats per coach
• Sleeper coach default: 72 seats per coach
• Booking statuses: Confirmed and Cancelled
• Coach types: AC and SL/Sleeper
• Bootstrap 5 responsive interface
• Optional seed data with sample PNRs
• Suitable for final year project demo, viva, source code review, and report preparation

• Copy the final year project folder into your web root:

  C:\xampp\htdocs\erail

• Start Apache and MySQL.

• Import database:

  mysql -u root -p < database/database.sql

• Optional: import extra test data:

  mysql -u root -p erail < database/seed.sql

• Edit database config:

  config/config.php

• Set:

  define('DB_HOST', 'localhost');
  define('DB_NAME', 'erail');
  define('DB_USER', 'root');
  define('DB_PASS', '');
  define('APP_URL', 'http://localhost/erail');

• Open:

  http://localhost/erail/

• User login:

  http://localhost/erail/auth/login.php

• Admin login:

  http://localhost/erail/auth/admin_login.php

Admin

• Username: admin
• Password: admin123

Users
All use password: user123

user