Ecommerce Website in PHP MySQL with Source Code

A fully functional project based on E-commerce Website that uses PHP Language. Following PHP project contains all the essential features which can be in use for the second year IT students for their college projects. It has a number of features that will allow users to manage as well as shop online. This system as well as the web application’s concept is all clear, it’s the same as real-life scenarios and well-implemented on it. To download free eCommerce website project in PHP with source code files, please scroll down to the bottom of this post for the Download button.

About eCommerce Website PHP MySQL Project

Moving on, this E-Commerce Site Project in PHP focuses mainly on the eCommerce side of things such as online shopping and others. Also, the system displays all the lists of products with their respective prices. In addition, the system allows managing product brands too. This project is divided into two categories: Admin and Customer. In an overview of this web application, the customer has to register in order to perform various actions. A customer can look for products, add products to the cart, add products to a wishlist. Each product contains its own description, features, and number of photos. Talking about the checkout procedure, the customer can enter coupon codes for discounts. As soon as he/she passes through checkout procedures, the customer has to manage the order from the account section.

Manage Order – Customer’s Panel

The system lists out all the orders under the account section. Each order contains its own details. These details include product name, quantity, size, amount, and current status. By default, the order’s status is set to unpaid, unless he/she completes their own payment. Here, the customer has to verify the payment for finalizing the orders. For this, the user has to provide the invoice number, banking transaction code, amount, and much more. As soon as the user proceeds through this step, the system marks the order as paid status. Additionally, the user can view and manage all their wishlist under the wishlist section. Besides, the user can view bank accounts, edit profiles, passwords, and remove their personal account.

Admin Panel

On the other hand, an admin has full control over the system. An admin has the right to manage the proper flow of the system. He/she can manage the number of categories by entering their names, photos, and selecting certain features. After the management of categories, now the admin has to manage manufacturers. While referring to a number of categories, it means product category and a shopping category. As mentioned earlier, the process for this section is the same as well. The admin has to enter the manufacturer name, photo, and choose an option whether to show it as a top manufacturer or not. And now, after setting up all these fields, the administrator can add product details too.

Product and Bundles Management

For adding product details, an admin has to enter the product’s name, URL, select manufacturer, category, product category, description, price, photo, keyword, and label. Under the description section, there are three sections. These are product descriptions, product features, and videos. And in terms of adding photos, the system allows inserting up to three product photos. In addition to it, an admin can add and manage bundle products. For this, the procedures are the same as above. After setting up products and bundles, the system calculates the total number of each product sold with their publish dates too. Not only this, he/she can assign products to bundles relation by entering title and selecting a product with a bundle.

Coupon Management and Stores

In terms of this whole e-commerce website, a coupon code plays an important role for the customers around in order to provide them some discounted price. Just like that, this project contains coupon features for the customers. An admin has the right to manage each and every coupon. For inserting a coupon, an admin has to enter coupon name, coupon code, select product, price, and limit. The best thing out here is that the system lets us know about the number of people using the coupons. Also, the user can manage stores by providing various details. It includes store name, image, description, and URL. From this, the customers can check their store branches around them.

Orders, Customers, Payments and More

An E-Commerce website project is incomplete without the proper details of Orders, Customers, and Payments. Likewise, the admin can oversee all the orders performed by the customers around. It includes all the order details such as product name, image, quantity, size, price, date, and order status. The main responsibility of customers is to manage their order status. Meaning, the payment must be done in order to mark it as completed under the admin side. The admin can delete order records anytime. Similarly, the admin can view customer’s records with their details and payments throughout the website with their exact amount and payment method. Besides, the admin can view total earnings and view the number of pending and completed orders.

Last but not least, a clean and simple dashboard is presented with simple color combinations for a greater user experience while using this Online Shopping Website Project in PHP MySQL. For its UI elements, a free open-source CSS framework; Bootstrap is on board with Vanilla CSS too. Presenting a new E-Commerce Website Project in PHP MySQL which includes an admin panel with a client-side that contains all the essential features to follow up, and a knowledgeable resource for learning purposes.

Available Features:
  • Client-Side
  • Admin Panel
  • Add to Cart system
  • Wishlist system
  • Apply coupon codes
  • Order Management – Customer
  • Manage Profile – Customer
  • Categories and Manufacturers
  • Products and Bundles Management
  • Product – Bundles Relations
  • Set up Store details
  • Update contact, about us details
  • Coupon Management
  • List Customers
  • Manage Customer’s Order
  • Payment Management
  • User Management System
  • View Total Earnings
Project Name:eCommerce Website PHP MySQL
Language/s Used:PHP
PHP version (Recommended):5.6, 7.4
Database:MySQL
Type:Website, Web Application
Developer:Yasser Dalouzi
Updates:0
Ecommerce Website PHP Project Overview

Instructions: How to Run?

  • After you finish downloading the project, unzip the project file and head over to your XAMPP directory.
  • There you’ll find a folder naming “htdocs”.
  • Inside the “htdocs” folder, paste the project folder (not the .zip one, but the extracted one).
  • Open your favorite browser; we recommend using Google Chrome or Mozilla Firefox.
  • Then, go to URL “http://localhost/phpmyadmin“.
  • Create a Database with a name that is provided inside the “01 LOGIN DETAILS & PROJECT INFO.txt”.
  • Click on the “Import” tab and choose the database file (.sql) which is provided under the folder naming “DATABASE FILE”.
  • After setting up all these, go to URL “http://localhost/[ PROJECT_FOLDER_NAME ]/“
  • All the login details are provided inside the project folder, check that out and enter in order to use it.

And there you have it, a full setup of the eCommerce Website Project in PHP MySQL. For this particular PHP project, PHP Version 5.6 or Newer is required because the project might not operate well with the oldest PHP version. So, users with the oldest PHP version (less than 5.6) might face various problems while operating it. As a result, you’ll need to upgrade your PHP version (only if you’re using the oldest version) at the moment. Download Free E-Commerce Website Project in PHP MySQL Source Code. So, this Ecommerce Site PHP project is a fully functional project for all the beginners as well as intermediate levels that broads vast knowledge into such PHP web applications. In conclusion, this whole PHP project with free source code is an absolute project and a meaningful way for the users to learn and explore more about it.

Free Download Ecommerce Website Project in PHP MySQL with Source Code:
Click the Download Button Below to Start Downloading

Note: Only for Educational Purpose

120 comments

      1. sir i have finished until the importing mysql file after that the tables and all have been inserted . i searched for =http://localhost/[ PROJECT_FOLDER_NAME ]/. but its showing 404 error please help me asap bcoz its my project one

  1. Hello.. I’m getting this error..
    Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in C:\xampp\htdocs\E-COMM\functions\functions.php on line 88
    Can u tell me how can i solve this?

  2. Hello im new to this but what does this it means?
    After setting up all these, go to URL “http://localhost/[ PROJECT_FOLDER_NAME ]/“

    Whats the project folder name?

    1. That’s the field where you have to enter the name of the project’s folder! Also, the project folder name is the one that you get after unzipping the file. Each folder contains a name to it, so you’re required to enter that particular name.

  3. what does it mean by this?
    Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in C:\xampp\htdocs\ecommerce-website-php\functions\functions.php on line 294

    most of my errors are these, thankyou!

  4. website just shows “Welcome :Guest” at the top with the shopping cart icon, no content on the webpage at all?

      1. How do you mean, i have the database on the PHPmyAdmin service, with the correct name and all tables included, what else could i be missing?

          1. Nope none at all, it’s like it all works but doesn’t have any content to show?

          1. It’d be much easier if you could go through each file to look for it as we’ve our own stuff to do and we cannot just go through each and every file just for it!

  5. hi, may i why did i try to log in to admin but it said wrong email or password even after i log in using the one that you put in the file?

  6. The sidebar.php on shop.php is not filtering and updating the filtered manufacturer or category. Please help. Thanks

  7. In the check out section, how do you change the text that says
    “Pellentesqu………………………………………………….”

    Is it in the bootstrap or where?

          1. Use this code as a base code , right now its completely a different website , but with the same base code

    1. It’s all correct, make sure you’ve entered it correctly as it’s case-sensitive. If any doubt about that, you can simply check the credentials by yourself from the given db file!

  8. there is an error on load and localstore Warning: Undefined array key “sAction” in C:\xampp\htdocs\ecommerce-website-php\load.php on line 9, and in localstore is about line 41 on services

  9. Fatal error: Uncaught mysqli_sql_exception: Unknown database ‘ecom_store’ in C:\xampp………………….

    sir this error is coming what i have to do now

      1. So now what i have to do now
        can you explain me in detail because it is urgent for me

  10. Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\ecommerce-website-php\functions\functions.php on line 316.

    I keep getting this error when, i try to access the shop page after logging in. Can you help?

  11. Hello Sir…I’m a final year student and ive been using this template to complete my final year project.I’ve Edited most of the parts and payment methods but when you order more than one product(cart.php),it makes two orders in (my_account.php) and admin has to also verify the payment (according to how many products)…how to do i combine the order_id’s into one for checkout.I’m so stuck rn…Any Help would be so appreeciated.

  12. hii!!sir
    Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:………………
    some of warnings of my web so can you help me plz sir??

  13. #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

      1. I am getting a massage when I try to go to the website that says “not found the request url was not found on this server” what should I do to fix this?

  14. I have this error in login admin
    Not Found
    The requested URL was not found on this server.

    Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4 Server at localhost Port 80

  15. Good effort though your code is poorly structured. Too many unnecessary duplication of pages and logic. Kindly improve on that.

  16. The project is okay, thank you for having this for free. This will serve as my reference since my project system is also about ecommerce.

    The only concern I’ve got is that the database you provided is missing a table named “services” now I can’t go to local store since the table doesn’t exist.

    Hope you provide the complete database for this, if so, this will be a big help for me as a student. Thank you!! hope you notice this comment

  17. r: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘s’,’product’)’ at line 1 in C:\xampp\htdocs\ecommerce-website-php\admin_area\insert_product.php:430 Stack trace: #0 C:……………………

    1. It seems you’re attempting to log in as a customer using Admin credentials. The login details provided in the text file are only for the Admin login. For customer access, please register a new user. However, to access the admin panel, please use the credentials that we’ve provided in the text file.

    1. It seems you’re attempting to log in as a customer using Admin credentials. The login details provided in the text file are only for the Admin login. For customer access, please register a new user. However, to access the admin panel, please use the credentials that we’ve provided in the text file.

  18. Hello there, i’m trying to change homepage background image in css code but it doesn’t working, can u help me

  19. after importing the database , and try to consult the website, it says :
    Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C:\xampp\htdocs\eCommerceSite-PHP\header.php:25 Stack trace: #0 C:\xampp\htdocs\eCommerceSite-PHP\header.php(25): PDOStatement->execute() #1 C:\xampp\htdocs\eCommerceSite-PHP\index.php(1): require_once(‘C:\\xampp\\htdocs…’) #2 {main} thrown in C:\xampp\htdocs\eCommerceSite-PHP\header.php on line 25.

    Do you have any sort of solution that would help me 🙂 , thanks in advance!!

  20. #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
    There’s a mistake here. What should I do?

Leave a Reply

Your email address will not be published. Required fields are marked *