---

Online Customized Gift Shopping Portal

---

Overview

This project is an online shopping portal for customized gifts designed to enhance the e-commerce experience for both customers and administrators. Unlike traditional shopping portals, users can customize gift products by uploading their own images or quotes to make the gifts personal and unique.

The portal provides a seamless experience for customers to browse, customize, and purchase gifts, while administrators can manage products, orders, and users efficiently. This project demonstrates a comprehensive application of Database Management System concepts including relational databases, triggers, views, and stored procedures.

Tech Stack Used

• Frontend: HTML, CSS, JavaScript, Bootstrap
• Backend: PHP
• Database: MySQL (managed via phpMyAdmin)
• Tools: MySQL Workbench / phpMyAdmin for database management

Methodology

The project is divided into two main interfaces: Customer and Administrator.

Customer Features

• Register and log in to the portal
• Browse and search for products
• Add products to the shopping cart
• Customize products with images or quotes
• Place orders and view order history

Administrator Features

• Add, delete, and manage products
• Update orders and track order status
• View and manage registered customers

Database Design

• Relational schema includes tables for Products, Customers, Orders, Order_Details, and Cart_Details
• ER Diagram represents relationships between products, customers, and orders
• Triggers and stored procedures ensure data consistency and encapsulation

Implementation

• HTML, CSS, JavaScript, and Bootstrap create dynamic and responsive web pages
• PHP dynamically fetches and updates database records for real-time interaction
• MySQL stores all product, customer, cart, and order information

Results / Insights

• Successfully implemented a fully functional online shopping portal with customizable gift products
• Customers can personalize their purchases, improving engagement and satisfaction
• Administrators can manage inventory, orders, and users efficiently
• Demonstrates practical integration of web development with database management, including CRUD operations, database triggers, and relational integrity
• Provides a foundation for future enhancements such as invoices, email notifications, search functionality, and online payment integration