A Database Management Project to manage orders and bills at food courts using MySQL. There is no automated system in our institute (IIITDM Jabalpur) for placing your order online. The current scenario includes placing the order manually. To reduce the waiting time, this project aimed to create a centralized system where one can access the portal using institute's intranet and place the order online to avoid long queues. The portal is also supposed to be password protected to avoid any discrepancy regarding the billing amount.
There are signup and signin pages. The final page at the checkout (for bill calculation) will not work unless you have a database file. The same name should be passed as a parameter in the code where SQL queries are written. By looking at the SQL queries (PHP files), you could create your own database provided you keep the name of the columns same as the code (alternatively change the name at both the places).
-
Below is the snippet of the login/signup page:
-
Screenshot of home page having the option of choosing the place to order the food:
-
The user is re-directed to the webpage of the canteen he/she selected. The webpage of each canteen contains the menu and the users can easily place the order by selecting the quantity of different food items they want. Screenshots of some webpages:
Note: The project was specifically designed for our institute, thus it contains a total of six web-pages, one for each canteen. It can be customised as per your convenience. The files can be used as a template to create your own database project