Ecommerce php cart

My problem is when I try to add a product into my cart it only gets 1 type of id always, and quantity doesnt work also. and if i try to add another product into cart it doesnt add

Heres my code

<?php
session_start();
$connect = mysqli_connect("localhost", "root", "", "meian");

$cart = []; // assign an empty array to $cart by default
if(isset($_SESSION["cart"])) { // IF there is cart data in the session THEN ...
    $cart = $_SESSION["cart"]; // load complete cart data from session
}
// From here we know for sure that we have an existing $cart variable and that it is an array!

$product_id = 0;
if(isset($_GET["id"])) {
    $product_id =  (int) $_GET["id"]; // id of the product to add or delete
}
// From here we know for sure that we have an existing $product_id variable and that it is a integer!

// add or update a product to the cart
if(isset($_POST["add"]))
{
    // now get the trustable data like prices from the database and not from the POST array
    $result = mysqli_query($connect, "SELECT id, pname, image, price FROM product2 WHERE id=1" . $product_id);
    if($result === false) {
        die('query is not valid');
    }

    $product = mysqli_fetch_assoc($result); // the product data that we need
    if($product === null) {
        die('no product found with id ' . $product_id);
    }

    // add or update product to cart
    $cart[$product_id] = array(
            'product_id' => $product_id,
            'item_name' => $product["pname"], // get name from the database so that users cannot mess with it
            'product_price' => $product["price"],   // get price from the database so that users cannot mess with the prices either
            'item_quantity' => $_POST["quantity"]
    );

    // save cart to session
    $_SESSION['cart'] = $cart;

    // redirect
    header('Location: shop.php');
    exit;
}

// remove a product from the cart
if(isset($_GET["action"]) && $_GET["action"] == "delete")
{
    unset($cart[$product_id]);

    // save cart to session
    $_SESSION['cart'] = $cart;

    // redirect
    header('Location: shop.php');
    exit;
}

?>



<!DOCTYPE html>
<html lang="en">
  <head>
    <title>Shop</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <link href="https://fonts.googleapis.com/css?family=Poppins:200,300,400,500,600,700,800&display=swap" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Lora:400,400i,700,700i&display=swap" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Amatic+SC:400,700&display=swap" rel="stylesheet">

    <link rel="stylesheet" href="css/open-iconic-bootstrap.min.css">
    <link rel="stylesheet" href="css/animate.css">

    <link rel="stylesheet" href="css/owl.carousel.min.css">
    <link rel="stylesheet" href="css/owl.theme.default.min.css">
    <link rel="stylesheet" href="css/magnific-popup.css">

    <link rel="stylesheet" href="css/aos.css">

    <link rel="stylesheet" href="css/ionicons.min.css">

    <link rel="stylesheet" href="css/bootstrap-datepicker.css">
    <link rel="stylesheet" href="css/jquery.timepicker.css">


    <link rel="stylesheet" href="css/flaticon.css">
    <link rel="stylesheet" href="css/icomoon.css">
    <link rel="stylesheet" href="css/style.css">
  </head>
   <body class="goto-here">
		<div class="py-1 bg-primary">
    	<div class="container">
    		<div class="row no-gutters d-flex align-items-start align-items-center px-md-0">
	    		<div class="col-lg-12 d-block">
		    		<div class="row d-flex">
		    			<div class="col-md pr-4 d-flex topper align-items-center">
					    	<div class="icon mr-2 d-flex justify-content-center align-items-center"><span class="icon-phone2"></span></div>
						    <span class="text">+639 876 543 210</span>
					    </div>
					    <div class="col-md pr-4 d-flex topper align-items-center">
					    	<div class="icon mr-2 d-flex justify-content-center align-items-center"><span class="icon-paper-plane"></span></div>
						    <span class="text">[email protected]</span>
					    </div>
					    <div class="col-md-5 pr-4 d-flex topper align-items-center text-lg-right">
						    <span class="text"></span>
					    </div>
				    </div>
			    </div>
		    </div>
		  </div>
    </div>
    <nav class="navbar navbar-expand-lg navbar-dark ftco_navbar bg-dark ftco-navbar-light" id="ftco-navbar">
	    <div class="container">
	      <a class="navbar-brand" href="index.html">MEIAN</a>
	      <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#ftco-nav" aria-controls="ftco-nav" aria-expanded="false" aria-label="Toggle navigation">
	        <span class="oi oi-menu"></span> Menu
	      </button>

	      <div class="collapse navbar-collapse" id="ftco-nav">
	        <ul class="navbar-nav ml-auto">
	          <li class="nav-item active"><a href="index.html" class="nav-link">Home</a></li>
	          <li class="nav-item dropdown">
              <a class="nav-link dropdown-toggle" href="#" id="dropdown04" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Shop</a>
              <div class="dropdown-menu" aria-labelledby="dropdown04">
              	<a class="dropdown-item" href="shop.html">Shop</a>
                <a class="dropdown-item" href="cart.html">Cart</a>
                <a class="dropdown-item" href="checkout.html">Checkout</a>
              </div>
            </li>
	          <li class="nav-item"><a href="about.html" class="nav-link">About</a></li>
	          <li class="nav-item"><a href="contact.html" class="nav-link">Contact</a></li>
	          <li class="nav-item cta cta-colored"><a href="cart.html" class="nav-link"><span class="icon-shopping_cart"></span>[0]</a></li>

	        </ul>
	      </div>
	    </div>
	  </nav>

    <div class="hero-wrap hero-bread" style="background-image: url('images/hehi.gif');">
      <div class="container">
        <div class="row no-gutters slider-text align-items-center justify-content-center">
          <div class="col-md-9 ftco-animate text-center">
          	<p class="breadcrumbs"><span class="mr-2"><a href="index.html">Home</a></span> <span>Products</span></p>
            <h1 class="mb-0 bread">Products</h1>
          </div>
        </div>
      </div>
    </div>

    <section class="ftco-section">
    	<div class="container">
    		<div class="row justify-content-center">
    			<div class="col-md-10 mb-5 text-center">
    				<ul class="product-category">
    					<li><a href="#" class="active">All</a></li>
    					<li><a href="#">Ice-cream</a></li>
    					<li><a href="#">Pastries</a></li>
    					<li><a href="#">Frappé</a></li>
    					<li><a href="#">Coffee</a></li>
    				</ul>
    			</div>
    		</div>

    		<div class="row">
          <?php
         $query = "SELECT * FROM product2 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-6 col-lg-3 ftco-animate">
    				<div class="product">

              <form method="post" action="shop.php?action=add&id=<?php echo $row["id"]; ?>">

    					<class="img-prod"><img src="<?php echo $row["image"]; ?>"  class="img-fluid">
    						<span class="status"></span>
    						<div class="overlay"></div>

    					<div class="text py-3 pb-4 px-3 text-center">
    						<h3><?php echo $row["pname"]; ?></h3>
    						<div class="d-flex">
    							<div class="pricing">
		    						<p class="price"><span class="price-sale">P <?php echo $row["price"]; ?></span></p>
		    					</div>
	    					</div>
	    					<div class="bottom-area d-flex px-3">
	    						<div class="m-auto d-flex">
                    <input type="text" align="center" name="quantity" class="form-control" value="1" size="1">
                    <input type="hidden" name="hidden_name" value="<?php echo $row["pname"]; ?>">
                    <input type="hidden" name="hidden_price" value="<?php echo $row["price"]; ?>">

	    							<input type="submit" name="add"  value="Add to Cart">


    							</div>
    						</div>
    					</div>
    				</div>
    			</div>
        <?php
      }
    }
       ?>

    	</div>
    </section>

	<section class="ftco-section ftco-cart">
				<div class="row">
    			<div class="col-md-12 ftco-animate">
    				<div class="cart-list">
	    				<table class="table">
						    <thead class="thead-primary">
						      <tr class="text-center">
						        <th>&nbsp;</th>
						        <th>&nbsp;</th>
						        <th>Product name</th>
						        <th>Price</th>
						        <th>Quantity</th>
                    <th>Price Detail</th>
                    <th>&nbsp;</th>

						      </tr>
						    </thead>

                <?php
                if(!empty($_SESSION["cart"]))
                {
                  $total = 0;
                  foreach($_SESSION["cart"] as $keys => $values)
                  {
                     ?>

						    <tbody>
						      <tr class="text-center">
						        <td class="product-remove"><a href="shop.php?action=delete&id=<?php echo $values["product_id"]; ?>"><span class="ion-ios-close"></span></a></td>

                  <td class="image-prod"><div class="img" style="background-image:url(images/product-3.jpg);"></div></td>

						        <td class="product-name">
						        	<h3><?php echo $values["item_name"]; ?></h3>
						        </td>

						        <td class="price">P <?php echo $values["product_price"]; ?></td>

						        <td class="quantity">
					             	<?php echo $values["item_quantity"]; ?>
					          </td>

                    <td class="total">P <?php echo number_format($values["item_quantity"] * $values["product_price"], 2); ?></td>





						      </tr>
                  <?php
                }
                 ?>

						    </tbody>
						  </table>
					  </div>
    			</div>

          <?php
          $total = $total * ($values["item_quantity"] * $values["product_price"]);
          }
          ?>



              <div class="col-md-12 d-flex mb-5">
                <div class="cart-detail cart-total p-3 p-md-4">
                  <h3 class="billing-heading mb-4">Cart Total</h3>
                  <hr>
                  <p class="d-flex total-price">
                    <span>Total</span>
                    <span>P <?php echo number_format($total, 2); ?></span>
                  </p>
                </div>
              </div>

    		</div>

    		</div>
			</div>

		</section>


    <section class="ftco-section">
      <div class="container">
        <div class="row justify-content-center">
          <div class="col-xl-7 ftco-animate">
						<form action="#" class="billing-form">
							<h3 class="mb-4 billing-heading">Delivery</h3>
	          	<div class="row align-items-end">
	          		<div class="col-md-6">
	                <div class="form-group">
	                	<label for="firstname">Firt Name</label>
	                  <input type="text" class="form-control" placeholder="">
	                </div>
	              </div>
	              <div class="col-md-6">
	                <div class="form-group">
	                	<label for="lastname">Last Name</label>
	                  <input type="text" class="form-control" placeholder="">
	                </div>
                </div>
                <div class="w-100"></div>
		            <div class="col-md-12">
		            	<div class="form-group">
		            		<label for="country">State / Country</label>
		            		<div class="select-wrap">
		                  <div class="icon"><span class="ion-ios-arrow-down"></span></div>
		                  <select name="" id="" class="form-control">
		                  	<option value="">France</option>
		                    <option value="">Italy</option>
		                    <option value="">Philippines</option>
		                    <option value="">South Korea</option>
		                    <option value="">Hongkong</option>
		                    <option value="">Japan</option>
		                  </select>
		                </div>
		            	</div>
		            </div>
		            <div class="w-100"></div>
		            <div class="col-md-6">
		            	<div class="form-group">
	                	<label for="streetaddress">Street Address</label>
	                  <input type="text" class="form-control" placeholder="House number and street name">
	                </div>
		            </div>
		            <div class="col-md-6">
		            	<div class="form-group">
	                  <input type="text" class="form-control" placeholder="Appartment, suite, unit etc: (optional)">
	                </div>
		            </div>
		            <div class="w-100"></div>
		            <div class="col-md-6">
		            	<div class="form-group">
	                	<label for="towncity">Town / City</label>
	                  <input type="text" class="form-control" placeholder="">
	                </div>
		            </div>
		            <div class="col-md-6">
		            	<div class="form-group">
		            		<label for="postcodezip">Postcode / ZIP *</label>
	                  <input type="text" class="form-control" placeholder="">
	                </div>
		            </div>
		            <div class="w-100"></div>
		            <div class="col-md-6">
	                <div class="form-group">
	                	<label for="phone">Phone</label>
	                  <input type="text" class="form-control" placeholder="">
	                </div>
	              </div>
	              <div class="col-md-6">
	                <div class="form-group">
	                	<label for="emailaddress">Email Address</label>
	                  <input type="text" class="form-control" placeholder="">
	                </div>
                </div>
                <div class="w-100"></div>
                <div class="col-md-12">
                	<div class="form-group mt-4">
									</div>
                </div>
	            </div>
	          </form>
					</div>
					<div class="col-xl-5">
	          <div class="row mt-5 pt-3">
	          	<div class="col-md-12 d-flex mb-5">
	          		<div class="cart-detail cart-total p-3 p-md-4">
	          			<h3 class="billing-heading mb-4">Cart Total</h3>
		    					<hr>
		    					<p class="d-flex total-price">
		    						<span>Total</span>
		    						<span>$17.60</span>
		    					</p>
								</div>
	          	</div>

									<p><a href="#"class="btn btn-primary py-3 px-4">Place an order</a></p>

	          	</div>
	          </div>
          </div>
        </div>
      </div>
    </section>

    <footer class="ftco-footer ftco-section">
      <div class="container">
      	<div class="row">
      		<div class="mouse">
						<a href="#" class="mouse-icon">
							<div class="mouse-wheel"><span class="ion-ios-arrow-up"></span></div>
						</a>
					</div>
      	</div>


            <p>
						  Copyright &copy;<script>document.write(new Date().getFullYear());</script> All rights reserved
						</p>
          </div>
        </div>
      </div>
    </footer>



  <!-- loader -->
  <div id="ftco-loader" class="show fullscreen"><svg class="circular" width="48px" height="48px"><circle class="path-bg" cx="24" cy="24" r="22" fill="none" stroke-width="4" stroke="#eeeeee"/><circle class="path" cx="24" cy="24" r="22" fill="none" stroke-width="4" stroke-miterlimit="10" stroke="#F96D00"/></svg></div>


  <script src="js/jquery.min.js"></script>
  <script src="js/jquery-migrate-3.0.1.min.js"></script>
  <script src="js/popper.min.js"></script>
  <script src="js/bootstrap.min.js"></script>
  <script src="js/jquery.easing.1.3.js"></script>
  <script src="js/jquery.waypoints.min.js"></script>
  <script src="js/jquery.stellar.min.js"></script>
  <script src="js/owl.carousel.min.js"></script>
  <script src="js/jquery.magnific-popup.min.js"></script>
  <script src="js/aos.js"></script>
  <script src="js/jquery.animateNumber.min.js"></script>
  <script src="js/bootstrap-datepicker.js"></script>
  <script src="js/scrollax.min.js"></script>
  <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBVWaKrjvy3MaE7SQ74_uJiULgl1JY0H2s&sensor=false"></script>
  <script src="js/google-map.js"></script>
  <script src="js/main.js"></script>

  </body>
</html>

A post was merged into an existing topic: E-commerce php website help!

Sponsor our Newsletter | Privacy Policy | Terms of Service