Tuesday , 25 October 2016

Complete E-commerce Website in PHP & MySQL (Urdu-Hindi)

After so many projects and video tutorials on PHP & MySQL web development in Urdu, we lastly released our complete PHP & MySQL Urdu course in DVD, which helped a large number of students across Pakistan and outside Pakistan. We included 25 hours of video content in that course including some small & mega projects. But the question is, does world end up there? No, not at all. We have to go a step ahead every time we do something new, and thus, we came up with our most awaited video course in Urdu “Creating an ecommerce website using PHP & MySQL from scratch”. We were requested by many of our students about this project, and we have finally created it with all passion & energy. Let me remind you that the world still doesn’t end up here. We’ll be going more forward in the near future. But over this page, let’s talk about our most awaited PHP & MySQL project.


What’s an E-commerce website?

If you have ever come across a website on the internet where people can buy products online and can pay online, or something like online buying and selling automatic systems which are basically called “ecommerce” websites. You can take an example of amazon.com worldwide or daraz.pk in Pakistan. So we are trying to build the same thing in PHP & MySQL from absolutely scratch. And the great point is always that, it’s in Urdu language which is easily understandable for people living in South Asia.

This course is a unique course of its kind, because according to my information, even in English there is no such course exist on the internet. So we’re proudly presenting it in Urdu.

Now if you want to see what we are going to create in this course then have a look at the screenshots below:

Front-end website of this Project


The above is the main website for this project which will be visible to the visitors/customers who want to order products, visitors can view products, can order products, can search products and can browse through the brands and categories, and finally they can create their free accounts.

Customer Account View 


The above screenshot is of the customer account, when a customer wants to order, he/she must create an account, so after they create an account, that will be like the above one, where they can manage their information and orders details.

The Back-end Admin area for this project


The above screenshot is of the Admin Panel for this project, where Administrator with username & password only can access this panel, he/she can manage the whole website & cms. We have kept it very simple for this project.

If you are convinced with above then simply buy the complete course with huge discount now:

Buy on Udemy OR Buy in DVD

What will you learn from this course?

If you take this course, you’ll learn creating a complete ecommerce website in PHP & MySQL from scratch, we’ll also be using JavaScript, HTML and CSS while creating this project. Furthermore, we’ll use Dreamweaver CS5 as a text editor in this course.

Following are some of the key points in this course: 

  • A complete ecommerce website (in PHP & MySQL)
  • The website layout (in HTML+CSS)
  • The database with 7 tables for this project
  • Relation between the tables
  • Creating the search engine for the project
  • Creating the customer General User Interface
  • Creating the functions for whole project
  • Shopping Cart for holding customer’s orders
  • Offline Payment option
  • Admin Panel to manage the content
  • User Sign Up application
  • User Sign in application
  • Admin Login application
  • Category & Brand based website
  • Uploading website to online web server
  • Much More………..

These tools or technologies will be used in this project: 

  1. PHP (Server Side)
  2. MySQL (Database)
  3. Apache (Server)
  4. XAMPP (Combination of above all)
  5. HTML (To structure web pages)
  6. CSS3 (To create website layout)
  7. JavaScript (For some specific tasks)
  8. Dreamweaver CS5 (For inserting the codes)
  9. FileZilla (For uploading the e commerce to online server)
  10. Cpanel (For online server)

ECommerce Video Tutorials in Urdu/Hindi

Now it’s time to show you some real time work, it’s a video course in Urdu/Hindi languages to create this thing from scratch, you’ll watch all the starting videos of this project one by one in Urdu. Remember that the videos are hosted on YouTube, so if you are watching from Pakistan then first open YouTube and then watch the videos playlist below.

Videos Playlist on YouTube!

After watching the above introductory videos of this course, we know you have found it great among all other courses, therefore you can now confidently buy it either from Udemy or in DVD, take action now:

Buy on Udemy OR Buy in DVD

If you think we have shared something useful for you then don’t hesitate to share this content with your friends on social media, just take a few seconds to share this whole course on Facebook, Twitter, Google+ and Pinterest. Thanks for that and do post your questions & suggestions in the comment section. #HappyWebDevelopment

About Abdul Wali

Abdul Wali is a Web Developer, SEO Consultant and Online Instructor working online for last 6 years on the internet and managing several successful websites. You can contact him via Email or follow him on Facebook. Also add him on .

Check Also


Chat System Using AJAX & PHP in Urdu/Hindi

Here is a small project for those who are learning PHP and AJAX. I’ve created …

  • amazing course wali bahi. wali bahi you working hard God bless you

    • you are welcome dude, we keep you updated with unique things and that’s what we can innovation.

  • Asif Ali

    Abdul Wali jab app nai google adsense apply kia tha to iss waqt aap ki google webmaster k hisaab sai per month kitni traffic(clicks) thi please must reply

    • Saif Ansari

      Don’t Ask any personal question…

  • Zee Junaid Ahmed

    Wali Bhai Nice efforts,,, Keep it up……….

  • Shahfaisal Qureshi

    wali bhai ye course kese buy kren, aur kitne ka he ye course, plz detail m btaeiga .. thnks

    • bhai jan, icki details jald he hamare buy a DVD site par ajayegi, just 2 din ma visit kare.

  • Saif Ansari

    Asslam u Alaikum,
    I found This course at many places as well as ask by many expert but no one upload this type of tutorial hence wali bhai Thank you very much for uploading.

    • W/salam and welcome brother.
      We always try to work on new & unique projects, you’ll see the same in the future Inshallah. stay connected.

  • Umar Farooq

    Amazing Sir 🙂

  • bilalakbar2344

    Fantastic work bro. Upload more videos related to this project .

    • More videos will be uploaded soon, visit this page most often to see more videos.

  • zahanat

    salam wali bhai buht acha course banay hain mjha ap sa ye pochna hain ka maina jo apsa course liya hain php ka wo ais e commerce ka course sa alag hain aur ye ais course ka price kya hain aur wali bhai plz wordpress ka link to send karday thanks

    • w/salam, ya course alag se ha. And kindly ap Facebook par mjhe message kare tu ma apko WordPress ka link send kar deta hon ya mjhe awpareshan@gmail.com par email kare.

  • zahanat

    salam wali bahi buhata cha course hain ais ka price kya hain aur wali bahi ais course main aur php ka jo pehla ka course hain kitna farq hain aur plz wali bhai mjha wordpress kalink send karday

    • w/salam,
      sorry Zahanat for late reply, yes, ya aik advance course ha PHP/MySQLi ma

  • Shahbaz Ali Lahoti

    Nice effort Abdul Wali, its more better and step toward to ecommerce world. better to introduce the platform start their on eshop,estore using wordpress,facebook and other social media site… i think you understand my request

  • Shahbaz Ali Lahoti

    please also write an article on DISQUS with pro and cons with wordpress ?????????????????

  • میاں جی

    wali sab , ecomerce wala video tutorial buhet hi acha bana hai, mujhe buhet pasand aya hai, iski waja se mein ne bhi aik web banaya hai, sab lecturer dekh chuka hun, baqi lecturer ki video apke pass kitne price mein available hogi, mujhe kuch bhi ayta tha , ye video dekh ker mujhe kuch na kuch seekhne ka hosla mila, kindly tell me price of complete ecomerce video tutorial, aur iske elawa bhi agar aapne web banaye hein to iski bhi video de dein, ta ke mein mazeed seekhne ke qabil ho jaon aur web bana sakun, apke jawab ka intizar rahey ga……………………..iftikhar from toba tek singh


  • Ameen bro and thanks for your words, ya DVD ma available hoga 15 Din tak Inshallah.

  • wait kare bhai thora.

  • w/salam,
    brother ma icki mazed videos ici page par jald he upload kar dunga. ap kindly ic page ko visit karte rahe take new tutorials ka pata chale apko.

    • Imran Memon

      Abdul Wali iski kitni videos hen total???

  • Hello brother,
    when it’s available for sale then we’ll let everyone know on this website. Keep in touch.

  • Ahmed

    Wali Bhai Keep it up nice topic waiting for more tutorial post it ASAP

    • Thanks bro, just going to create a social network in PHP

  • jazak ALLAH
    mein intezar kar raha Abdul bhai.
    ALLAH aap ko kamiyabi ata farmaye.

  • Asif Ali Jokhio


    Wali Bhai, Ager Copy Paste Na Karen to Hum Laptop ya Mobile etc ki price dekh ke apni typing kar sakte hen, or jo same waha likha hoga woh same likhne se koi problem to nhi hogina,

    • w/salam,
      I think koi problem nahi hogi.

  • Umar Farooq

    Awesome Effort Sir 🙂
    I Would Like To Thanks To You For All Your Efforts In The Field Of Urdu Video Tutorials.
    But, I’ve Created A Blog On Content Curation Called Urdu Curator, Please Give Me Your Suggestions About



    • w/salam,
      ya complete course ap dvd ma purchase kar sakte ha.

  • karn

    video to bahut acche hai par fetch hona mai bahut jada time lagata hai


    Wali bhai 4th last video mai jo laptop adding hotui hai last mai us mai Please Fill all The Feilds ara ha hai purey fill kye hain or db mai b send ni ho raha hai! please tell me how to resolve it?

  • bilalakbar2344

    Wali bro I am getting an error on this script in video number 13 time may be 14 minutes and code is

    if($product_title==” OR $product_cat==” OR $product_brand==” OR $product_price==” OR $product_desc==” OR $product_keywrods==” OR $product_img1==”){

    echo “alert(‘Please Fill All Fields!’)”;



    is it ok or have any error? please fix the problem fast

    • bilalakbar2344

      If you can give me source file for this insert_product.php then I’ll be very thankful to you because I really need it . Thanks

  • Wali bro I am getting an error on this script in video number 13 time may be 14 minutes and code is

    if($product_title==” OR $product_cat==” OR $product_brand==” OR $product_price==” OR $product_desc==” OR $product_keywrods==” OR $product_img1==”){

    echo “alert(‘Please Fill All Fields!’)”;



    is it ok or have any error? please fix the problem fast

  • Reply to karo bro

    • G bhai please let me know what I can help you with?

  • Imran Memon

    total kitni videos hen is ki?

  • Please upload other videos related to this project because many thing remain left these 16 videos are just trailer please bro upload complete course. Thanks

    • Bilal Bhai, ya course paid ha, ap complete course ko dvd ma purchase kar sakte ha.

  • osama

    ASSALAMULEIKUM..Bro please upload the whole course.its argent.reply.?

    • w/salam,
      this complete course is a paid course in DVD, please visit buy a dvd page. thanks

  • Ashikul Islam Tamal

    wali bhai.. please upload next part (after part-21) where i can found shopping cart system.

    • Hi Islam,
      this complete course is a paid course in DVD, please visit buy a dvd page. thanks

  • Ashraf Khan

    Assalamualaikum wali bhai plz upload remain vedios on e-commerce website…..Allah apko aor tarakki de hamne apke vedios se bahut kuch sikha hai bahut sukra guzar hu apka….hosake to plz ecom ka remain kuch vedio upload kr dijiye

    • w/salam,
      Dear Ashraf Khan, jaise k ya complete course aik paid course, ap kindly buy a dvd page ko visit kar len. Thanks!

  • charu

    next videos pls

  • Hi brother,
    Thank you for your comment, we can give you Rs.1000 discount on the course, so it will be Rs.5000.


      Thank u very much…Please guide me the procesure of buying DVD.

      • Please go to Buy a DVD page, there is all procedure to buy course in DVD.

  • Hi dear,
    Please visit buy a dvd page, you’ll find all information there. Thanks!

  • Thanks dude for your comment!

  • w/salam,
    bhai ya aik paid course ha, ap isko dvd ma purchase kar sakte ha. please visit buy a dvd page. Thanks!

  • Hello Shah Faisal,

    Ic link par jao, yahan par tamam details & price etc dekh sakte ha ap:


  • Good answer 😀

  • w/salam,
    ab update hogi, don’t worry.

  • Engr Mansoor Aly Khan

    video 13 , i m facing problem in move_uploaded_file its not uploading file to the desired folder. please help.

    • if you have any problem in the code then don’t forget to double check it closely & carefully, but if you still get errors then let me know your source code of that specific file which is generating errors via email at: awpareshan@gmail.com, I’ll look into that.

      • Engr Mansoor Aly Khan

        problem is with the move_uploaded_file its not movign the uploaded file from tmp folder to my desired location

  • Niranjani Boppudi

    Sir, I have done everything correct up to 13th video i.e., inserting new product page but i am unable to store product information in database. Even i did not getting alert messages included in insert_product.php file. After entering all fields in insert new product and clicking on insert_product it’s displaying the same page.i am unable to find error could you please help me sir..

    Thank you.

    • Hello,
      You need to carefully watch the videos again, because what you are saying is working perfectly in the course I’m teaching, However, in PHP there is always a chance for silly mistakes, so carefully watch the videos and double check your code for any errors.

  • Ihsan Ullah

    Sir where is the video about cart mean next video

  • Emaan Fatima

    wali bhai i couldn’t find ur remaing videos…..after part 29
    E-Commerce Website in PHP & MySQL Part 29 – Updating Quantity in Cart
    where they are….???

  • Ankur Sharma

    hi…wali g……. i am ankur from- INDIA,

    i like most your php,css, etc tutorial and as well as way of method of teach….oftenly i watched your tutorial on u tube and your website…
    so i want to you… provide me source code of the above project’s…….i am waiting for your reply…. Thanks.. and have a good night….

  • Sab category ap khud use kar sakte ha, is ma ham ne brands use ki ha sub category ki jaga.

  • haris shahid

    wali bhai your videos are owsome and helpful for all thank you ab object priented programming sa php use hoti hai uske bare main bhi kuch btaein?

  • Saima khan

    wali bhai, pakharoona … bhai new e-commerce website ke traffic kasa brae ga… plz

    • traffic SEO use karne se barega aur social media se.

  • Muhammad Azam Khan

    Wali Bhai is project ki full database share kr de plz

    • w/salam,

      Bhai ya aik paid course ha, source code course purchase karne k bad milega.

      • Muhammad Azam Khan

        sir database chahye only

  • Iso Rim

    upload video dailymtion or youtube

  • Hassan Tahir

    bhai jan Inserting Products into Table main problem a rhi hai :

    Object not found!

    The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

    If you think this is a server error, please contact the webmaster.

    Error 404

    Apache/2.4.12 (Win32) OpenSSL/1.0.1l PHP/5.6.8

  • Hassan Tahir

    bhai g video no.13 inserting products main yeh problem a rhi hai
    pls give solution ???

    Object not found!

    The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

    If you think this is a server error, please contact the webmaster.

    Error 404

    Apache/2.4.12 (Win32) OpenSSL/1.0.1l PHP/5.6.8

  • Hassan Shabbir

    Salam Wali Bhai I want to purchase this course Kindly Brief me Or Send Me you contact number

  • krazzykoder

    Salam Wali bhai. i want to purchase your
    eCommerce Website in PHP course please guide me on this and what are the payment methods you support and what will i get when i make a purchase

  • manzoorqadir

    i was searching about e commerce website admin penal and my account and signup page wali bhai plz i realy need after 29 onword bcz i realy need it for tomorow plz do somthing

    • Hi Manzoor,

      This is a paid course which you can purchase by visiting our buy a dvd section.

      • manzoorqadir

        sir seriously i will pay but plz i just need a few vedios like after 29 sir it is an emergancy plzzzz sir

  • balaji

    sir i want e commerce project in english,.

  • aslam

    Wali Bhai Ecommerce website tuitorial me Forgot Password ka tuitorial bhej dijiye please…

  • Hemant Kumar

    salam…..wali bhai……aapki tutorial mujhe bahut acha laga…..me iska dvd kharidneki kosis ki…..lekin meto ek student hoon…mere pass itna pesa jama nahi horahahei…..plz…kindly request mujhe bakika tutorial bhejiyena……plz…bhai….mujhe yeh ek help karna…..my e-mail : hemanth7381@gmail.com………plz….bhai mujhe yeh ek help kijiye….

  • IT King

    dvd kharid ne k liye cash on delivery option kyu nahi he…..

  • Rahul Chourasiya

    sir i m having a little bit problem in counting the number of item in the ecommerce project….on the index page it will shows 0 on the count ..it does not increase….what can i do…
    here is that code

    function total_price(){

    $total= 0;

    global $db;

    $ip = getIp();

    $sel_price = “select * from cart where ip_add=’$ip'”;

    $run_price= mysqli_query($db,$sel_price);

    while ($p_price=mysqli_fetch_array($run_price)) {

    // taking data from 2 tables

    $pro_id = $p_price[‘p_id’];

    $pro_price = “select * from products where product_id=’$pro_id'”;

    $run_pro_price= mysqli_query($db,$pro_price);

    while ($pp_price = mysqli_fetch_array($run_pro_price)) {

    // getting many value in one array


    $values = array_sum($product_price);

    $total +=$values;



    echo “$” . $total;


  • sadia

    wali bhai my updating cart button and Continue Shopping button is not working properly plz help me

  • Muhammad Ahmad

    Sir!Quantity ke 1 value thek update hte ha.jb 1 sy yada value hn jte ha.phr quantity update ni hte.please sir error remove kr dna,and mere mail pr sent kr dna.Thankx

  • Hariş

    assalam u alikum wali bhai,,ye message pura please..bohat zabardast tutotrial hai…sirf ek bat kahunga..k jin ko english samaj ne muskilaat bohat samna gai,,,isi lye ye urdu tutorial ki website pe…me itna kehna chahta hu k jinhy english achi samaj ati hai wo to kahi or se b tutorail dekhsakty hen..ap ki site ek visiter ata q hai qk ap k tutoial urdu me hoty hein..ap ne english me eccommerce web banana sikhai or wo full tutorial se hein,,or jinhy english nh ati samaj un k lye 21 tutorial srf…itni importand cheezein hen jo ap k eccommerce english tutorial me …wo ap ne urdu chor d..k dvd purchase karein to full milengy..jo angrez hai wo zayda seekh rahy hen or aagy nikal rahy hen ap k tutorials dekh ..k ap pakistani ka kia kusur hai jo garib log hai or jinhy english samj ..jo chahty k ek achi income hamary ghr b ay…pakistan ki awaan k lye kch karein ..taa k hamary mulk b it me number 1 pe ay..please request ap se k eccommerce k full tutorials upload karein..pakistani awaan ka hi bhala hoga or wp ap ko duen dengy…thanks

  • Muhammad Ahmad

    Sir!Please mera reply kr do.

  • Muhammad Ahmad

    please help me.
    Quantity thek update ni hn rhe.sirf 1 thek update hn rhe ha.
    jb 1 sy yada update krta ha.error a jta ha.please is page ka source code correct kr ka bhej da.I am wait.

  • Dipu shaw

    how can invite a seller to sell their product on my site like flipkart or amazon.

  • Tahir

    I am not pay fees I am not in good condition I want to course of web development and photoshop cs6 so give me any link to get the complete course Thanks

  • Hafiz M Hatib

    abdul wali bhai category and subcategory function bhi hona chahey tha is mai … please agr ap php mai cat & subcat system bhi sekha dety to acha hota …. thanks please cat & subcat bhi sekha dai

  • Hafiz M Hatib

    abdul wali bhai category and subcategory function bhi hona chahey tha is mai … please agr ap php mai cat & subcat system bhi sekha dety to acha hota …. thanks please cat & subcat bhi sekha dai please please

  • Hafiz M Hatib

    Please Please abdul wali bhai category and subcategory function bhi hona chahey tha is mai … please agr ap php mai cat & subcat system bhi sekha dety to acha hota …. thanks please cat & subcat bhi sekha dai