1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / qarkt.com /
Filename : action.php
back
<?php
ob_start();
session_start();
include "../config/qaconfig.php";
include "includes/functions.php";
$ip_add=getenv("REMOTE_ADDR");

if (isset($_SESSION['userid'])) {
  $uid = $_SESSION['userid'];

  // Prepare SQL statement to avoid SQL injection
  $stmt = $con->prepare("SELECT * FROM `user_info` WHERE `user_id` = ?");
  $stmt->bind_param('i', $uid); // Bind parameter as integer
  $stmt->execute();
  $result = $stmt->get_result();
  $row = $result->fetch_assoc();
  $first_name = $row['first_name'];
  $currency = $row['currency'];
  $stmt->close();
} else {
  // Default currency if user session is not set
  $currency = '£';
}

// Fallback to pounds if currency is not set or empty
if (empty($currency)) {
  $currency = '£';
}

if(isset($_POST['category'])){

    $cat_query="SELECT * FROM categories";
    $result=mysqli_query($con,$cat_query);
    

    echo " 		  
             ";
    if(mysqli_num_rows($result)>0){
     while ($row=mysqli_fetch_array($result)) {
       // print_r($row);

       $cat_id=$row['cat_id'];
       $cat_name=$row['cat_title'];

       echo   "
              
              <a class='category' href='#' cid='$cat_id'> 
						<li>
              <span class='span'>$cat_name</span>
              </li>
						</a>
              
              ";
             
            
              
            
           
        }   
        
    }
    echo "";

}//end of isset($_POST['category']--in HTML 5 U CAN SPECIFY UR QWN ATTRIBUTE LIKE E.G cid here...cid='$cat_id';

if(isset($_POST['brand'])){
  $brand_query="SELECT * FROM brands";
  $result=mysqli_query($con,$brand_query);

     echo "<ul class='standard_dropdown main_nav_dropdown'>";

  if(mysqli_num_rows($result)>0){
      while($row=mysqli_fetch_array($result)){
          $brand_id=$row['brand_id'];
          $brand_name=$row['brand_title'];
          echo "
         
          <li>
          <a class='' href='#' bid='$brand_id'>    $brand_name</a>
                </li>
                "
                ;
      }
     }//end of if
     echo "<ul>";
}//end of  isset($_POST['brand']

//-------------pagination starts here-------------------
if(isset($_POST['page'])){
  $sql="SELECT * FROM products";
  $result=mysqli_query($con,$sql);
  //follow line will give num of rows of products table.
  $count=mysqli_num_rows($result);
 
// echo $count;
//echo "<br/>";
//we want to show 9 products on a page so we will devide it by 9.so we will get no of pages we required to show our all productts.
//ceil function will convert float  value into integer
$pageno=ceil($count/9);
//echo $pageno;
//pago no will be 6 ...means we required 6 pages to show our products

for($i=1;$i<=$pageno;$i++){
 echo
         "<li class='page-item' >
         <a class='page-link' id='page' page='$i' href='#'>$i</a>
         </li>";
}

}//end of isset page-----------it just will give no of pages 

if(isset($_POST['products'])){

  $limit=100;

  if(isset($_POST['setpage'])){
    $pageno=$_POST['pageno'];
    $start=($pageno*$limit) - $limit;
  }else{
    $start=0;
  }
  $product_query="SELECT * FROM products  LIMIT $start,$limit"  ;
  $result=mysqli_query($con,$product_query);

echo "					";

  if(mysqli_num_rows($result)>0){
    while($row=mysqli_fetch_assoc($result)){

      $product_id=$row['product_id'];
      $product_cat_id=$row['product_cat_id'];
      $product_brand_id=$row['product_brand_id'];
      $product_title=$row['product_title'];
      $product_price=$row['product_price'];
      $product_desc=$row['product_desc'];
      $product_image=$row['product_image'];
      $product_keywords=$row['product_keywords'];

      echo "             
            <button class='product_cart_button'  pid='$product_id' id='product'>Buy Now</button>
      
				
    

      ";
    }
  }

  echo "";
}//end of isset($_POST['products'])



if(isset($_POST['get_selected_category'])){
  $cid=$_POST['cat_id'];

  $selected_product_query="SELECT * FROM products WHERE product_cat_id= '$cid'";
  $result=mysqli_query($con,$selected_product_query);

  echo "";
  if(mysqli_num_rows($result)>0){
    while($row=mysqli_fetch_array($result)){

      $product_id=$row['product_id'];
      $product_cat_id=$row['product_cat_id'];
      $product_brand_id=$row['product_brand_id'];
      $product_title=$row['product_title'];
      $product_price=$row['product_price'];
      $product_desc=$row['product_desc'];
      $product_image=$row['product_image'];
      $product_keywords=$row['product_keywords'];

      echo "
     
      <div class='product-wrapper'>
      <div class='product-top'>
      <img src='admin/uploads/$product_image' alt='' >
      </div>
          <div class='product-bottom'>
  <h2>$product_title</h2>
  <p>$currency$product_price</p>
  <button class='button btn cart-btn ' pid='$product_id' id='product''>Buy Now</button>
          </div>
  </div>

      ";


    }
  }

}//end of isset($_POST['get_selected_category'])

if(isset($_POST['get_selected_brand'])){
  $bid=$_POST['brand_id'];

  $selected_product_query="SELECT * FROM products WHERE product_brand_id= '$bid'";
  $result=mysqli_query($con,$selected_product_query);

  echo "";
  if(mysqli_num_rows($result)>0){
    while($row=mysqli_fetch_array($result)){

      $product_id=$row['product_id'];
      $product_cat_id=$row['product_cat_id'];
      $product_brand_id=$row['product_brand_id'];
      $product_title=$row['product_title'];
      $product_price=$row['product_price'];
      $product_desc=$row['product_desc'];
      $product_image=$row['product_image'];
      $product_keywords=$row['product_keywords'];

      echo "
      <div class='product-wrapper'>
      <div class='product-top'>
      <img src='admin/uploads/$product_image' alt='' >
      </div>
          <div class='product-bottom'>
  <h2>$product_title</h2>
  <p>$currency$product_price</p>
  <button class='button btn cart-btn ' pid='$product_id' id='product''>Buy Now</button>
          </div>
  </div>

      ";

    }
  }

}//end of isset($_POST['get_selected_brand'])


//-----------------query for search functionality---------------------------------------

if(isset($_POST['search'])){
  $searchword=$_POST['searchword'];

  $selected_product_query="SELECT * FROM products WHERE product_keywords LIKE '%$searchword%'";
  $result=mysqli_query($con,$selected_product_query);

  echo "<div class='row'>";
  if(mysqli_num_rows($result)>0){
    while($row=mysqli_fetch_array($result)){

      $product_id=$row['product_id'];
      $product_cat_id=$row['product_cat_id'];
      $product_brand_id=$row['product_brand_id'];
      $product_title=$row['product_title'];
      $product_price=$row['product_price'];
      $product_desc=$row['product_desc'];
      $product_image=$row['product_image'];
      $product_keywords=$row['product_keywords'];

      echo "
      <div class='col-md-6 col-lg-4' style='padding: 1%;'>
                           <div class='card'>
                               <div class='card-header'>$product_title</div>
                               <div class='card-body'>
                                   <img src='img/$product_image' class='card-img img-fluid' style='width:auto; height:40vh;'
                                    alt='$product_title'>
                               </div>
                               <div class='card-footer'>$currency$product_price/-
                                <button class='btn btn-danger btn-sm' pid='$product_id' id='product' style='float: right;'>Buy Now</button>
                               </div>
                           </div>
                       </div>
      ";

    }
  }

}//end of isset($_POST['search'])


//----------------------------------Buy Now code starts here-------------------------------
if(isset($_POST['addtoproduct'])){

  if(isset($_SESSION['userid'])){
/*====================if user is logged in then we will add product into cart with user_id and user ip_address=====================*/
   $p_id = $_POST['productid'];
   $user_id=$_SESSION['userid'];
  
   $sql="SELECT * FROM cart WHERE p_id='$p_id' AND user_id='$user_id'";
   $result=mysqli_query($con,$sql);
   if(mysqli_num_rows($result)>0){
     
     echo "<div class='alert alert-danger' role='alert'>
     Item already added to cart!
         <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
           <span aria-hidden='true'>&times;</span>
         </button>
     </div>";

   }else{

    $sql1="SELECT * FROM products WHERE product_id='$p_id'";
    $result1=mysqli_query($con,$sql1);
    if(mysqli_num_rows($result1)>0){
      $row=mysqli_fetch_array($result1);

      $pro_id = $row['product_id'];
      $pro_title= $row['product_title'];
      $pro_image= $row['product_image'];
      $pro_price= $row['product_price'];

    $sql2="INSERT INTO `cart`(`p_id`, `ip_add`, `user_id`, `product_title`, `product_image`, `qty`, `price`, `total_amount`)
    VALUES ('$pro_id','$ip_add','$user_id','$pro_title','$pro_image',1,'$pro_price','$pro_price')";

    $result2=mysqli_query($con,$sql2);
    if($result2){
         
         echo "<div class='alert alert-success' role='alert'>
         $pro_title has been  added to cart
        <button type='button' class='close-custom close-custom-success' data-dismiss='alert' aria-label='Close'>
               <span aria-hidden='true'>&times;</span>
        </button>
      </div>";
        }
    }
   }
  }//if (isset($_SESSION['userid'])) ends
  else{
 /*====================if user is not logged in then we will add product into cart with user ip address,AND with user_id=-1=====================*/
            $p_id = $_POST['productid'];
            
            //$sql = "SELECT id FROM cart WHERE ip_add = '$ip_add' AND p_id = '$p_id' AND user_id = -1";
            $sql="SELECT * FROM cart WHERE p_id='$p_id' AND ip_add= '$ip_add' AND user_id = -1";
            $result=mysqli_query($con,$sql);
            if(mysqli_num_rows($result)>0){
              
              echo "<div class='alert alert-danger' role='alert'>
              Item already added to cart!
              <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                    <span aria-hidden='true'>&times;</span>
                  </button>
              </div>";
              exit();

 }else{
        $sql1="SELECT * FROM products WHERE product_id='$p_id'";
        $result1=mysqli_query($con,$sql1);
        if(mysqli_num_rows($result1)>0){
          $row=mysqli_fetch_array($result1);

          $pro_id = $row['product_id'];
          $pro_title= $row['product_title'];
          $pro_image= $row['product_image'];
          $pro_price= $row['product_price'];

        $sql2="INSERT INTO `cart`(`p_id`, `ip_add`, `user_id`, `product_title`, `product_image`, `qty`, `price`, `total_amount`)
        VALUES ('$pro_id','$ip_add',-1,'$pro_title','$pro_image',1,'$pro_price','$pro_price')";

        $result2=mysqli_query($con,$sql2);
        if($result2){
            
            echo "<div class='alert alert-success' role='alert'>
            $pro_title has been  added to cart
            <button type='button' class='close-custom' data-dismiss='alert' aria-label='Close'>
                  <span aria-hidden='true'>&times;</span>
            </button>
          </div>";
            }
        }
        
 }
   
  }//end of else
}//if(isset($_POST['addtoproduct'])) ends


//----------------------------------Buy Now code ends here-------------------------------





//----------------------------------get cart products on profile page & index page cart container-dropdown starts-------------------------------
if(isset($_POST['get_cart_products'])){
  if(isset($_SESSION['userid'])){
    $user_id=$_SESSION['userid'];

    $sql="SELECT * FROM cart WHERE user_id='$user_id'  ";
    $result=mysqli_query($con,$sql);
    if(mysqli_num_rows($result)>0){
      $no=1;
      $total_amt=0;
          while($row=mysqli_fetch_array($result)){

            $pro_id=$row['p_id'];
            $pro_title=$row['product_title'];
            $pro_image=$row['product_image'];
            $pro_price=$row['price'];
            $pro_qty=$row['qty'];

            $price_array=array($pro_price);
            $total_sum=array_sum($price_array);
            $total_amt=$total_amt + $total_sum;


        echo "
            
        
        <div class='product'  >
        <div class='product-cart-details'>
            <h4 class='product-title'>
                <a href='product.php?id=$pro_id''>$pro_title</a>
            </h4>

            <span class='cart-product-info'>
                <span class='cart-product-qty'>$no</span>
                $$pro_price
            </span>
        </div>

        <figure class='product-image-container'> 
            <a  href='product.php?id=$pro_id'>
            <img src='admin/uploads/$pro_image' alt='$pro_title' title='' />
          </a>
        </figure>
        <a href='#' class='btn-remove' title='Remove Product'>$no</a>
        </div>
     
             ";

      $no=$no+1;
      }
      echo "
      <div class='dropdown-cart-total'>
      <span>Total</span>
  
      <span class='cart-total-price'>$$total_amt</span>
  </div>
  <div class='dropdown-cart-action'>
  <a href='cart.php' class='btn btn-primary'>View Cart</a>
  <a href='cart.php' class='btn btn-outline-primary-2'><span>Checkout</span><i class='icon-long-arrow-right'></i></a>
  </div>
    ";
    }else{
      echo "<div class='total' role='alert'>
      Your Cart is Empty
      </div>";
    }
  }else{
//if user is not logged in then we will do it with help of ip_address
        $sql="SELECT * FROM cart WHERE user_id= -1 AND ip_add='$ip_add'";
        $result=mysqli_query($con,$sql);
        if(mysqli_num_rows($result)>0){
          $no=1;
          $total_amt=0;
          while($row=mysqli_fetch_array($result)){

            $pro_id=$row['p_id'];
            $pro_title=$row['product_title'];
            $pro_image=$row['product_image'];
            $pro_price=$row['price'];
            $pro_qty=$row['qty'];

            $price_array=array($pro_price);
            $total_sum=array_sum($price_array);
            $total_amt=$total_amt + $total_sum;

            echo "
            
            <div class='product'  >
            <div class='product-cart-details'>
                <h4 class='product-title'>
                    <a href='product.php?id=$pro_id''>$pro_title</a>
                </h4>
    
                <span class='cart-product-info'>
                    $currency$pro_price
                </span>
            </div>
    
            <figure class='product-image-container'> 
                <a  href='product.php?id=$pro_id'>
                <img src='admin/uploads/$pro_image' alt='$pro_title' title='' />
              </a>
            </figure>
            <a href='#' class='btn-remove' title='Remove Product'>$no</a>
        </div>
          
            ";

          $no=$no+1;    
    }
    echo "
    <div class='dropdown-cart-total'>
    <span>Total</span>

    <span class='cart-total-price'>$currency$total_amt</span>
</div>
<div class='dropdown-cart-action'>
<a href='cart.php' class='btn btn-primary'>View Cart</a>
<a href='cart.php' class='btn btn-outline-primary-2'><span>Checkout</span><i class='icon-long-arrow-right'></i></a>
</div>
    ";

    }else{
      echo "<div class='total' role='alert'>
      Your Cart is Empty
      </div>";
    }
  }

}
//------------------------------------get cart products on profile page & index page cart container-dropdown ends----------------------------------

//-------------------get cart count on profile page &index page container starts here--------------------------

if(isset($_POST['cart_count'])){
  if(isset($_SESSION['userid'])){
       $user_id=$_SESSION['userid'];
 
       $sql="SELECT * FROM cart WHERE user_id='$user_id'";
       $result=mysqli_query($con,$sql);
       $count=mysqli_num_rows($result);
       echo $count;
     }else{
       //if user is not logged in then we will do it with help of ip_address
       $sql="SELECT * FROM cart WHERE user_id= -1 AND ip_add='$ip_add'";
       $result=mysqli_query($con,$sql);
       $count=mysqli_num_rows($result);
       echo $count;
     }
 }

//-------------------get cart count on profile page &index page container ends here--------------------------
//-----------------------------------|| cart.php-cart page starts here-----------------------------------------
if (isset($_POST['get_cart_products_list'])) {
  if (isset($_SESSION['userid'])) {
      $uid = $_SESSION['userid'];
      $sql = "SELECT c.*, p.shipping_distance, p.currency, p.shipping_weight, p.shipping_country, p.vehicle_price, p.free_shipping, u.country 
              FROM cart c
              LEFT JOIN products p ON c.p_id = p.product_id
              LEFT JOIN user_info u ON c.user_id = u.user_id
              WHERE c.user_id='$uid'";
  } else {
      $sql = "SELECT c.*, p.shipping_distance,p.currency, p.shipping_weight, p.shipping_country, p.vehicle_price, p.free_shipping 
              FROM cart c
              LEFT JOIN products p ON c.p_id = p.product_id
              WHERE c.user_id=-1 AND c.ip_add='$ip_add'";
  }
  $result = mysqli_query($con, $sql);

    if (mysqli_num_rows($result) > 0) {
        echo "<div class='row'>
            <div class='col-lg-12'> 
                <form method='post' action='login_form.php' class='cart style2'>
                    <table class='table table-cart table-mobile'>
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Price($currency)</th>
                                <th>Quantity</th>
                                <th>Total</th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody>";
        $total_amt = 0;
        while ($row = mysqli_fetch_array($result)) {
            $pid = $row['p_id'];
            $pro_title = $row['product_title'];
            $pro_image = $row['product_image'];
            $pro_qty = $row['qty'];
            $pro_price = $row['price'];
            $pro_total = $row['total_amount'];
            $cart_item_id = $row["id"];
            $shipping_distance = $row['shipping_distance'];
            $shipping_weight = $row['shipping_weight'];
            $shipping_country = $row['shipping_country'];
            $vehicle_price = $row['vehicle_price'];
            $free_shipping = $row['free_shipping'];

            $product_currency=$row['currency'];

          if (!empty($product_currency)) {
              $currency = $product_currency;
          }

            $shipping = 0; // Initialize $shipping variable
            if (isset($uid)) {
            $user_country = $row['country'];
      
            // Calculate shipping cost based on the user's country and other parameters
            $shipping_fee = calculateShippingFee($user_country, $shipping_distance, $shipping_weight, $vehicle_price,$shipping_country);

            //Total shipping fee
            $shipping += $shipping_fee;
            }else{
              $shipping = 0;
            }
            $price_array = array($pro_total);
            $total_sum = array_sum($price_array);
            $total_amt = $total_amt + $total_sum;
            $sum_total = $total_amt + $shipping;

            // Set cookie for total amount
            setcookie("ta", $total_amt, strtotime("+1 Day"), "/", "", "", TRUE);

  echo "

  <!--follow two items we will fetch at login_form.php page -->
  <input type='hidden' name='pid[]' value=$pid/>
  <input type='hidden' name='' value=$cart_item_id/>
  <tr>
                  <td class='product-col'>
                  <div class='product'>
													<figure class='product-media'>
														<a href='#'>
															<img src='admin/uploads/$pro_image' alt='Product image'>
														</a>
													</figure>
													<h3 class='product-title'>
														<a href='product.php?id=$pid'>$pro_title</a>
													</h3>
												</div>
                  </td>

                  <td
                    class='price-col'
                    data-title='Price'
                  >
                  <input type='text' class='form-control input-number__input' style='background:#fff;border:0px;color:#000000;'
                  price' pid='$pid' id='price-$pid' value='$pro_price' disabled>
                  </td>
                  <td
                    class='quantity-col'
                    data-title='Quantity'
                  >
                    <div class='input-number'>

                      <input type='number' 
                      min='1' 
                      class='form-control input-number__input qty'
                       pid='$pid'  id='qty-$pid' value='$pro_qty' 
                       style='width:50%;margin-left:0%'>
                    </div>
                  </td>
                  <td class='total-col'>
                  <div pid='$pid'  id='total-$pid'> $currency$pro_total</div>
                  </td>
                  <td class='remove-col'>
                    <button
                      type='button' pid_remove_item='$pid' id='remove_item'
                      class='btn-remove'
                    >
                    <i class='fa fa-trash'></i>
                    </button>
                    <button
                      type='button' pid_update_item='$pid' id='update_item'
                      class='btn-remove'
                    >
                   <i class='fa fa-check-square'></i>
                    </button>
                  </td>




                    
                </tr>         
";
    }
    echo "
    </tbody>
    </table>

    <aside class='col-lg-6'>
    <div class='summary summary-cart'>
        <h3 class='summary-title'>Cart Total</h3>

        <table class='table table-summary'>
        <tbody>
        <tr class='summary-subtotal'>
            <td>Subtotal:</td>
            <td>$currency$total_amt</td>
        </tr>";
        if(isset($_SESSION['userid'])) {
            echo "
            <tr class='summary-shipping'>
                <td>Delivery:</td>
                <td>$currency$shipping</td>
            </tr>
            <tr class='summary-total'>
            <td>Total:</td>
            <td>$currency$sum_total</td>
        </tr>
            ";
        }
        echo "
       
    </tbody>
        </table>

      
           
            ";
          
            ?>
        <?php
          function randString($length, $charset='ABCDE0123456789')
          {
                                  $str = '';
                                  $count = strlen($charset);
                                  while ($length--) {
                                      $str .= $charset[mt_rand(0, $count-1)];
                                  }
                                  return $str;
                              }
        
                              $unique_id = randString(7);
                              $result =mysqli_query($con,"SELECT * FROM customer_order WHERE
                              trx_id='$unique_id'");
                              $count=mysqli_num_rows($result);
                              if($count>0)
                              {
                              $unique_id = randString(7);
                              }
                              $tx="$unique_id";
                                                
        
                              ?>
        
             
                <?php
        
        if (!isset($_SESSION["userid"])) {
          //---------------------------if user is not logged in then show him a ready checkout and redirect to login page
            echo '<input type="submit" style="" name="login_user_with_product"
             class="btn btn-outline-primary-2 btn-order btn-block" value="Ready to Checkout" >
                </form>';
          }else if(isset($_SESSION['userid'])){
        //isf user is already logged in then rediretct him to paypal itegration module--------------------------
        //-------------------------------------paypal code starts here---------------------------------------    
      ?>

<a href='payment.php?amt=<?php echo $total_amt; ?>&& tx=<?php echo $tx; ?>' class='btn btn-outline-primary-2 btn-order btn-block'>PROCEED TO CHECKOUT</a>
    </div>

    <a href='index.php' class='btn btn-outline-dark-2 btn-block mb-3'><span>CONTINUE SHOPPING</span><i class='icon-refresh'></i></a>
</aside>

          </div>       
      <?php
        
        
          }
        
        }//mysqli_num_rows----which fetches added product list is ends here
        else{
         
   
    echo "<div class='alert alert-danger' role='alert' style='color:black;padding:10px;'>
    Your Cart is Empty. 
    <button type='button' class='close-custom close-custom-danger' data-dismiss='alert' aria-label='Close'>
          <span aria-hidden='true'>&times;</span>
    </button>
    </div>";
            echo" 
          <div class='col-12 item' style='display:flex;flex-direction:column;align-items:center;'>
          <p class='home-empty'>Your cart is empty</p>
          <img src='assets/images/empty.png' class='empty'>
          <a href='index.php' class='btn btn-primary'>
          Go to Shop</a>
          </div>

            ";
  }
  }//if(isset ) ends here
  
  
  
 



//----------------------------------------|| cart.php-cart page ends here-----------------------------

//-----------------------------remove item from code starts here-----------------------------------
//-----------------------------remove item from code starts here-----------------------------------
if(isset($_POST['removeFromCart'])){
  $pid=$_POST['removeId'];

  if(isset($_SESSION['userid'])){
  $userid=$_SESSION['userid'];
  $sql="DELETE FROM cart WHERE user_id='$userid' AND p_id='$pid' ";
  }else{
    $sql="DELETE FROM cart WHERE ip_add='$ip_add' AND p_id='$pid' AND user_id=-1";
  }
  $result=mysqli_query($con,$sql);

  if($result){
    echo "<div class='alert alert-danger' role='alert'>
    Item removed from the Cart. 
   <button type='button' class='close-custom close-custom-danger' data-dismiss='alert' aria-label='Close'>
          <span aria-hidden='true'>&times;</span>
   </button>
  </div>";
  }

}

//-----------------------------remove item from code ends here-----------------------------------
//------------------------------------------code for update items of cart starts here--------------------------
if(isset($_POST['updateToCart'])){

  $pid=$_POST['updateId'];
  
  $qty=$_POST['qty'];
  $price=$_POST['price'];
  $total=$_POST['total'];

  if(isset($_SESSION['userid'])){
     $userid=$_SESSION['userid'];
     $sql= "UPDATE `cart` SET qty='$qty', price ='$price', total_amount='$total' WHERE  p_id= '$pid' ";
  }else{
    $sql= "UPDATE `cart` SET qty='$qty', price ='$price', total_amount='$total' WHERE p_id= '$pid'  ";
  }

  $result=mysqli_query($con,$sql);
  if($result){
    echo "<div class='alert alert-success' role='alert'>
    Product is Updated Successfully. 
   <button type='button' class='close-custom close-custom-success' data-dismiss='alert' aria-label='Close'>
          <span aria-hidden='true'>&times;</span>
   </button>
  </div>";
  }
}

//------------------------------------------code for update items of cart ends here--------------------------