korsygdsfftyhgfdddszangaiide
Elepffwfggsfggjewesxsfrghf
/
var
/
www
/
html
/
site_shopudiet
/
admin
/
Upload FileeE
HOME
<?php include 'dbconnect.php'; $home_id=$_REQUEST['id']; $id=$_REQUEST['id1']; $hid = 'FC00'.$home_id; $prdct = $_REQUEST['prdct']; $price = $_REQUEST['price']; $cart="delete from product_cart where prdctname='".$prdct."' and order_id='".$hid."'"; $res_cart=mysqli_query($conn,$cart); $sql = "select * from confirm_order where id=$home_id"; $result = mysqli_query($conn,$sql); $row = mysqli_fetch_array($result); $number=explode(',', $row['no_item']); $prdct_name=explode(',', $row['product']); $total_num=$row['item_no']; $ot = $row['total']; $ctot = $ot-$price; array_splice($prdct_name, $id, 1); array_splice($number, $id, 1); $total=0; $product=implode(',', $prdct_name); $product_num=implode(',', $number); $count_prd=count($prdct_name); $product_org=explode(',', $product); $product_num_org=explode(',', $product_num); for($i=0;$i<count($prdct_name);$i++){ $sql="select * from product where product_name='".$product_org[$i]."'"; $result_pin=mysqli_query($conn,$sql); $row=mysqli_fetch_array($result_pin); $price=$row['price']; if (mysqli_num_rows($result_pin)==0) { $sql="select * from packages where product_name='".$product_org[$i]."'"; $result_pin=mysqli_query($conn,$sql); $row=mysqli_fetch_array($result_pin); $price=$row['price']; } $total=$total+($price*$product_num_org[$i]); } $grand_total=$total+30; $query="update confirm_order set product='$product',no_item='$product_num',item_no='$count_prd',total='$ctot' where id='$home_id'"; if(mysqli_query($conn,$query)){ $url="edit_confirm_order.php?id=$home_id"; header("location:".$url); } else{ echo"not deleted".mysqli_error(); } mysqli_close($conn); ?>