Moupanee Cakery is a web-based bakery management system designed to simplify the process of browsing, ordering, and managing bakery products online. The system allows customers to create accounts, explore available products, add items to their wishlist or shopping cart, and place orders conveniently.
An administrative panel is also included to enable efficient management of products, customer orders, registered users, and customer inquiries.
This project was developed as part of the Database Management Systems (DBMS) Lab course to demonstrate the practical application of database concepts in a real-world business scenario.
- User registration and login system
- Browse bakery products
- View detailed product information
- Add products to wishlist
- Add products to shopping cart
- Place orders through the checkout system
- View order history
- Search for products
- Contact the bakery through the contact form
- Secure logout functionality
- Admin dashboard
- Manage products (Add, Update, Delete)
- Manage customer orders
- View registered users
- Review customer messages and inquiries
- Monitor website activities
- HTML5
- CSS3
- JavaScript
- PHP
- MySQL
- XAMPP / WAMP
The system uses MySQL to store and manage application data efficiently.
usersproductscartwishlistordersmessage
The SQL file required to create the database is included in the repository:
shop_db.sql
DBMSLabFinalProject/
│
├── css/ # Stylesheets
├── images/ # Website images
├── js/ # JavaScript files
├── uploaded_img/ # Uploaded product images
│
├── config.php # Database connection
├── home.php # Homepage
├── login.php # User login
├── register.php # User registration
├── logout.php # Logout functionality
├── shop.php # Product listing page
├── view_page.php # Product details page
├── wishlist.php # Wishlist management
├── cart.php # Shopping cart
├── checkout.php # Order placement
├── orders.php # User orders
├── search_page.php # Product search
├── contact.php # Contact page
├── about.php # About page
│
├── admin_page.php # Admin dashboard
├── admin_products.php # Product management
├── admin_update_product.php # Update products
├── admin_orders.php # Order management
├── admin_users.php # User management
├── admin_contacts.php # Customer inquiries
├── admin_header.php # Admin navigation
│
├── header.php # User header
├── footer.php # Footer section
└── shop_db.sql # Database file
git clone https://github.com/Mehtabwho/DBMSLabFinalProject.gitCopy the project folder into your web server directory.
For XAMPP:
xampp/htdocs/
- Open phpMyAdmin
- Create a database named:
shop_db
- Import the provided SQL file:
shop_db.sql
Open config.php and update the database credentials if necessary.
Example:
$conn = mysqli_connect('localhost', 'root', '', 'shop_db');Start Apache and MySQL using XAMPP.
Open your browser and visit:
http://localhost/DBMSLabFinalProject/home.php
- To design and implement a relational database system.
- To develop a dynamic web application using PHP and MySQL.
- To apply CRUD operations in a real-world scenario.
- To understand user authentication and session management.
- To integrate frontend and backend technologies effectively.
- Database normalization
- Primary and foreign keys
- SQL queries
- Data insertion, updating, and deletion
- Session management
- Relational database design
- Data retrieval and filtering
- Online payment gateway integration
- Email notifications for order confirmation
- Product reviews and ratings
- Inventory management system
- Sales reports and analytics dashboard
- Password encryption and enhanced security measures
- Responsive design improvements
Course: Database Management Systems Lab
Project Title: Moupanee Cakery - Online Bakery Management System
Purpose: Academic project developed to demonstrate practical implementation of database concepts using PHP and MySQL.
This project was developed for educational purposes only. It may be used and modified for learning and academic activities.
© 2024 Sweet Delights. All Rights Reserved.