Online Eyewear Store using PHP and MySQL

The Online Eyewear Store Project utilizing PHP and MySQL is simply a complete and ready-to-run task that provides real-time e-commerce features for illustration merchandise management, cart, checkout, bid tracking, and admin control. It is 1 of the champion web improvement projects for students looking for an charismatic and master last twelvemonth project, The Online Eyewear Store utilizing PHP and MySQL task from PHPGurukul is an perfect engineering student last twelvemonth task that demonstrates real-world PHP MySQL web exertion development, featuring e-commerce website design, personification login system, shopping cart, admin panel, and bid management, helping students build applicable skills successful full-stack improvement while creating a complete online shopping strategy task suitable for world submissions and portfolio enhancement.

🔧 Technical Specifications

✅ Key Features

Admin Module

This module provides administrator-related functionalities. The administrator manages the full exertion and has afloat power complete the system.

Dashboard

In this section, the admin tin concisely view:

• Total products
• Total orders
• Total pending orders
• Total confirmed orders
• Total shipped orders
• Total delivered orders
• Total cancelled orders
• Total registered users
• Total revenue

Category Management

In this section, the admin tin negociate categories of eyewear products.

• Add a caller merchandise category
• Update class details
• Delete category

Product Management

In this section, the admin tin negociate eyewear products.

• Add caller products pinch image upload
• Update merchandise details
• Delete products
• Manage merchandise banal and inventory

Orders Management

In this section, the admin can:

• View complete bid details
• Update bid position (Pending, Confirmed, Shipped, Delivered, Cancelled)
• Restore banal automatically connected bid cancellation
• View cancellation reasons
• Auto update costs position connected delivery

Search Order

In this section, the admin tin hunt for a peculiar bid utilizing the invoice number aliases bid ID.

Reports

In this section, the admin tin position income and bid reports specified as:

• Between dates income report
• Monthly income report
• Yearly income report
• Revenue analysis

Registered Users

In this section, the admin tin position specifications of each registered users on pinch their bid history.

Admin Profile

The admin can:

• Update Manage Category
• Change password
• Recover password

User Module

This module provides user-related functionalities for customers visiting the website.

1. Eyewear Shop

In this section, users can:

• View disposable eyewear products
• Search products by sanction aliases brand
• Filter products by class and price
• View merchandise details

Guest users (not logged in) tin besides browse products.

2. My Account

In this section, users can:

• Register and login
• View and update profile
• Change password
• Logout from account

3. Cart

In this section, users can:

• Add eyewear products to cart
• Update merchandise quantity
• View cart summary
• Proceed to checkout

4. Wishlist

In this section, users can:

• Add products to wishlist
• View wishlist items
• Remove items from wishlist

5. My Orders

In this section, users can:

• View bid history
• Track bid status
• Cancel orders earlier delivery
• View cancellation status

6. Invoice Management

The personification has the installation to:

• View invoice
• Print invoice
• Download the invoice successful PDF format

Brief Information astir the Homepage

The homepage of the Online Eyewear Shopping System is accessible to some impermanent users and registered users.

• Guest users tin browse eyewear products and hunt products by sanction aliases brand.
• Guest users tin registry for a caller account.
• Registered users tin log successful to entree the cart, wishlist, orders, and floor plan features.

Online Eyewear Store PHP: Some of the Project Screens

Home Page

User Login

User Order

User Order Details

User Admin Dashboard

Manage Products

How to tally the Online Eyewear Store PHP Project

1. Download the task zip file

2. Extract the record and copy the eyewear_store folder

3. Paste wrong the directory–xampp/htdocs, for XAMPP C:\xampp\htdocs

4. Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database pinch the name  eyewear_db

6. Import eyewear_db.sql file(given wrong the zip package successful SQL record folder)

7. Run the script http://localhost/eyewear_store

**********User Credential**********
Username: [email protected]
Password: Test@123

OR registry a caller user.

Or Register a caller User.

**********Admin Credential**********
Username: admin
Password: Test@123

Online Eyewear Store PHP: Project Demo

Online Eyewear Store PHP: Project, Report, and PPT