Skip to content

WH1T3-E4GL3/Project-Taaza

Repository files navigation

Project-Taaza

Taaza is a full website project. It is a responsive restaurant website which provides online services related to a restaurant

Key Features

🍪 Good Template for a restaurant website
🍪 Main pages: Home, About, Services, Our Menu, Contact, Dashboard, Register/Login
🍪 Register/Login: Forgot password, Mail sending etc..
🍪 Main services website offer(modules): Food ordering (Add to cart --> checkout || Increase/decrease quantity), Table booking (Normal & vip || Book & View Bookings), Vip membership (For discount and more)
🍪 Bill printing functionality (PDF generation) [Discounted for vip & non discounted]
🍪 Email sending functionality (During registration, forgot password, delete order by admin like events)
🍪 Admin functionality (To manage users, orders feedbacks, enabling/disabling pages, giving message etc)

Typing SVG

Screenshot

Taaza

This is a web template that I have created and made available for private use. Please note the licensing terms before using this template.

License

This work is licensed under the Creative Commons Attribution-NonCommercial 4.0 International License.

Creative Commons License

Usage

You are free to download and use this template for personal projects, educational purposes, or for non-commercial use. However, any public or commercial use, including publishing, marketing, or using it in a commercial project, is not permitted without explicit permission.

Adaptations

If you choose to adapt this template for your own needs, you must share your adaptations under the same Creative Commons Attribution-NonCommercial 4.0 International License. This ensures that others can benefit from your modifications while respecting the original creator's intentions.

Please read the full license text at http://creativecommons.org/licenses/by-nc/4.0/ for more details.

How to run

Create a database, tables, and columns with following details using phpmyadmin (Detailed structure and query given below this box):

Database name: taaza_db
Table names: ⦿ admin
                 ↳colum names:  id, email, name, password, resettoken, resettokenexpire, enable_table_booking, enable_menu_page

             ⦿ admin_message
                 ↳colum names:  id, message, enable_meessage

             ⦿ contact
                ↳colum names:  id, email, timestamp 	

             ⦿ feedback
                 ↳colum names:  feedback_id, user_email, feedback_text, timestamp

             ⦿ lend_hand
                 ↳colum names:   id, name, email, amount, timestamp, show_detail 

             ⦿ menu_items
                 ↳colum names:    id, name, description, category, price, quantity, available, image_path 	
            
             ⦿ orders
                ↳colum names:  order_id ,name, email, address, item, quantity, total_price, timestamp 	

             ⦿ registered_users
                 ↳colum names: name, email, password, gender, state, district, verification_code, is_verified, resettoken, resettokenexpire, is_vip

             ⦿ table_booking_ground
                 ↳colum names: id, name, email, section, seat, date, time, payment 

             ⦿ table_booking_vip
                 ↳colum names:  id, name, email, section, seat, decor, date, time, payment 

Database Structure & creating queries [Table By Table]

    Database name: taaza_db

    -------------------------

    CREATE DATABASE taaza_db;

    == Table structure for table admin
    
    |------
    |Column|Type|Null|Default
    |------
    |id|int|No|
    |email|varchar(50)|No|
    |name|varchar(100)|No|
    |password|varchar(190)|No|
    |resettoken|varchar(190)|No|
    |resettokenexpire|date|Yes|NULL
    |enable_table_booking|tinyint|No|
    |enable_menu_page|tinyint|No|

-----------------------------------------------------

Create 'admin' table Query :

    CREATE TABLE admin (
    id INT NOT NULL,
    email VARCHAR(50) NOT NULL,
    name VARCHAR(100) NOT NULL,
    password VARCHAR(190) NOT NULL,
    resettoken VARCHAR(190) NOT NULL,
    resettokenexpire DATE DEFAULT NULL,
    enable_table_booking TINYINT NOT NULL,
    enable_menu_page TINYINT NOT NULL
);

    == Table structure for table admin_message
    
    |------
    |Column|Type|Null|Default
    |------
    |id|int|No|
    |message|varchar(5000)|No|
    |enable_meessage|tinyint|No|

-----------------------------------------------------

Create 'admin_message' table Query :

    CREATE TABLE admin_message (
    id INT NOT NULL,
    message VARCHAR(5000) NOT NULL,
    enable_message TINYINT NOT NULL
);

    == Table structure for table contact
    
    |------
    |Column|Type|Null|Default
    |------
    |id|int|No|
    |email|varchar(90)|No|
    |timestamp|timestamp|No|CURRENT_TIMESTAMP
    
-----------------------------------------------------

Create 'contact' table Query :

    CREATE TABLE contact (
    id INT NOT NULL,
    email VARCHAR(90) NOT NULL,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

    == Table structure for table feedback
    
    |------
    |Column|Type|Null|Default
    |------
    |feedback_id|int|No|
    |user_email|varchar(255)|No|
    |feedback_text|text|No|
    |timestamp|timestamp|Yes|CURRENT_TIMESTAMP

-----------------------------------------------------

Create 'feedback' table Query :

    CREATE TABLE feedback (
    feedback_id INT NOT NULL,
    user_email VARCHAR(255) NOT NULL,
    feedback_text TEXT NOT NULL,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

    == Table structure for table lend_hand
    
    |------
    |Column|Type|Null|Default
    |------
    |id|int|No|
    |name|varchar(50)|No|
    |email|varchar(90)|No|
    |amount|int|No|
    |timestamp|timestamp|No|
    |show_detail|tinyint|No|

-----------------------------------------------------

Create 'lend_hand' table Query :

    CREATE TABLE lend_hand (
    id INT NOT NULL,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(90) NOT NULL,
    amount INT NOT NULL,
    timestamp TIMESTAMP NOT NULL,
    show_detail TINYINT NOT NULL
);

== Table structure for table menu_items

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|name|varchar(255)|No|
|description|text|Yes|NULL
|category|varchar(50)|Yes|NULL
|price|decimal(10,2)|No|
|quantity|int|No|0
|available|tinyint(1)|No|1
|image_path|varchar(255)|Yes|NULL

---------------------------------------------------

CREATE TABLE menu_items (
    id int NOT NULL AUTO_INCREMENT,
    name varchar(255) NOT NULL,
    description text,
    category varchar(50),
    price decimal(10,2) NOT NULL,
    quantity int NOT NULL DEFAULT 0,
    available tinyint(1) NOT NULL DEFAULT 1,
    image_path varchar(255),
    PRIMARY KEY (id)
);

    == Table structure for table orders
    
    |------
    |Column|Type|Null|Default
    |------
    |order_id|int|No|
    |name|varchar(50)|No|
    |email|varchar(100)|No|
    |address|varchar(200)|No|
    |item|varchar(30)|No|
    |quantity|varchar(30)|No|
    |total_price|varchar(30)|No|
    |timestamp|timestamp|Yes|CURRENT_TIMESTAMP

-----------------------------------------------------

Create 'orders' table Query :

    CREATE TABLE orders (
    order_id INT NOT NULL,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    address VARCHAR(200) NOT NULL,
    item VARCHAR(30) NOT NULL,
    quantity VARCHAR(30) NOT NULL,
    total_price VARCHAR(30) NOT NULL,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

    == Table structure for table registered_users
    
    |------
    |Column|Type|Null|Default
    |------
    |name|varchar(30)|No|
    |email|varchar(30)|No|
    |password|varchar(100)|No|
    |gender|varchar(18)|No|
    |state|varchar(30)|No|
    |district|varchar(30)|No|
    |verification_code|varchar(225)|No|
    |is_verified|int|No|0
    |resettoken|varchar(255)|Yes|NULL
    |resettokenexpire|date|Yes|NULL
    |is_vip|tinyint|No|

-----------------------------------------------------

Create 'registered_users' table Query :

    CREATE TABLE registered_users (
    name VARCHAR(30) NOT NULL,
    email VARCHAR(30) NOT NULL,
    password VARCHAR(100) NOT NULL,
    gender VARCHAR(18) NOT NULL,
    state VARCHAR(30) NOT NULL,
    district VARCHAR(30) NOT NULL,
    verification_code VARCHAR(225) NOT NULL,
    is_verified INT NOT NULL DEFAULT 0,
    resettoken VARCHAR(255) DEFAULT NULL,
    resettokenexpire DATE DEFAULT NULL,
    is_vip TINYINT NOT NULL
);

    == Table structure for table table_booking_ground
    
    |------
    |Column|Type|Null|Default
    |------
    |id|int|No|
    |name|varchar(30)|No|
    |email|varchar(50)|No|
    |section|varchar(30)|No|
    |seat|varchar(30)|Yes|NULL
    |date|date|No|
    |time|varchar(50)|No|
    |payment|tinyint(1)|No|
    
-----------------------------------------------------

Create 'table_booking_ground' table Query :

    CREATE TABLE table_booking_ground (
    id INT NOT NULL,
    name VARCHAR(30) NOT NULL,
    email VARCHAR(50) NOT NULL,
    section VARCHAR(30) NOT NULL,
    seat VARCHAR(30) DEFAULT NULL,
    date DATE NOT NULL,
    time VARCHAR(50) NOT NULL,
    payment TINYINT NOT NULL
);

    == Table structure for table table_booking_vip
    
    |------
    |Column|Type|Null|Default
    |------
    |id|int|No|
    |name|varchar(30)|No|
    |email|varchar(30)|No|
    |section|varchar(30)|No|
    |seat|varchar(30)|No|
    |decor|varchar(50)|No|
    |date|date|No|
    |time|varchar(20)|No|
    |payment|tinyint(1)|No|
    
-----------------------------------------------------

Create 'table_booking_vip' table Query :

    CREATE TABLE table_booking_vip (
    id INT NOT NULL,
    name VARCHAR(30) NOT NULL,
    email VARCHAR(30) NOT NULL,
    section VARCHAR(30) NOT NULL,
    seat VARCHAR(30) NOT NULL,
    decor VARCHAR(50) NOT NULL,
    date DATE NOT NULL,
    time VARCHAR(20) NOT NULL,
    payment TINYINT NOT NULL
);

Technologies Used

mysql

Don't just copy, hit the star also😊

Taaza - The website for restaurant.

This include front end design and backend code for a restaurant based website

This pack comes under Creative Commons Attribution-NonCommercial license (CC BY-NC).

~Work by Sethu Satheesh

©Sethu Reach me at Instagram

About

Taaza is a full stack website project. It is a responsive restaurant website which also provides online services related to a restaurant.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published