Local Train Ticketing System

An online ticketing system for local trains. Passengers choose the source and destination station, journey type and class, pay online and receive a digital ticket.

Users register and log in; the admin has a separate login with full control. Each module is a set of pages that add, view, update and delete records. Data is stored in MySQL tables linked by primary and foreign keys. The admin dashboard shows reports and statistics, and users get confirmations by email or SMS where required.

It follows a three-tier architecture: the browser shows the user interface, the server-side code handles logic and validation, and the MySQL database stores records. Requests travel over HTTP and responses are rendered as HTML or JSON.

All queries use prepared statements with bound parameters, so user input is never joined into the SQL text. Inputs are also validated on the server.

We followed an iterative (incremental) model: requirements and a basic design first, then modules built and tested one by one, with the guide's feedback after each review. It suits a project where requirements become clearer as we build.

Unit testing of each module, integration testing of the complete flow and system testing with real inputs. Test cases with expected and actual results are listed in the report, including invalid inputs.

The current version is tested on a limited dataset or number of users. Future work includes deploying on the cloud, adding more features or languages, improving accuracy with more data and building a mobile version.