Online Restaurant Management System

Database Management Systems Project - Bachelor in CSE

Created by: - Mohammed Jawwadul Islam and Sayeda Muntaha Ferdous

Linkedin of Jawwad

Facebook of Muntaha

Date of Completion: - Spring 2021 Trimester

Tools used:

  1) Front-end: HTML, CSS, Boostrap, Javascript
  2) Back-end: PHP PDO
  3) Database: MySQL

Installation Details

  After downloading project: - 
  1)Install PHPMAILER by running : - composer require phpmailer/phpmailer (in project folder) (Refer to github link below in Credits)
  2)Install PHP dotenv by running: - composer require vlucas/phpdotenv (in project folder) (Refer to github link below in Credits)
  3)Create account in [Mailtrap](https://mailtrap.io/) and get your account credentials from there
  4)Set up the database as well as tables - see online_db.sql
  5)Register a user and then change user_role to Admin in order to view Admin Privileges
  6)For Payment Gateway --> SSLCOMMERZ was used (Largest payment gateway in Bangladesh) (Refer to github link below in Credits). Payment Gateway has credentials.    
  7)Look for .env.example files to see what credentials to set up, and then create .env files in those directories. 
  8)All major PHP codes are in (includes folder) -> functions.php

API's and Composer packages: -

  phpmailer package and mailtrap API - smtp fake testing server
  PHP dotenv package - protecting credentials online (creating .env file)

Credits

1) Admin Panel (Boostrap template) from Start Boostrap

Start Bootstrap was created by and is maintained by David Miller

2) PHPMailer and MailTrap

PHPMailer resources are provided by SmartMessages

• https://github.com/PHPMailer/PHPMailer

3) PHP dotenv

PHP dotenv was created by Vance Lucas and Graham Campbell

• https://github.com/vlucas/phpdotenv

5) SSLCOMMERZ payment gateway.

• https://github.com/sslcommerz

6) Images taken from Unsplash

Project video link - Youtube

Screenshots

Project documentation

Project Documentation - Group 3, Sec C.docx