eRail - An online railway reservation system Source Code ( Final Year)

Admin Features

• Admin Login:
• Secure login system for admins using username and password.
• Validations ensure correct credentials are provided.
• Train Management:
• Release Train: Admins can release trains for booking, specifying the train number, date, and number of AC and Sleeper coaches.
• View All Released Trains: Admins can view details of all released trains including train number, date of journey, and number of coaches.
• User Management:
• View All Users: Admins can see details of all registered users, including username, name, email, and address.
• Manage Users: Admins can manage user accounts, view, and delete user records.
• Booking Management:
• View All Bookings: Admins can view all bookings made by users, including details like PNR number, train number, date, and passenger information.
• Check Train Status: View the number of available and booked seats for a specific train and date of journey.
• Data Integrity and Validation:
• Admin actions are backed by triggers and stored procedures to ensure data integrity, such as preventing duplicate train releases and ensuring seat availability.

User Features

• User Registration and Login:
• Users can register with their details including username, email, and password.
• Secure login with username and password, with validation to ensure the correct credentials.
• Train and Ticket Management:
• Book Ticket: Users can book tickets by selecting a train, date, and coach type (AC or Sleeper).
• View Booking Status: Users can view the booking status of their tickets by entering their PNR number.
• Booking History:
• View Previous Bookings: Users can view details of their past bookings, including train number, date, and passenger details.
• View Released Trains:
• Users can view details of all trains released by the admin for booking.
• View Ticket:
• Users can view ticket details, such as PNR number, train number, date, and passenger information by entering a valid PNR number.

Other Features

• Stored Procedures for Business Logic:
• Various stored procedures ensure smooth functioning and validation, such as "check_email_registered" for email verification, "check_train_details" for train release validation, and "generate_pnr" for generating unique PNR numbers.
• Database Triggers:
• Triggers like "before_train_release" prevent the release of trains under invalid conditions, and "check_ticket_update" ensures that ticket details are not modified post-booking.
• Validation and Error Handling:
• Input validation for fields like email, username, and password during registration and login.
• Error handling ensures smooth operation, providing feedback to the user for actions such as booking tickets and viewing status.
• User-Friendly Interface:
• A responsive and intuitive interface using HTML, CSS, and Bootstrap for easy navigation and interaction.
• Visual cues and feedback for user actions like booking confirmation and error messages.
• Security Measures:
• Passwords are securely stored and validated during login.
• Sessions are managed effectively to ensure secure access to user and admin functionalities.

How to run eRail - An online railway reservation system

• Install XAMPP:
• Download and install XAMPP
• During installation, ensure that Apache and MySQL are selected.
• Copy folder named "railway-reservation-system" in the "htdocs" directory.
• Start Apache & MySQL Servers:
• Open the XAMPP Control Panel.
• Start the Apache and MySQL services by clicking the 'Start' buttons next to them.
• Set Up the Database:
• Open your browser and go to phpMyAdmin.
• Click on the 'Databases' tab and create a new database named "rdb".
• After creating the database, click on the "rdb" database on the left sidebar.
• Click on the 'Import' tab and select the "rdb.sql" file from the sql directory inside the project folder.
• Click 'Go' to import the database. This will create all the necessary tables and stored procedures.
• Run the Application: Open http://localhost/railway-reservation-system in your browser to start using the system.

Credentials

• Admin:
• Username: admin
• Password: admin
• User:
• Register as a new user or use existing credentials (if available in the database).

License

eRail - An online railway reservation system Source Code Tags