Free Course Image Create an Ecommerce website using PHP and MySql

Free online courseCreate an Ecommerce website using PHP and MySql

Duration of the online course: 18 hours and 49 minutes

New

Build a complete ecommerce website with PHP & MySQL—cart, login, admin panel and checkout. Free online course with hands-on project skills.

In this free course, learn about

  • Build a full e-commerce website flow with PHP + MySQL (products, cart, checkout, orders)
  • Set up local PHP dev environment with VS Code and XAMPP (Apache, MySQL, phpMyAdmin)
  • Create MySQL schema/tables: products, categories, brands, cart, users, orders, payments
  • Use SQL CRUD from PHP (INSERT/SELECT/UPDATE/DELETE) with proper datatypes and auto-increment IDs
  • Design responsive UI with Bootstrap: navbar, grids/columns, side navigation, product cards
  • Handle HTML forms with GET/POST, fetch dynamic data, search, and show product details (View More)
  • Implement reusable PHP functions to display products and filter by category/brand via URL params
  • Cart logic: add/remove items, quantity updates, item count, total price, empty-cart messaging
  • Sessions-based auth: registration/login, redirects, show username, toggle login/logout, checkout guard
  • Secure passwords with hashing and validate existing users to prevent duplicates
  • Orders & payments: pending orders, confirm payment, user dashboard (profile, orders, update, delete)
  • Admin panel CRUD: manage products/categories/brands, view orders/payments/users, confirm deletes
  • Deploy PHP site to free hosting (000webhost/InfinityFree) and manage paths for production
  • Integrate Paytm payment gateway in PHP for online payments

Course Description

Turn your PHP basics into a real, portfolio-ready ecommerce website. In this free online web development course, you’ll build an end-to-end store backed by MySQL, learning how dynamic pages, database-driven listings, and user interactions come together in a complete application. Instead of focusing on isolated snippets, you’ll work through the full flow of an ecommerce experience, from browsing products and viewing details to adding items to a cart and moving through checkout.

You’ll set up a practical local development environment, structure a multi-page project, and create reusable logic that keeps your code organized as the project grows. As you connect PHP to MySQL, you’ll learn how to create and manage tables, insert and fetch records, and render products, categories, and brands dynamically. The course emphasizes how information moves between forms, URLs, and database queries, so you can confidently implement features like search, filtering, and detailed product views.

Shopping carts are a core part of the project, so you’ll implement the logic required to add items, track quantities, update totals, and handle empty-cart states. You’ll also explore session-based behavior to support login-aware pages and smooth navigation between customer actions. On the user side, you’ll build registration and login flows, handle password protection practices, manage accounts, and show personalized information such as orders and profile data. You’ll gain an understanding of what makes these workflows reliable in everyday usage.

To round out a real ecommerce build, you’ll create an admin area that supports managing products, categories, brands, users, orders, and payments. This is the part that helps you think like a developer delivering maintainable tools, not just a storefront. Finally, you’ll see what it takes to host a dynamic PHP website and explore options for deploying online, helping you move from local development to a live project you can share.

Course content

  • Video class: E-Commerce Website using PHP and MySQL || Project Demo || Part -1 30m
  • Exercise: _What happens when you click on the "Add to Cart" button on a product page?
  • Video class: E-Commerce Website using PHP and MySQL || Prerequisites || Part -2 04m
  • Exercise: Which tool is used as a local server for PHP in the project?
  • Video class: E-Commerce Website using PHP and MySQL || Installation of Visual Studio Code Editor || Part -3 05m
  • Exercise: What is the first step to download VS Code Editor?
  • Video class: E-Commerce Website using PHP and MySQL || Installation of XAMPP control panel || Part -4 11m
  • Exercise: _What is Xampp?
  • Video class: E-Commerce Website using PHP and MySQL || Working on home navbar || Part-5 17m
  • Exercise: What is the primary purpose of using Bootstrap in the described web project?
  • Video class: E-Commerce Website using PHP and MySQL || Displaying products and Sidenav || Part-6 21m
  • Exercise: What is the key consideration for creating multiple columns in a Bootstrap row?
  • Video class: E-Commerce Website using PHP and MySQL || Admin Panel Design || Part-7 20m
  • Exercise: _What is the purpose of creating the "admin area" folder and the "index.php" file inside it?
  • Video class: E-Commerce Website using PHP and MySQL || Categories and Brands form || Part -8 15m
  • Exercise: What action does clicking 'Insert Categories' prompt in the script described?
  • Video class: E-Commerce Website using PHP and MySQL || Working with Database and tables || Part -9 07m
  • Exercise: What is the role of 'auto increment' for a table column in the context of MySQL database creation?
  • Video class: E-Commerce Website using PHP and MySQL || Inserting Categories || Part -10 13m
  • Exercise: _What method is used to pass the form data in this project?
  • Video class: E-Commerce Website using PHP and MySQL || Inserting Brands || Part -11 04m
  • Exercise: How can repeated entries be prevented when adding categories or brands to a database?
  • Video class: E-Commerce Website using PHP and MySQL || Displaying Data in Home page || Part -12 15m
  • Exercise: How is data dynamically displayed on the homepage from the database?
  • Video class: E-Commerce Website using PHP and MySQL || Insert product form || Part -13 20m
  • Exercise: _What is the purpose of "insert product.php" file in the project?
  • Video class: E-Commerce Website using PHP and MySQL || Working on Dynamic data || Part -14 09m
  • Exercise: What is the primary task described for fetching data in the form?
  • Video class: E-Commerce Website using PHP and MySQL || Working on Products table || Part -15 08m
  • Exercise: What is the correct datatype for storing product titles in the proposed database table?
  • Video class: E-Commerce Website using PHP and MySQL || Inserting Products || Part -16 27m
  • Exercise: _What is the method used to insert data in the database table in PHP?
  • Video class: E-Commerce Website using PHP and MySQL || Displaying Products || Part -17 20m
  • Exercise: What does ID number 7 represent in the categories table?
  • Video class: E-Commerce Website using PHP and MySQL || Using Functions || Part -18 09m
  • Exercise: What is the benefit of using functions for displaying data in the project?
  • Video class: E-Commerce Website using PHP and MySQL || Getting specific brands and categories data || Part -19 14m
  • Exercise: _What is the condition to display all the data if the category and brand are not set in the URL?
  • Video class: E-Commerce Website using PHP and MySQL || Display all products || Part -20 10m
  • Video class: E-Commerce Website using PHP and MySQL || Searching products|| Part -21 18m
  • Exercise: What determines the type of method to use when submitting data from the form described in the transcript?
  • Video class: E-Commerce Website using PHP and MySQL || More details of product || Part -22 11m
  • Exercise: _What happens when you click on the "View More" button related to a product?
  • Video class: E-Commerce Website using PHP and MySQL || Logic for view more || Part -23 07m
  • Video class: E-Commerce Website using PHP and MySQL || Working on IP address || Part -24 10m
  • Video class: E-Commerce Website using PHP and MySQL || Working on cart function || Part -25 26m
  • Exercise: _What is the purpose of the "add to cart" button in the e-commerce website?
  • Video class: E-Commerce Website using PHP and MySQL || Working on displaying number of items in cart || Part -26 12m
  • Video class: E-Commerce Website using PHP and MySQL || Doing changes in Cart table || Part -27 05m
  • Video class: E-Commerce Website using PHP and MySQL || Getting Total price || Part -28 20m
  • Exercise: _What new methods are we going to learn in PHP in this session?
  • Video class: E-Commerce Website using PHP and MySQL || Displaying Static Cart Design || Part -29 14m
  • Video class: E-Commerce Website using PHP and MySQL || Fetching Cart items || Part -30 12m
  • Video class: E-Commerce Website using PHP and MySQL || Updating Quantities || Part -31 10m
  • Exercise: _What is the default value set for quantity inside the database?
  • Video class: E-commerce Website using PHP and MySQL || Removing items from cart || Part-32 11m
  • Video class: E-commerce website using PHP and MySQL || Displaying empty cart message || Part-33 11m
  • Video class: E-commerce website using PHP and MySQL || Checkout page || Part-34 12m
  • Exercise: _What happens when the user clicks on the checkout button without logging in?
  • Video class: E-commerce website using PHP and MySQL || Understanding sessions || Part-35 09m
  • Video class: E-commerce website using PHP and MySQL || Creating User table || Part-36 04m
  • Video class: E-Commerce Website using PHP and MySQL || Registration form || Part -37 19m
  • Exercise: _What is the first thing the author is going to work on in the user area?
  • Video class: E-Commerce Website using PHP and MySQL || Login form || Part -38 12m
  • Video class: E-Commerce Website using PHP and MySQL || Inserting user data inside database || Part -39 21m
  • Video class: E-Commerce Website using PHP and MySQL || User exist or not || Part -40 10m
  • Exercise: _What is the purpose of the select query written in the code?
  • Video class: E-Commerce Website using PHP and MySQL || Password Hashing || Part -41 08m
  • Video class: E-Commerce Website using PHP and MySQL || Checking for item in cart || Part -42 08m
  • Video class: E-Commerce Website using PHP and MySQL || User Login Logic || Part -43 12m
  • Exercise: _What is the purpose of the code written inside the "user login.php" file?
  • Video class: E-Commerce Website using PHP and MySQL || User Redirection || Part -44 11m
  • Video class: E-Commerce Website using PHP and MySQL || Working on paths || Part -45 08m
  • Video class: E-commerce website using PHP and MySQL || Interchanging Login and Logout text || Part-46 09m
  • Video class: E-Commerce Website using PHP and MySQL || Displaying logged in username || Part-47 10m
  • Exercise: _What should be displayed if the user is not logged in?
  • Video class: E-Commerce Website using PHP and MySQL || Working on Payment page || Part -48 18m
  • Video class: E-Commerce Website using PHP and MySQL || Orders and Pending table || Part -49 06m
  • Exercise: _What is the purpose of creating a user orders table in an ecommerce website?
  • Video class: E-Commerce Website using PHP and MySQL || Working on Orders page || Part -50 19m
  • Video class: E-Commerce Website using PHP and MySQL || Working on Orders page-Inserting Orders || Part -51 15m
  • Video class: E-Commerce Website using PHP and MySQL || Working on Orders page-Deleting cart items || Part -52 09m
  • Exercise: _What is the purpose of storing data in the order pending table?
  • Video class: E-commerce website using PHP and MySQL || User Dashboard page || Part-53 19m
  • Exercise: _What will be displayed on the profile page if the user is not having any items inside the cart?
  • Video class: E-commerce website using PHP and MySQL || Fetching Profile Image || Part -54 08m
  • Video class: E-commerce website using PHP and MySQL || User Pending Orders|| Part -55 14m
  • Video class: E-commerce website using PHP and MySQL || Update User Account || Part -56 15m
  • Video class: E-commerce website using PHP and MySQL || Update Logic for user || Part -57 20m
  • Video class: E-commerce website using PHP and MySQL || Display User Orders || Part -58 18m
  • Exercise: _What variable needs to be active for the data to be displayed in the "My Orders" section of the profile page in the Ecommerce website project?
  • Video class: E-commerce website using PHP and MySQL || User Payment page || Part -59 15m
  • Video class: E-commerce website using PHP and MySQL || User Confirm Payment Logic || Part -60 11m
  • Video class: E-commerce website using PHP and MySQL || User Account Deletion|| Part -61 16m
  • Exercise: _What happens to the user ID when an existing user is deleted from the database in the demo shown in the session?
  • Video class: E-commerce website using PHP and MySQL || Admin Section Demo || Part -62 08m
  • Video class: E-commerce website using PHP and MySQL || Admin-View Products section || Part -63 13m
  • Video class: E-commerce website using PHP and MySQL || Admin-Fetch Products (Displaying Products) || Part -64 15m
  • Exercise: _Which variable name should exactly match with the column name present inside the database table?
  • Video class: E-commerce website using PHP and MySQL || Admin-Edit Product form || Part -65 17m
  • Video class: E-commerce website using PHP and MySQL || Admin-Fetching form data || Part -66 29m
  • Video class: E-commerce website using PHP and MySQL || Admin-Fetching form data || Part -67 22m
  • Video class: E-commerce website using PHP and MySQL || Admin-Deleting Products || Part -68 08m
  • Video class: E-commerce website using PHP and MySQL || Admin-View Categories and Brands || Part -69 12m
  • Video class: E-commerce website using PHP and MySQL || Admin-Edit Categories and Brands || Part -70 23m
  • Video class: E-commerce website using PHP and MySQL || Admin-Deleting Products || Part -71 08m
  • Video class: E-commerce website using PHP and MySQL || Admin-Confirm before deleting items || Part -72 13m
  • Video class: E-commerce website using PHP and MySQL || Admin - View Orders || Part -73 17m
  • Video class: E-commerce website using PHP and MySQL || Admin - View Payments || Part -74 14m
  • Video class: E-commerce website using PHP and MySQL || Admin - View Users || Part -75 11m
  • Video class: E-Commerce Website using PHP and MySQL || Admin - Registration form || Part -76 15m
  • Video class: E-Commerce Website using PHP and MySQL || Admin - Login form || Part -77 05m
  • Video class: E-Commerce Website using PHP and MySQL || Admin - Steps || Part -78 09m
  • Video class: Hosting Dynamic PHP website in 000webhost for free. 17m
  • Video class: Free Hosting Dynamic PHP website in Infinity free. 10m
  • Video class: Paytm Payment Gateway Integration in PHP. 22m

This free course includes:

18 hours and 49 minutes of online video course

Digital certificate of course completion (Free)

Exercises to train your knowledge

100% free, from content to certificate

Ready to get started?Download the app and get started today.

Install the app now

to access the course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

From zero to professional success

Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.

You can also use the QR Code or the links below.

QR Code - Download Cursa - Online Courses

More free courses at Web Development

Free Ebook + Audiobooks! Learn by listening or reading!

Download the App now to have access to + 5000 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online courses in video, ebooks and audiobooks.

  • More than 60 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate