Railway Enquiry System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Railway Enquiry System

Railway Enquiry System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Trains,Timetable,Stations,Seats Availability,Routes. Admin user can manage all the operations of Seats Availability,Routes,Trains,Fare,Timetable and their details. Admin can create different type of reports of Trains,Timetable,Stations,Seats Availability,Routes according to their choise and filters. You can Download PHP and MySQL Project Railway Enquiry System with source code and database from this site. We also provide Project Report of Railway Enquiry System.

Functionalities and their descriptions of Railway Enquiry System are as follows:

  • You can search records on various criterias. Such as Trains, Stations, Seats Availability, Routes
  • Create, read, update and delete (CRUD) application has been implemented on Trains,Timetable,Stations,Seats Availability,Routes
  • Keep the track logs of Timetable, Fare, Seats Availability ect
  • Advance search has been implemented on Timetable,Fare, Seats Availability
  • You can see all the details of the Trains, Stations, Fare, Seats Availability
  • All the modules Fare, Seats Availability, Timetable,Routes, Trains are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Seats Availability.
  • All the Timetable,Fare, Seats Availability modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Trains data.

Modules of Railway Enquiry System and their descriptions:

  • Trains Module : Manage all the operations of Trains
  • Timetable Module : Manage all the operations of Timetable
  • Fare Module : Manage all the operations of Fare
  • Stations Module : Manage all the operations of Stations
  • Seats Availability Module : Manage all the operations of Seats Availability
  • Routes Module : Manage all the operations of Routes

Classes and their methods of Railway Enquiry System:

  • Trains Methods : addTrains(), editTrains(), deleteTrains(), updateTrains(), saveTrains(), searchTrains()
  • Timetable Methods : addTimetable(), editTimetable(), deleteTimetable(), updateTimetable(), saveTimetable(), searchTimetable()
  • Fare Methods : addFare(), editFare(), deleteFare(), updateFare(), saveFare(), searchFare()
  • Stations Methods : addStations(), editStations(), deleteStations(), updateStations(), saveStations(), searchStations()
  • Seats Availability Methods : addSeats Availability(), editSeats Availability(), deleteSeats Availability(), updateSeats Availability(), saveSeats Availability(), searchSeats Availability()
  • Routes Methods : addRoutes(), editRoutes(), deleteRoutes(), updateRoutes(), saveRoutes(), searchRoutes()

Database tables and attributes of the Railway Enquiry System:

  • Trains Entity : Attributes of Trains are train_id, train_name, train_number, train_seat_number, train_ticket, train_type, train_description
  • Timetable Entity : Attributes of Timetable are timetable_id, timetable_name, timetable_type, timetable_description timetable_t
  • Fare Entity : Attributes of Fare are fare_id, fare_ticket_id, fare_title, fare_type, fare_description
  • Stations Entity : Attributes of Stations are station_id, station_name, station_type, station_description
  • Seats Availability Entity : Attributes of Seats Availability are seat_id, seat_train_id, seat_customer_id, seat_number, seat_type, seat_description
  • Routes Entity : Attributes of Routes are train_route_id, train_route_name, train_route_type, train_route_description

Database definition of Railway Enquiry System:

  • The details of Trains is store into the Trains tables respective with all tables
  • Each entity (Routes, Fare, Seats Availability, Timetable, Trains) contains primary key and unique keys.
  • The entity Fare, Seats Availability has binded with Trains, Timetable entities with foreign key
  • There is one-to-one and one-to-many relationships available between Seats Availability, Stations, Routes, Trains
  • All the entities Trains, Seats Availability, Fare, Routes are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Railway Enquiry System tables for fast query execution.

Super admin functionality of Railway Enquiry System:

  • Admin can add, edit, delete and view the records of Trains, Seats Availability, Fare, Routes
  • Admin can manage all the details of Timetable, Fare, Stations, Seats Availability
  • Admin can also generate reports of Trains, Timetable, Fare, Stations
  • Admin can search the details of Trains, Seats Availability, Fare, Routes
  • Admin can apply different level of filters on report of Trains, Fare, Routes
  • Admin can tracks the detailed information of Seats Availability, Routes, Trains, Timetable

Report of Railway Enquiry System:

  • Generates the report on Fare,Stations,Trains,Timetable,Seats Availability,Routes,
  • Stations,Seats Availability,Routes has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Stations,Seats Availability,Routes
  • Excel Sheet report has also been integrated for Timetable,Stations,Routes
  • You can create the CSV reports for Trains,Seats Availability,Fare

Limitation of Railway Enquiry System

  • Run time report generation is not available in Railway Enquiry System.
  • We have not implemented the dynamic report for Trains,Stations,Seats Availability,Timetable,Fare,Routes
  • This project Railway Enquiry System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Trains, Stations, Routes cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Railway Enquiry System

  • We have added all the validations for input value on the modules Trains,Timetable,Fare
  • Stations,Seats Availability,Routes can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Trains,Fare,Routes
  • CSRF token has also been implemented on Stations,Timetable,Trains, Seats Availability,Routes
  • All the Trains,Stations,Seats Availability,Timetable,Fare,Routes has integrated with captcha for spam protections
  • Access level validation has been implemented on Routes,Seats Availability,Stations
  • Number and character validation has also been implemented on Fare,Seats Availability,Trains

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database