Home Web Development PHP PHP Shopping Cart | Add to Cart Feature In PHP & MySQL

PHP Shopping Cart | Add to Cart Feature In PHP & MySQL

April 16, 2019

86069

Today I going to share the PHP shopping cart program. In other words, add to cart feature in PHP and MySQL. You had seen add to cart feature in very big and well-known e-commerce platform like Amazon, Flipkart, etc. Basically, the cart button creates a list of products, that you want to buy. Cart program is full of calculation in the backend.

Today I am sharing a simple PHP shopping cart program example and source code. After visit this post, you will able to create add to cart feature in PHP & MySQL. This program is very simple, but it looks pretty good. Because of this program’s structure is built-in bootstrap. I used bootstrap for an attractive and responsive look.

In this add to cart program, I did not use the separate CSS file, I put some in-line CSS. So, There is Just one file and folder for store images. MySQL fetches images from the image folder. One thing I want to explain: MySQL doesn’t store images in the database, SQL store only image name in the database. That’s why you have to create a folder to store images.

Preview Of This Add To Cart Program

First, see this preview of the program. If you like, then to go for source code.

So, this is the preview. I think this program looks not bad. For beginners, this program will be very informative. Because If you do search for this program most of will in any PHP framework. That will be difficult to understand. Now time to share code.

PHP Shopping Cart Programs Source Code

As always, Before sharing source code I want to say about this program. For this program, I used PHP, MySQL, and Bootstrap. create a database is very important, without the database this program is a dummy. MySQL create this program dynamic. In the database, we will store the product name, ID, product price, & product image path.

You have to do 3 things: Create a database named ‘cart‘, create an ‘index.php‘ file, and the final thing create a folder and store product images.

Create Images Folder

Create a folder named ‘images‘ and put all your products images there. This is a very important thing in this program. And rename all images with simple names like ‘1jpg’ or ‘product1.jpg’. because of these types of simple names is easy to put in MySQL database. Otherwise, if your images have a long name that’s will be difficult to remember names, then you have to copy and paste names.

Create Database

Create a database named ‘cart’ because in MySQL connection I had put database name cart. If you create a database with another name you also have to change the database name in PHP file. After successfully creating database go to SQL command section and put these codes given below.

CREATE TABLE `tbl_product` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `price` double(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `tbl_product` (

`id` int(11) NOT NULL,

`name` varchar(255) NOT NULL,

`image` varchar(255) NOT NULL,

`price` double(10,2) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

This code will create a table with required fields. Now you can insert new products in your database. For add products, go to your database located in PhpMyAdmin, and go to insert section. Now there you can add products by giving their products info like ID, name, price & image name.

Create PHP File

Now you have to create a PHP file named ‘index.php’ or any name for giving life to this program. After creating file put these codes given here below.

<?php 
/* code by webdevtrick ( https://webdevtrick.com ) */
session_start();
$connect = mysqli_connect("localhost", "root", "", "cart");

if(isset($_POST["add_to_cart"]))
{
	if(isset($_SESSION["shopping_cart"]))
	{
		$item_array_id = array_column($_SESSION["shopping_cart"], "item_id");
		if(!in_array($_GET["id"], $item_array_id))
		{
			$count = count($_SESSION["shopping_cart"]);
			$item_array = array(
				'item_id'			=>	$_GET["id"],
				'item_name'			=>	$_POST["hidden_name"],
				'item_price'		=>	$_POST["hidden_price"],
				'item_quantity'		=>	$_POST["quantity"]
			);
			$_SESSION["shopping_cart"][$count] = $item_array;
		}
		else
		{
			echo '<script>alert("Item Already Added")</script>';
		}
	}
	else
	{
		$item_array = array(
			'item_id'			=>	$_GET["id"],
			'item_name'			=>	$_POST["hidden_name"],
			'item_price'		=>	$_POST["hidden_price"],
			'item_quantity'		=>	$_POST["quantity"]
		);
		$_SESSION["shopping_cart"][0] = $item_array;
	}
}

if(isset($_GET["action"]))
{
	if($_GET["action"] == "delete")
	{
		foreach($_SESSION["shopping_cart"] as $keys => $values)
		{
			if($values["item_id"] == $_GET["id"])
			{
				unset($_SESSION["shopping_cart"][$keys]);
				echo '<script>alert("Item Removed")</script>';
				echo '<script>window.location="index.php"</script>';
			}
		}
	}
}

?>
<!DOCTYPE html>
<html>
	<head>
		<title>Shopping Cart In PHP and MySql | Webdevtrick.com</title>
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
		<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
		<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
	</head>
	<body>
		<br />
		<div class="container">
			<br />
			<br />
			<br />
			<h3 align="center">Shoping Cart With PHP And MySql | Source Code By <a href="https://webdevtrick.com">Webdevtrick.com</a></h3><br />
			<br /><br />
			<?php
				$query = "SELECT * FROM tbl_product ORDER BY id ASC";
				$result = mysqli_query($connect, $query);
				if(mysqli_num_rows($result) > 0)
				{
					while($row = mysqli_fetch_array($result))
					{
				?>
			<div class="col-md-4">
				<form method="post" action="index.php?action=add&id=<?php echo $row["id"]; ?>">
					<div style="border:3px solid #5cb85c; background-color:whitesmoke; border-radius:5px; padding:16px;" align="center">
						<img src="images/<?php echo $row["image"]; ?>" class="img-responsive" /><br />

						<h4 class="text-info"><?php echo $row["name"]; ?></h4>

						<h4 class="text-danger">$ <?php echo $row["price"]; ?></h4>

						<input type="text" name="quantity" value="1" class="form-control" />

						<input type="hidden" name="hidden_name" value="<?php echo $row["name"]; ?>" />

						<input type="hidden" name="hidden_price" value="<?php echo $row["price"]; ?>" />

						<input type="submit" name="add_to_cart" style="margin-top:5px;" class="btn btn-success" value="Add to Cart" />

					</div>
				</form>
			</div>
			<?php
					}
				}
			?>
			<div style="clear:both"></div>
			<br />
			<h3>Order Details</h3>
			<div class="table-responsive">
				<table class="table table-bordered">
					<tr>
						<th width="40%">Item Name</th>
						<th width="10%">Quantity</th>
						<th width="20%">Price</th>
						<th width="15%">Total</th>
						<th width="5%">Action</th>
					</tr>
					<?php
					if(!empty($_SESSION["shopping_cart"]))
					{
						$total = 0;
						foreach($_SESSION["shopping_cart"] as $keys => $values)
						{
					?>
					<tr>
						<td><?php echo $values["item_name"]; ?></td>
						<td><?php echo $values["item_quantity"]; ?></td>
						<td>$ <?php echo $values["item_price"]; ?></td>
						<td>$ <?php echo number_format($values["item_quantity"] * $values["item_price"], 2);?></td>
						<td><a href="index.php?action=delete&id=<?php echo $values["item_id"]; ?>"><span class="text-danger">Remove</span></a></td>
					</tr>
					<?php
							$total = $total + ($values["item_quantity"] * $values["item_price"]);
						}
					?>
					<tr>
						<td colspan="3" align="right">Total</td>
						<td align="right">$ <?php echo number_format($total, 2); ?></td>
						<td></td>
					</tr>
					<?php
					}
					?>
						
				</table>
			</div>
		</div>
	</div>
	<br />
	</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

<?php

/* code by webdevtrick ( https://webdevtrick.com ) */

session_start();

$connect = mysqli_connect("localhost", "root", "", "cart");

if(isset($_POST["add_to_cart"]))

{

if(isset($_SESSION["shopping_cart"]))

{

$item_array_id = array_column($_SESSION["shopping_cart"], "item_id");

if(!in_array($_GET["id"], $item_array_id))

{

$count = count($_SESSION["shopping_cart"]);

$item_array = array(

'item_id' => $_GET["id"],

'item_name' => $_POST["hidden_name"],

'item_price' => $_POST["hidden_price"],

'item_quantity' => $_POST["quantity"]

);

$_SESSION["shopping_cart"][$count] = $item_array;

}

else

{

echo '<script>alert("Item Already Added")</script>';

}

else

{

$item_array = array(

'item_id' => $_GET["id"],

'item_name' => $_POST["hidden_name"],

'item_price' => $_POST["hidden_price"],

'item_quantity' => $_POST["quantity"]

);

$_SESSION["shopping_cart"][0] = $item_array;

}

if(isset($_GET["action"]))

{

if($_GET["action"] == "delete")

{

foreach($_SESSION["shopping_cart"] as $keys => $values)

{

if($values["item_id"] == $_GET["id"])

{

unset($_SESSION["shopping_cart"][$keys]);

echo '<script>alert("Item Removed")</script>';

echo '<script>window.location="index.php"</script>';

}

<!DOCTYPE html>

<html>

<head>

<title>Shopping Cart In PHP and MySql | Webdevtrick.com</title>

</head>

<body>

<br />

<br />

<h3 align="center">Shoping Cart With PHP And MySql | Source Code By <a href="https://webdevtrick.com">Webdevtrick.com</a></h3><br />

<?php

$query = "SELECT * FROM tbl_product ORDER BY id ASC";

$result = mysqli_query($connect, $query);

if(mysqli_num_rows($result) > 0)

{

while($row = mysqli_fetch_array($result))

{

<img src="images/<?php echo $row["image"]; ?>" class="img-responsive" /><br />

</div>

</form>

</div>

<?php

}

<br />

<h3>Order Details</h3>

<tr>

<th width="10%">Quantity</th>

<th width="20%">Price</th>

<th width="15%">Total</th>

<th width="5%">Action</th>

</tr>

<?php

if(!empty($_SESSION["shopping_cart"]))

{

$total = 0;

foreach($_SESSION["shopping_cart"] as $keys => $values)

{

<tr>

<td><a href="index.php?action=delete&id=<?php echo $values["item_id"]; ?>"><span class="text-danger">Remove</span></a></td>

</tr>

<?php

$total = $total + ($values["item_quantity"] * $values["item_price"]);

}

<tr>

<td colspan="3" align="right">Total</td>

</tr>

<?php

}

</table>

</div>

<br />

</body>

</html>

That’s It. Now You have successfully created a shopping cart program in PHP. I know this process is a little bit difficult for beginners If you don’t understand how will create the complete program. Don’t worry I am giving you full source code file in ZIP format.

Download Source Code

ZIP Password: webdevtrick.com

I hope you like this post. If you have any doubt or question comment down below. I will reply you as soon as possible.

Thanks For Visiting, Keep Visiting.

22 COMMENTS

Aryan May 12, 2019 At 4:54 am

Good

Reply
- shaan May 12, 2019 At 4:54 am
  
  Thank you, Stay Connected.
  
  Reply
walter blent July 20, 2019 At 12:06 pm

Very helpful. Is there anything to link this program to a checkout

Reply
- shaan July 20, 2019 At 12:24 pm
  
  thank you
  
  Reply
kismet July 23, 2019 At 11:34 am

how can i add those cart detain in another table??

Reply
developer August 5, 2019 At 7:16 am

how can we store price in hidden filed..if someone change it then how can we handle this

Reply
rahul August 16, 2019 At 7:01 am

where is $_SESSION[“shopping_cart”] came from?

Reply
kudzai August 18, 2019 At 12:18 pm

I want the user to be able to pay using paypal or credit card

Reply
- shaan August 18, 2019 At 4:26 pm
  
  set payment gateway
  
  Reply
- Razu August 18, 2020 At 10:29 am
  
  Dear Sir,
  I need to show products in drop down list and into the list add-to-cart button is it possible? I became very grateful to you if possible to do this….. Thanks
  
  Reply
Min Banyar Arrmahn September 7, 2019 At 6:39 pm

Please, would you give me zip password? I’m still learning about this. (webdevtrick.com) that doesn’t work as a password to fill.
Thanks alot

Reply
LUSAATA DENIS September 20, 2019 At 8:59 am

Hello,
Am facing this error.
Fatal error: Call to undefined function array_column() in C:\wamp\www\shopping-cart-php\index.php on line 7

Reply
nikhil nirvan October 11, 2019 At 8:17 am

while adding a button for payment gateway
Warning: Cannot modify header information – headers already sent by (output started at C:\xampp\htdocs\website\afterlogin\carts.php:83) in C:\xampp\htdocs\website\afterlogin\carts.php on line 147

Reply
Collins Tanki October 28, 2019 At 4:23 pm

Requesting for the the zip password the latter isn’t working .Thank you.

Reply
robinson February 16, 2020 At 1:59 pm

thanks sir. please you can do also a tutoial on inserting the data rom shopping cart to a database

Reply
Jordan Humberto de Souza May 19, 2020 At 12:33 pm

I have updated all your code, SQL needed some adjustments also. Anyways, ty for it!

Updated version on my git:
https://github.com/SHJordan/shopping-cart-php

Reply
zak December 12, 2020 At 9:35 am

Thank u very much bro I appreciate you work good job..

Reply
Kishan December 24, 2020 At 3:45 pm

Its good that you shared the source code. Some people would charge for that also. But beginners like us, know the value of this code when shared for free. And we are grateful for that.

Reply
sanjay May 28, 2021 At 1:21 pm

How can I change those currency dollor($) to INR? pls help!

Reply
Mani June 23, 2021 At 6:18 am

very helpful article

Reply
Irvan Rifa'i March 25, 2022 At 1:57 am

Thankyou, that’s very helpful

Reply
Claus April 5, 2022 At 11:50 am

I get an issue: I add some items to my cart. I then delete of of those addede items. It updates the cart correctly. BUT – if I try to add another/a new item to the cart it doesn’t get added correctly – in stead it replaces one of the original items in the cart?! Does anyone experience the same – and have a fix? Highly appreciated!

Reply