Zerry’s Corner - Restaurant Management System

A database-driven restaurant management system designed to handle orders, menu updates, and customer feedback efficiently. Built with PHP, MySQL, HTML, CSS, and JavaScript, it provides seamless restaurant operations with real-time tracking and authentication.

🚀 Features

• 📌 Order Management – Tracks customer orders with timestamps and statuses.
• 📌 Dynamic Menu – Allows easy menu updates and categorization.
• 📌 Customer Feedback – Stores reviews for service improvement.
• 📌 Authentication System – Enables secure customer logins.
• 📌 Data Insights – SQL queries for analyzing order trends and popular items.

🛠 Tech Stack

• Frontend: HTML, CSS, JavaScript
• Backend: PHP, MySQL

📂 Database Structure

The system consists of five key tables:

1. Customers – Stores user details.
2. Menu – Holds available food items.
3. Orders – Tracks placed orders.
4. Order_Items – Links menu items to orders.
5. Feedback – Records customer reviews.

📌 Setup Instructions

1. Clone the repository:

   git clone https://github.com/yourusername/zerrys-corner.git

2. Import the database (zerrys_corner.sql) into MySQL.
3. Configure database connection in config.php.
4. Run the project on a local server (XAMPP/LAMP).

👨‍💻 Developed By

• Shehryar Zubair Khan
• Zehra Jabeen Mirza