Bro you are like a role model to me and you literally taught me everything i know in php and mysql.. i wish to see you in person someday....thanks for this video and may God almighty bless you
What an amazing tutorial that not only show you how everything is done step by step but the way he describes it ensures that you comprehend what's happening..... Great job!!!!👍
i started this a wek ago..i thought it would be easy for me to do...but ...no!!! damn..sir u r great i got error evry now n then i got frudstated i sat in laptop fro 10 hours a day i kept doing 1 error solved it then 2nd error solved it yes i gort fade up but still i didnt quit i tried tried n tried many places coding didnt work due to latest php version but i didnt loose hope i searched web went throiugh other tutorials and finallyu !1 today i finaly finished it.. a big thank you to u!!!!! also, its not like that i copied n paste ur efforts of teaching students really made me learn so many things now i will modify the design and make it more functional by adding log in and sign up thank u sir love u
AMAZING VIDEO! i really like that you explains some of the function's functions so that beginners like me understand the concept as a whole. Keep it up man!
Thank God I came across this tutorial, very well explained 👏 not sure if you did it but how can the cart list be saved so every time the user logs in his cart will still have his products?
I am from functional programming so that is why I am not using pdo. Any way I will make a PayPal transaction system for you. Thank you 😊 for your request
hey man i just have one question : if i logout and log in using another account, how do i know if the cart session belong to the current logged in user and not displaying the same shopping cart for all users?
Using the id. Match the log user id with the card user id. Make sure when user add card data you add user id as well with the card. So you only fetch the card with belongs to the log in user
This is only for a single user no? what can I do to store multilple users carts information in the database? Also youre so good in explaining and teaching!!
If 2 guys are buying same product same time and if first guy made successful payment and when 2nd guy making payment the product must be not available (consider only 1 in stock) How will you handle this scenario? Db transaction or lock that table?
Great video! Change suggestion in cart.php: in the if statement after "$total=0;", add "&& !empty($_SESSION['cart'])" in condition so "Cart is empty" can be properly displayed when session is set while there is nothing in the cart.
Bro code is running ,it works properly. But the problem is i can't increse the quantity of product. Why what should i have to do for increasing the quantity. And one more problem is that after adding we removed product from the cart till that everything is working. But after removed when i tried to add again that product in cart instead of adding it takes place of the product that was already in the carty. So these two major problems I'm facing. Expect them every function is working fine. Thank u for this wonderful tutorial. Do answer asap :)
Good morning, dear Sir! Excuse me, I will be a little off topic, but I am currently building an online sales site, which includes a back office allowing the management of orders placed by customers. My problem is with the recording of the contents of a basket in the database. I have an "order" table that contains a product_id field and an order_id field, and I don't see how to save multiple product_id (if the cart contains multiple products with different id's) under one order_id. Currently, when there are several products, only the product_id of the last product (for example, if there are 4 products, only the product id4 is taken into account) is recorded in the order table. Thank you in advance for your help.
@@abdullahihussein9924 yep i know that... its a way to create database which connect to phpmyadmin... im just curious about the css and html codes since he used apple and Im using windows... is it make any changes? like the output going to be different results? because im using different OS
Guys Im working for a school project, can you tell me few explanations why is it better to code your own e-shop instead of using some systems like prestashop and similar..
i got the error: Warning : mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\Advance_Shopping_cart-master\Advance_Shopping_cart-master\index.php on line 71
@@DailyTuition Good day I have the same issue can you please make a video or explain a bit more in detail as to how / where to input his: "INSERT INTO Producttb (product_name, product_price, product_image) VALUES ('Apple MacBook Pro',1799,'./upload/product1.png'), ('Sony E7 Headphones',147,'./upload/product2.png'), ('Sony Xperia Z4',459,'./upload/product3.png'), ('Samsung Galaxy A50',278,'./upload/product4.png')";
This video was helpful. I appreciate it. How can I get to send email to the user the item name and item total cost after checking the cart instead of payment method . If you can create a video it will be helpful
Buddy the title of video is shopping cart tutorial you took an hour just to set up the website it would be better if you just focused on the functionality of cart only
I disagree with you. Most of viewers here are just starting to understand everything that is required for a full cart system!! Bro just scroll to where you need is what i do sometimes!
Hi, nice tutorial! Works perfectly. DB question now : How can you update a field value in the database table, when clicking on an 'add to cart' button? So depending on which button you clicked (of which product id), update a value of that record. I suppose an onclick event on the buttons, calling a function with php again, and inside that php an UPDATE sql. But how can you use the current product (id) as parameter so only the value of that product record gets updated?
How to make a space between sections. When I put 4 sections, the line is filled and when I start to place new products, there is no space between the first section of 4 products and the second section of 4 products. How do I solve this?
I am really appreciate appreciate your effort, being using your code in my website, unfortunately I couldn't add total price according to quantity..wish will be a update soon
I ran into a problem at the very end of the video. When I removed one item from the cart and went back to the main page to add it back in, it replaced another item. Is there a way to fix this? Otherwise, this was a great video!
Hi, Good Day Daily Tuition this Advanced Shopping Cart Tutorial With Php and MySqli Database really helps me a lot and i want to thank you on this. but if you mind continuing this project, like connecting to paypal or how pay the items order, also a client need to sign in first to have a payment transaction. or do you have any tutorials regarding to what i mention above, because i'm doing a project same as this. I hope you could help me regarding to my problem..thanks a lot!
@@DailyTuition Thanks a lot Sir, i'll be waiting for that concept.. can you also please do the part when changing the quantity of a certain item in side the cart and it will change the total amount of payable.. i'm doing that part right now but it's giving hard time, when changing the quantity and also affect the quantity stock in the inventory.
First you need to uniquely identify your cart item. And make sure you have different table for cart so that when someone try to change quantity it will not get affected in inventory
@@DailyTuition First you need to uniquely identify your cart item. -> it means to GET the product ID? And make sure you have different table for cart -> it means aside from inventory table where i stored product information, i should have to create a table in my database for Cart item where can i stored information like, productID, customerID(the one who bought the item), quantity(per item)? i want for example, if i have apple macbook pro in my inventory with the quantity of 30, and the customer put in the cart and update the quantity that the customer want to buy, like the customer want to buy 5 apple macbook pro. the inventory table will also change and it turns to 25. anyway, thanks a lot for replying and recognizing my comment and question,
Ok for that you need to execute two commands at the same time. Add 5 in the cart table and remove 5 from inventory. Make sure when user checkout remove 5 from inventory.
Hi Daily Tuition, I think I’m not the only one experiencing this but for some reason I cannot see the Java’s updated code to implement the product quantity function and updating the total price once the quantity has been changed in the cart. I would really appreciate it if you could please update your source code to include the JavaScript code needed to create this function. Your tutorials are amazing by the way. Thank you.
@@DailyTuition : The methods of coding you applied in the new tutorial aren't matching this one. As a beginner, it's so hard for me to merge both tutorials' content, please we need an update for this tutorial to know more about how to update quantity and the overall cost amount.
Ok. to update your quantity section you need to first specify a unique data attribute to your button and textbox so can identify it using that data attribute. When you specify a unique ID create onclick event on button and get the ID of the button match that ID with textbox and change the value of the quantity and add one in the quantity. Do the Same for the decrease quantity.
Just implement this on the CART.php page and there you have it. Problems solved. You may have to adjust the php code but this should be a walk in the park.
Hello! I really liked this video and it helped me so much!! But I have one question, I really want to change the dollar sign to the euro sign. How do I change this? Thank you so much for your help!
Bro you are like a role model to me and you literally taught me everything i know in php and mysql.. i wish to see you in person someday....thanks for this video and may God almighty bless you
Ohh. Thank you so much 🥰
please do you know how i can increase the cart quantity
@@DailyTuitionwhere will be data saved
سر بہترین سمجھایا ہے
یقین کریں بہت عمدہ 🤍
What an amazing tutorial that not only show you how everything is done step by step but the way he describes it ensures that you comprehend what's happening..... Great job!!!!👍
Thank you keep supporting
Where the data will be saved@@DailyTuition
i started this a wek ago..i thought it would be easy for me to do...but ...no!!!
damn..sir u r great
i got error evry now n then
i got frudstated
i sat in laptop fro 10 hours a day
i kept doing
1 error
solved it
then 2nd error solved it
yes i gort fade up
but still i didnt quit
i tried tried n tried
many places coding didnt work due to latest php version
but i didnt loose hope
i searched web
went throiugh other tutorials and finallyu !1
today
i finaly finished it..
a big thank you to u!!!!!
also, its not like that i copied n paste
ur efforts of teaching students really made me learn so many things
now i will modify the design and make it more functional by adding log in and sign up
thank u sir
love u
most welcome, keep learning with effort 🙂👍
AMAZING VIDEO! i really like that you explains some of the function's functions so that beginners like me understand the concept as a whole. Keep it up man!
Keep learning
which framework used?
this is awesome, now just insert a login system for username and password:)!
34:09 Thank you for giving information about that, now I can create a database and table using PHP script. God bless and stay safe!
Most welcome 😊 keep supporting
@@DailyTuition I already subbed you, keep up the good work, your effort is greatly appreciated.
Thank God I came across this tutorial, very well explained 👏 not sure if you did it but how can the cart list be saved so every time the user logs in his cart will still have his products?
We are using session so it will be stored
It need user id and session
Thanks for the effort and time you spend on this great heartwarming tutorial, it was very educative.
That's great. Keep learning :D
Wow this video help me clearing the logic of cart thank you it's a project which is also an assignment before job interview interview
A very interesting tutorial. Questions: 1. Why not PDO for Database? 2. Will you implement a PayPal transaction system for completeness?
I am from functional programming so that is why I am not using pdo. Any way I will make a PayPal transaction system for you. Thank you 😊 for your request
@@DailyTuition Amazing! Thank you!
Hi
Sorry miss I have question
You used in this Web page
Bootrap yeah
Because some attributes is new for me
Yes I used bootstrap
ur a true hero my sir, thank u
Amazing tutorial, helped me grasp PHP and the basic usage of MySQL and MyPHPAdmin in half an hour
Keep supporting
"So I'm gonna just say here..." X104...
Great tutorial Man!!
Thank you 😊❤️
thank you so much for your tutorial. May god bless you and your fellow tutors that also helps me on doing my project!
Thanks so much! This is an amazing tutorial.
Thanks a lot. Very clear instructions. I can understand your teachings more than my lecturers :-)
Thank you
I was panicking because I don't know how to make add to cart work for my assignment. I came to the right place, thank you kind sir
Most welcome. Keep learning
@@DailyTuition Where can I learn to increase the quantity of items in the cart?
Check out my Ecommerce tutorial on this channel. th-cam.com/video/KLWA2vCERSQ/w-d-xo.html
hey man i just have one question : if i logout and log in using another account, how do i know if the cart session belong to the current logged in user and not displaying the same shopping cart for all users?
Using the id. Match the log user id with the card user id. Make sure when user add card data you add user id as well with the card. So you only fetch the card with belongs to the log in user
This is only for a single user no? what can I do to store multilple users carts information in the database? Also youre so good in explaining and teaching!!
thank you bro im waiting for next video for this project .
i'm from 2021 just wanna say i'm really thanks for good explaination❤
Thank you keep supporting
This tutorial is so amazing, thankyou very much... i hope there is next session to procceed confirm method payment :)
much love from jamaica
Thank you
the best bro, thank god I found u
I notice you only one channel that have great php tutorial, thanks a lot. Can u teach us how to integrate payment with php :)
Really appreciate
If 2 guys are buying same product same time and if first guy made successful payment and when 2nd guy making payment the product must be not available (consider only 1 in stock) How will you handle this scenario? Db transaction or lock that table?
Great job brother! Thanks a ton! 🙏🏻
Most welcome 😊
Very educative. I liked how youtook us step by step.
Great tutorial. Looking forward for your future tutorials
Thanks for your support 🙏
this was amazing man! Great job!
Great video!
Change suggestion in cart.php: in the if statement after "$total=0;", add "&& !empty($_SESSION['cart'])" in condition so "Cart is empty" can be properly displayed when session is set while there is nothing in the cart.
I recently uploaded a new video that will explain you everything.
@@DailyTuition Link please?
I have learned a lot.....its great tutorial..
Hello bro,make video on payment gateway for this project.
Bro code is running ,it works properly. But the problem is i can't increse the quantity of product. Why what should i have to do for increasing the quantity.
And one more problem is that after adding we removed product from the cart till that everything is working. But after removed when i tried to add again that product in cart instead of adding it takes place of the product that was already in the carty.
So these two major problems I'm facing. Expect them every function is working fine.
Thank u for this wonderful tutorial.
Do answer asap :)
You have to check my ecommerce tutorial to learn how to increase quantity and cart cart process. It's my latest tutorial plz check that
Good morning, dear Sir!
Excuse me, I will be a little off topic, but I am currently building an online sales site, which includes a back office allowing the management of orders placed by customers.
My problem is with the recording of the contents of a basket in the database.
I have an "order" table that contains a product_id field and an order_id field, and I don't see how to save multiple product_id (if the cart contains multiple products with different id's) under one order_id.
Currently, when there are several products, only the product_id of the last product (for example, if there are 4 products, only the product id4 is taken into account) is recorded in the order table.
Thank you in advance for your help.
im just curious, are the codes work properly since you're using apple and im using windows?... your video really got me interest man..
Thank you so much keep supporting for more videos 🤗
xampp is a cross plateform my friend...so it will definately work...
@@abdullahihussein9924 yep i know that... its a way to create database which connect to phpmyadmin... im just curious about the css and html codes since he used apple and Im using windows... is it make any changes? like the output going to be different results? because im using different OS
any follow up tutorials on PayPal or Stripe integration? Thanks
Guys Im working for a school project, can you tell me few explanations why is it better to code your own e-shop instead of using some systems like prestashop and similar..
Great tutorial on add cart got to learn alot thanks for it👍
mainly working with php...
would you suggest to use phpstorm (never used) over vscode with php extensions (current setup)
Actually vscode is free and phpstorm is paid. If you have money then phpstorm is best but if you don't want to spend many then vscode is better.
You saved me!
Hi
About the part where you 'send the order'....did you make a video ?
No. this is just a cart tutorial
@@DailyTuition How about a video,when you select the amount of the product ?Can you seuggest me one ?
thank you so much this helped me a lot :))
It is an excellet vedio session.Many Thanks
Most welcome 😊
Time Span:18:24- at least to let your viewers know that you've replaced double quotation with back slash double quotation
Accurate
I want to use select field for the size. Each size have diff prices and i want to add it into cart. Please give me an example
I have a Ecommerce tutorial on this channel plz check that
@@DailyTuition ok thanks
After creating component.php I get a syntax error: unexpected end of file. My component.php file ends with } am I getting something wrong?
This is syntax error. Plz check you are missing the syntax
I get an error after putting products in the component function and the error is unexpected ‘:’ please tell how to solve?
The Best Tutorial on Planet EARTH.. KEEP IT UP
Thank you sir.. God bless you...
Sir
How to use JavaScript for changing the quantity of product
Working on new project with quantity
@@DailyTuition we need further more help for this issue
Could please make video for it??
Thank you so much for creating this tutorial....... Love you bro.......
i got the error:
Warning
: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in
C:\xampp\htdocs\Advance_Shopping_cart-master\Advance_Shopping_cart-master\index.php
on line
71
Add data in the table and make sure the query returning at least one record 👍
@@DailyTuition i dont understand what you mean there ..please show me how to do it
I mean add record in the table and try again
@@DailyTuition Good day I have the same issue can you please make a video or explain a bit more in detail as to how / where to input his: "INSERT INTO Producttb (product_name, product_price, product_image)
VALUES ('Apple MacBook Pro',1799,'./upload/product1.png'),
('Sony E7 Headphones',147,'./upload/product2.png'),
('Sony Xperia Z4',459,'./upload/product3.png'),
('Samsung Galaxy A50',278,'./upload/product4.png')";
This is the SQL command. You need to execute it in the SQL file. This will insert data in the table.
Good job. Thanks. How would you do the checkout?
Use paypal integration 👍 or something else
18:29
i got this error
Notice: Undefined variable: element in /opt/lampp/htdocs/shoppingapp/shopping/php/component.php on line 37
what's the problem?
Variable is undefined. It means you need to create this variable before using it.
@@DailyTuition I have created the variable by following your tutorial but it's still not working
Got it now, I forgot to put a semi-colon after the $element
This video was helpful. I appreciate it. How can I get to send email to the user the item name and item total cost after checking the cart instead of payment method . If you can create a video it will be helpful
Yes sure
@@DailyTuition please when will that be?
Don't know. But as soon as possible
Buddy the title of video is shopping cart tutorial you took an hour just to set up the website it would be better if you just focused on the functionality of cart only
We needed what he did
I disagree with you. Most of viewers here are just starting to understand everything that is required for a full cart system!! Bro just scroll to where you need is what i do sometimes!
i love you man you saved my life
Ohh. ☺️
How to increase the quantity? Why is this called advanced if you can't even add the quantity
Use JavaScript
Hi, nice tutorial! Works perfectly.
DB question now : How can you update a field value in the database table, when clicking on an 'add to cart' button?
So depending on which button you clicked (of which product id), update a value of that record.
I suppose an onclick event on the buttons, calling a function with php again, and inside that php an UPDATE sql.
But how can you use the current product (id) as parameter so only the value of that product record gets updated?
Pass the product id to the html element so you can get the id for update
How to set card in 1 row my product cart 2 is below to product 1 card
excellent work, very educational, keep up the good work.
Thanks 😊
great video!
How would we go about a feature to take payment? and another feature to store successful purchase details?
Thanks in advance!
Check out this video th-cam.com/video/UEJHSPM-Qiw/w-d-xo.html
This video is really helpfull , please upload the further part of quantity and increase in price plz I m not able to do code for that.
Plz check my ecommerce tutorial of PHP you will learn everything in it
Great tutorial man! thank you so much!!
Can you make also qty add or remove from cart and checkout on this example? Great Tutorial.
I am working on that part 😊
lovely video i am looking this kind of video
Thanks a lot , it was really useful 👍 👌 you've helped me in my project
God bless you 🙏
Most welcome 😊
How to make a space between sections. When I put 4 sections, the line is filled and when I start to place new products, there is no space between the first section of 4 products and the second section of 4 products. How do I solve this?
Use flex to the section and add gap property to it
@@DailyTuition tnx bro
From where did you learn all css and bootstrap?Please reply me.😊
I learnt bootstrap from official bootstrap website and css from videos. 😊
thank you, but I am struggling with creating the quantity increasing part. Do you have another tutorial for that or can you give me a lead ?
hello do you done creating a quantity?
give me tutorial for that plss
Yes I have. Check this out th-cam.com/video/KLWA2vCERSQ/w-d-xo.html
Sir, in the cart section does the accordion works? for buying multiple goods at once in the session cart?
how to make it works?
I have a Ecommerce tutorial on the channel plz watch that. You will find all your question answers
I am really appreciate appreciate your effort, being using your code in my website, unfortunately I couldn't add total price according to quantity..wish will be a update soon
Use JavaScript for that. Using Ajax you can do want you want. 👍
ThankYou Mr. Daily your videos help me to do my homework :)
Amazing Tutorial Software !
Thank you sir for the video. I have a problem. Once I delete the items, and add again, it doesn't add to the basket. Please Help me. Best Regard.
I think the problem is in the ID or in the insert method
thankx for your efforts. Its really usefull.
I ran into a problem at the very end of the video. When I removed one item from the cart and went back to the main page to add it back in, it replaced another item. Is there a way to fix this? Otherwise, this was a great video!
Plz check the get data function again. And make sure when you add product in the cart you specify unique it to it
Thanks for this helpfull video. Do you know how it's possible to set the number per product to 2,3,4,... when you click on "add to cart" more times?
You don't have to add one product multiple times. Just increase quantity that would be great. 😊
one of the best tutorial. Thanks Bro
Thanks keep supporting
Hi, Good Day Daily Tuition this Advanced Shopping Cart Tutorial With Php and MySqli Database really helps me a lot and i want to thank you on this.
but if you mind continuing this project, like connecting to paypal or how pay the items order, also a client need to sign in first to have a payment transaction.
or do you have any tutorials regarding to what i mention above, because i'm doing a project same as this. I hope you could help me regarding to my problem..thanks a lot!
I am working on that project
@@DailyTuition Thanks a lot Sir, i'll be waiting for that concept..
can you also please do the part when changing the quantity of a certain item in side the cart and it will change the total amount of payable..
i'm doing that part right now but it's giving hard time, when changing the quantity and also affect the quantity stock in the inventory.
First you need to uniquely identify your cart item. And make sure you have different table for cart so that when someone try to change quantity it will not get affected in inventory
@@DailyTuition First you need to uniquely identify your cart item. -> it means to GET the product ID?
And make sure you have different table for cart -> it means aside from inventory table where i stored product information, i should have to create a table in my database for Cart item where can i stored information like, productID, customerID(the one who bought the item), quantity(per item)?
i want for example, if i have apple macbook pro in my inventory with the quantity of 30, and the customer put in the cart and update the quantity that the customer want to buy, like the customer want to buy 5 apple macbook pro. the inventory table will also change and it turns to 25.
anyway, thanks a lot for replying and recognizing my comment and question,
Ok for that you need to execute two commands at the same time. Add 5 in the cart table and remove 5 from inventory. Make sure when user checkout remove 5 from inventory.
This is great Sir
Thx for the tutorial can u continue with the checkout we can see the payment method and how we can integrate them also
I will make another tutorial for that
@@DailyTuition
Can introduce mobile money payment with ussd ?
I will 😊
Thank u so much this was so useful I'm crying rn
Most welcome 😊
Hi bro.
In this website How i add the payment integration to checkout the products.?
I have a dedicated video on payment integration check out this video
th-cam.com/video/UEJHSPM-Qiw/w-d-xo.html
Thanks for this great video , great job 👍 🇹🇳
thankyou for this .it's really helpful specially for begginers like me😊 👍
Most welcome 😊
Tysm 🤩 very well explained !!
I will be very grateful to you if after watching your whole video tutorial, you display the code listing of the program.
hello, thanks for the video, but how can I make it so that when I click on (Plus or Minus, the product is added and decreased ?)
I have a dedicated video on it plz check the channel video section. Search for e-commerce website tutorial
Hi Daily Tuition, I think I’m not the only one experiencing this but for some reason I cannot see the Java’s updated code to implement the product quantity function and updating the total price once the quantity has been changed in the cart. I would really appreciate it if you could please update your source code to include the JavaScript code needed to create this function. Your tutorials are amazing by the way. Thank you.
I have new tutorial on updating cart product quantity. Plz check the source code
@@DailyTuition : The methods of coding you applied in the new tutorial aren't matching this one. As a beginner, it's so hard for me to merge both tutorials' content, please we need an update for this tutorial to know more about how to update quantity and the overall cost amount.
Ok. to update your quantity section you need to first specify a unique data attribute to your button and textbox so can identify it using that data attribute. When you specify a unique ID create onclick event on button and get the ID of the button match that ID with textbox and change the value of the quantity and add one in the quantity. Do the Same for the decrease quantity.
Amazing 👌, but the only thing missing is the function to add and subtract the qtantity of products. Could send this part in the comments ?
Heyy, have you found it?
Just implement this on the CART.php page and there you have it. Problems solved. You may have to adjust the php code but this should be a walk in the park.
Hello! I really liked this video and it helped me so much!! But I have one question, I really want to change the dollar sign to the euro sign. How do I change this? Thank you so much for your help!
add the euro sign before doller mark
Thank you so much for the tutorial, and the source code is very much helpful for my college project..
Hello
At 18:30 how the slashes been added when u copied the code. Example (
Hi! little question which packages are you using in Atom for PHP?
Hi I already have a shopping cart but can I know more about the part where it display the amount of item in the cart? I can't seem to get it working.
Use JavaScript for quality. Using it increase the quantity
what an amazing tutorial I appreciate that. Nice work
Keep learning
Great tutorial, I got no error while creating database but there is no databases created nor the table after I run the file
Create a database first and specify that to the database file. Then run