Skip to content

andrei-vasile-dev/PHP-MySQL-CRUD-Restaurant

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🍽️ Restaurant Presentation Website

Project built in PHP, HTML, and CSS (no frameworks) Includes functionalities for users and administrators and is connected to a MySQL database.


🧾 Description:

This is a restaurant presentation website created with PHP, HTML, and CSS, without using any frameworks. The site includes functionalities for both users and administrators and is connected to a MySQL database.

⚙️ Main Features

✅ User registration
✅ User authentication (standard user or admin mode)
✅ View menu
✅ Create / Edit / Delete Reviews (only for the logged-in user)
✅ Create / Edit / Delete Reservations

The administrator can:

  • Delete all reservations or reviews
  • Add new dishes to the menu

ℹ️ I did not provide the administrator with the ability to add or edit customer reviews - I believe it would not be ethical.

All these are managed through a simple and intuitive interface that allows performing the 4 basic database operations:

Create - Read - Update - Delete (CRUD)

🗄️ Database Structure (MySQL)

1️⃣ utilizatori (id_utilizator, nume, prenume, username, parola, email, admin)
2️⃣ meniu (id_preparat, nume_preparat, descriere, gramaj, pret, categorie)
3️⃣ recenzii (id_recenzie, id_utilizator, nota_recenzie, comentariu_recenzie, data_recenzie)
4️⃣ rezervari (id_rezervare, id_utilizator, numar_persoane, data, ora, loc, telefon, comentarii)

🧩 Installation and Setup

  1. Clone the repo (git clone https://github.com/andrei-vasile-dev/site-prezentare-restaurant.git)
  2. Configure the database (create a MySQL database, import the poianabucatelor.sql file, and update the config.php file with your MySQL access credentials)
  3. Run the site -> Place the project in a local server (e.g., XAMPP, WAMP, MAMP) and access http://localhost/project-name/ in your browser.

The result can be observed in the following 4 videos (please be patient as they might take a moment to load, but they will eventually appear):

Home and Menu Pages

Home and Menu Pages

Catering, Reservations, and Reviews Pages

Catering, Reservations, and Reviews Pages

Contact Page

Contact Page

Example of adding a reservation

Add reservation

About

Full-stack restaurant presentation website built with Vanilla PHP and MySQL. Features a custom reservation system and public user reviews. Developed entirely without frameworks.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors