korsygdsfftyhgfdddszangaiide
Elepffwfggsfggjewesxsfrghf
/
var
/
www
/
html
/
site_shopudiet
/
Upload FileeE
HOME
<?php session_start(); include 'dbconnect.php'; $cart_id=$_SESSION['cart_id']; $grand_total=0; $total=0; $grand_total1=0; $coupon=$_POST['coupon']; $query="select * from coupon where code='".$coupon."'"; $res_u = mysqli_query($conn,$query); if (mysqli_num_rows($res_u) ==0) { $_SESSION["error"]="Invalid Coupon ,Try Again"; header('location:cart.php'); // header('location:login.php'); // $sql="insert into customer(name,email,phone,status) values ('$name','$email','$phone','$status')"; // mysqli_query($conn,$sql); } else{ $squery = "SELECT * FROM product_cart WHERE cart_id='$cart_id' AND status != 'confirm'"; $result = mysqli_query($conn,$squery); $i=mysqli_num_rows($result); // echo $i; //$j=1; while( $row = mysqli_fetch_array($result)) { $flag=$row['flag']; $prdct_id=$row['prduct_id']; $query = "SELECT * FROM product WHERE id='$prdct_id'"; $result2 = mysqli_query($conn,$query); $row2 = mysqli_fetch_array($result2); $price=$row2['price']; $item=$row['no_of_item']; $total=$item*$price; $grand_total=$grand_total+$total; } $squery = "SELECT * FROM product_cart WHERE cart_id='$cart_id' AND status != 'confirm'"; $grand_total2=0; $result = mysqli_query($conn,$squery); $i=mysqli_num_rows($result); // echo $i; //$j=1; while( $row = mysqli_fetch_array($result)) { $price=$row['price']; $item=$row['no_of_item']; $total1=$item*$price; $grand_total2=$grand_total2+$total1; } $query = "select * from coupon where code='".$coupon."'"; $result = mysqli_query($conn,$query); $row = mysqli_fetch_array($result); $discount=$row['discount']; $grand_to= $grand_total2+ $grand_total; $discount_rate1=($grand_to*$discount)/100; $discount_rate=round($discount_rate1); $grand_total1=$grand_to-$discount; //$_SESSION['grand_total1']=$grand_total1+30; $_SESSION['coupon']=$coupon; $_SESSION['discount_rate']=$discount; // echo $_SESSION['grand_total1']; // echo $_SESSION['coupon']; // echo $_SESSION['discount_rate']; header('location:cart.php'); } ?>