<?php
include'dbc.php';
 // product price update 
  $getid=$_GET['id'];
  $sql8=mysqli_query($conn,"select productid from tbl_product where id= '$getid'") or die(mysqli_query($conn)); 
        $row8=mysqli_fetch_assoc($sql8);
        $product_productid=$row8['productid'];
        $del2=mysqli_query($conn,"delete from tbl_whislist where product_id='$product_productid'");

                  $sql6=mysqli_query($conn,"select order_id from tbl_order where cart_status='0'") or die(mysqli_query($conn));
                   while ($row6=mysqli_fetch_assoc($sql6))
                   {
                      $order_orderid=$row6['order_id']; 
 //echo 'jello';
                      $sql7=mysqli_query($conn,"select product_id from tbl_order_details where order_id= '$order_orderid'") or die(mysqli_query($conn));
                        while ($row7=mysqli_fetch_assoc($sql7))
                        {
                           $orderdetails_productid=$row7['product_id'];

                           if($orderdetails_productid==$product_productid)
                           {
                             echo $orderdetails_productid;

                            $del=mysqli_query($conn,"delete from tbl_order_details where product_id='$orderdetails_productid' and order_id='$order_orderid'");
                          
                             header('Location: product-list.php?m=4');

                           }
                           else
                           {
                            //echo 'unmatched';
                             header('Location: product-list.php?m=4');
                           }
                        }
          
                   }
header('Location: product-list.php?m=4');              
?>