Hi coders \ud83d\ude42<\/p>\n
This tutorial does not include going from items in the card to payment and then rewarding for the payment. Only setting up the cart and adding items to it.<\/p>\n
You are viewing this page because you want a simple cart system for your website store. This tutorial will be quick and easy but in return will provide you with a very basic cart system that should not be used in a business environment, I would only use this if you’re new to coding!<\/p>\n
Here’s what you will need:<\/p>\n
– Basic knowledge of mysql<\/p>\n
– Basic php\/html\/css knowledge<\/p>\n
– User accounts set up and working<\/p>\n
<\/p>\n
That’s it! Now lets get to work!<\/p>\n
First we’re going to decide on what we’re selling, lets say I’m selling these 5 items for a company:<\/p>\n
– Apple, costs \u00a31<\/p>\n
– Banana, costs \u00a31.50<\/p>\n
– Melon, costs \u00a34<\/p>\n
– Orange, costs \u00a30.50<\/p>\n
– Mango, costs \u00a32<\/p>\n
Now create a new table in mysql called “cart” with 3 colums (id, user_id, item_id), all columns are type “int”.<\/p>\n
Once you’ve done this, create a new php file and call it “cart.php”. Now lets create a basic table, nothing fancy. Copy this code:<\/p>\n
<h2>Items<\/h2><\/span> Now you will have a table of your items, you can change the items how you want. Clicking “Add to Cart” won’t do anything yet though!<\/p>\n Lets change that, we want each click on “Add to Cart” to add the item to the cart, to do this we will insert a row into our database, like the following code shows:<\/p>\n <\/p>\n IF(isset($_POST[‘add1’])){<\/span> IF(isset($itemid)){<\/span> “$userid” is the ID of the user who is currently logged in. After this, your users will be able to add items to their cart, but they won’t be able to see their cart yet!<\/p>\n Lets make it so they can view their cart, add an optional ”<\/p>\n ” after the “form>” if you want, it will just look a bit better. Now put the following code after the “” or ”<\/p>\n ” depending on what you put:<\/p>\n <table><\/span> <td><\/td><\/span> echo “<b>Current cart items: <\/b><br><br>”;<\/span><\/p>\n Now lets get the items from the table with this query:\u00a0$get_cart = mysqli_query($con,”SELECT * FROM cart WHERE cart.user_id = $userid”);<\/span><\/p>\n Then we want to check whether or not the cart actually has items, you will do this with the following code:<\/p>\n IF(mysqli_num_rows($get_cart) == 0){<\/span> echo “Will do later”;<\/span><\/p>\n }<\/span><\/p>\n For the “Will do later”, you want to remove that echo completely now and put this:<\/p>\n $totalprice = 0;<\/span>
\n<form method=”POST”><\/span>
\n<table><\/span>
\n <tr><\/span>
\n <td><b>Name<\/b><\/td><\/span>
\n <td><b>Price<\/b><\/td><\/span>
\n <td><\/td><\/span>
\n <\/tr><\/span>
\n <tr><\/span>
\n <td>Apple<\/td><\/span>
\n <td>\u00a31<\/td><\/span>
\n add1″ value=”Add to Cart”\/><\/span>
\n <\/tr><\/span>
\n <tr><\/span>
\n <td>Banana<\/td><\/span>
\n <td>\u00a31.50<\/td><\/span>
\n add2″ value=”Add to Cart”\/><\/span>
\n <\/tr><\/span>
\n <tr><\/span>
\n <td>Melon<\/td><\/span>
\n <td>\u00a34<\/td><\/span>
\n add3″ value=”Add to Cart”\/><\/span>
\n <\/tr><\/span>
\n <tr><\/span>
\n <td>Orange<\/td><\/span>
\n <td>\u00a30.50<\/td><\/span>
\n add4″ value=”Add to Cart”\/><\/span>
\n <\/tr><\/span>
\n <tr><\/span>
\n <td>Mango<\/td><\/span>
\n <td>\u00a32<\/td><\/span>
\n add5″ value=”Add to Cart”\/><\/span>
\n <\/tr><\/span>
\n<\/table><\/span>
\nform><\/span><\/p>\n
\n $itemid = 1;<\/span>
\n $itemname = ‘an Apple’;<\/span>
\n}elseif(isset($_POST[‘add2’])){<\/span>
\n $itemid = 2;<\/span>
\n $itemname = ‘a Banana’;<\/span>
\n}elseif(isset($_POST[‘add3’])){<\/span>
\n $itemid = 3;<\/span>
\n $itemname = ‘a Melon’;<\/span>
\n}elseif(isset($_POST[‘add4’])){<\/span>
\n $itemid = 4;<\/span>
\n $itemname = ‘an Orange’;<\/span>
\n}elseif(isset($_POST[‘add5’])){<\/span>
\n $itemid = 5;<\/span>
\n $itemname = ‘a Mango’;<\/span>
\n}<\/span><\/p>\n
\n $add_to_cart = mysqli_query($con,”INSERT INTO cart (user_id,item_id) VALUES ($userid,$itemid)”);<\/span>
\n echo “You have added $itemname to your cart!<\/span>
\n“;<\/span>
\n}<\/span><\/p>\n
\n
\n
\n <tr><\/span>
\n <td><b>Name<\/b><\/td><\/span>
\n <td><b>Price<\/b><\/td><\/span><\/p>\n
\n <\/tr><\/span>
\nphp<\/span><\/p>\n
\n echo “You have no items in your cart.”;<\/span>
\n}else{<\/span><\/p>\n
\nwhile($row = mysqli_fetch_array($get_cart)){<\/span>
\n $itemid = $row[‘item_id’];<\/span>
\n $rowid = $row[‘id’];<\/span>
\n IF($itemid == 1){<\/span>
\n $itemname = ‘Apple’;<\/span>
\n $itemprice = 1;<\/span>
\n }elseif($itemid == 2){<\/span>
\n $itemname = ‘Banana’;<\/span>
\n $itemprice = 1.50;<\/span>
\n }elseif($itemid == 3){<\/span>
\n $itemname = ‘Melon’;<\/span>
\n $itemprice = 4;<\/span>
\n }elseif($itemid == 4){<\/span>
\n $itemname = ‘Orange’;<\/span>
\n $itemprice = 0.5;<\/span>
\n }elseif($itemid == 5){<\/span>
\n $itemname = ‘Mango’;<\/span>
\n $itemprice = 2;<\/span>
\n }<\/span>
\n ?><\/span>
\n <tr><\/span>
\n php echo $itemname; ?><\/span>
\n \u00a3php echo $itemprice; ?><\/span>
\n<\/span><\/p>\n