Canteen Management System

A reason to build

Traditional school canteens can depend on manual ordering, cash handling, and disconnected records. This project explored how a simple web application could organize food purchases, maintain customer balances, and give administrators better control over daily operations.

What I worked on

Developed a full-stack canteen management application using PHP, MySQL, HTML, CSS, and JavaScript. Implemented customer-facing ordering functionality, session-based login flows, administrative features for managing menus and accounts, balance top-ups, checkout processing, and order receipts.

How the pieces fit

1. Built separate customer and administrator interfaces for different operational needs.
2. Used PHP sessions to manage authenticated access to customer and administrative functionality.
3. Connected the application to a MySQL database for storing users, account balances, orders, and order items.
4. Implemented menu management functionality for administrators.
5. Developed a cart checkout workflow that calculates order totals and checks available customer balances.
6. Implemented a prepaid account system with administrator-managed balance top-ups.
7. Stored purchase records and individual order items for receipt generation.

The detail that matters

Chose a traditional PHP and MySQL architecture to build a complete server-rendered application without introducing a separate frontend framework or API service. Used prepaid account balances to simplify the ordering workflow for a school canteen environment.

Where it stands

Completed a Grade 12 academic project demonstrating customer ordering, administrative management, prepaid balances, and order processing. Published the source code on GitHub, with a deployment URL listed in the repository.

Gained practical experience connecting frontend interfaces with server-side PHP logic and relational databases. The project helped build an understanding of sessions, CRUD operations, order processing, and the importance of data consistency and security in applications that manage account balances.