Show Demo Download In this tutorial, we will create a Simple Shopping Cart using PHP and MySQL. Purpose of this tutorial is to explain the basic concept of shopping cart, and how to use PHP session to store values into array of cart. eCommerce websites usually uses the PHP session to store items that are added by the user into cart. I have shared a separate tutorial for PayPal Payment Integration in PHP, if you want to integrate PayPal payment with this shopping cart on your website follow the PayPal Payment Gateway tutorial. On the internet the shopping cart is simply an online application which is available over the internet on e-commerce websites, the visitors on the website can select and add different items into cart which they are intended to buy online. So lets start creating a simple shopping cart using PHP and MySQLi. I have divided this tutorial into few steps to make it easier to understand its working.
1. Create a Database, Table and Dump Sample DataTo create database run the following query in MySQL.
To create a table run the following query.
Note: I have already attached the SQL file of this table with dummy data, just download the complete zip file of this tutorial. 2. Create a Database ConnectionCreate a db.php file and paste the following database connection in it. Make sure that you update these credentials with your database credentials.
3. Create an Index FileCreate an index.php file and paste the following script in the beginning of your file.
The above script is just adding values of selected item into array so that we can display them into cart.php page. Add the following script in the same file in body section to display a cart icon.
Add the following script in the same file after adding the above script to display products from database and display message after adding any product.
4. Create a Cart FileCreate a cart.php file and paste the following script in the beginning of file.
The above script is performing two different things based on chosen action. If user click on remove item button, it will remove item from the cart. And if user changes the selected item quantity, it will also update the item quantity in the session array. If you want to display cart icon here so you can do the same which we did above in index.php file. Add the following script in the body section of the cart.php file.
The above script is simply displaying the products with full details, its price, units, image, and total amount. In here user can also select the quantity of its products. All messages of removing and adding quantity will also display here in the bottom. Sample screenshot is also attached below: 5. Create a CSS FileCreate an style.css file and paste the following style in it.
I try my best to explain this tutorial as simple as possible but if you still have any query you can leave it in comment section below, I will try to respond as soon as possible. Demo Download If you found this tutorial helpful, share it with your friends and developers group. I spent several hours to create this tutorial, if you want to say thanks so like my page on Facebook and share it. Facebook Official Page: All PHP Tricks |