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 course

Learn to create an E-commerce website using PHP and MySQL with this free, comprehensive online course. Covers setup, frontend, admin panels, cart functions, payment integration, and more.

In this free course, learn about

  • Introduction and Setup
  • Frontend Layout and Home Page
  • Admin Panel Basics and Category Management
  • Displaying Categories, Brands, and Products on Home Page
  • Product Details, Cart Logic, and Pricing
  • Cart Page and Checkout Flow
  • User Registration and Authentication
  • User Payments and Orders
  • User Profile, Dashboard, and Account Management
  • Admin Product and Catalog Management
  • Admin Orders, Payments, Users, and Authentication
  • Deployment and Payment Gateway Integration

Course Description

The course "Create an Ecommerce Website using PHP and MySQL" unfolds as a comprehensive guide for those interested in mastering the creation of a functional, dynamic e-commerce website. Over a span of 18 hours and 49 minutes, this course meticulously explores web development under the larger umbrella of Information Technology, offering a deep dive specifically into the subcategory of Web Development.

This course initiates with an insightful project demo to give learners a clear picture of the end goal they will achieve by the end of the program. Subsequent lessons cover all necessary prerequisites, guiding students step-by-step through the process of installing essential tools, such as Visual Studio Code Editor and the XAMPP control panel, ensuring that they are well-prepared from the outset.

As the course progresses, participants learn to construct vital components of the website—starting from the home navbar and leading up to the sophisticated admin panel design. The curriculum emphasizes a hands-on approach, engaging learners in tasks like displaying products, setting up category and brand forms, and working with databases and tables.

Integral to the learning experience is the detailed guidance on how to insert and display dynamic data. For instance, lessons dedicated to the insertion of products and the population of the product table highlight the practical aspects of database management. The course further delves into using functions to fetch specific brands and categories, enhancing the functionality of the website.

The importance of optimizing user experience is woven throughout the teachings—learners will understand how to implement search functionalities, handle cart features like item numbers and total prices, as well as managing checkout procedures. The importance of efficient session management is also covered, equipping students with the skills to create user tables, registration, and login forms, as well as implementing password hashing for added security.

Switching gears to the administrative side, the course offers an in-depth exploration of setting up and managing an admin section. This includes viewing, editing, and deleting products, managing categories and brands, and handling customer orders and payments. The complexity of these lessons ensures that participants are well-versed in maintaining an operational e-commerce platform.

For a more rounded expertise, the course also introduces concepts such as hosting a dynamic PHP website on platforms like 000webhost and Infinity Free, along with integrating payment gateways like Paytm.

By the end of this extensive program, learners will not only possess the technical know-how to build and manage an e-commerce site but also the practical skills to ensure its seamless operation. The dedication to thorough and practical teaching methods makes this course an invaluable resource for aspiring web developers. Though the course does not have reviews yet, its structured and comprehensive approach promises to equip participants with robust web development skills.

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

Download the App now to have access to + 3300 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 48 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

+ 9 million
students

Free and Valid
Certificate

60 thousand free
exercises

4.8/5 rating in
app stores

Free courses in
video and ebooks