<?php
include ("../Admin/Includes/db.php");

extract($_POST);

 $proid;
 $pprice;
 $quantity;
 $wishid;

$cid = $_SERVER['REMOTE_ADDR'];

$pr = mysqli_query($con,"SELECT * FROM tbl_wishlist WHERE id='$wishid' ");
                                      
    $data1 = mysqli_fetch_array($pr);
    extract($data1);
    
     $sqlsec = "select * from tbl_cart where pid='$pid' and cid='$cid'";
  $sql_ressec = mysqli_query($con, $sqlsec) or die(mysqli_error($con));
  
   $numrowpc = mysqli_num_rows($sql_ressec);
   
    if($numrowpc == 0)
    {

        $sqls=" INSERT INTO `tbl_cart`(`pid`, `cid`, `qty`, `status`, `price`) VALUES ('$pid','$cid','$qty','1','$price')";
        $result_s = mysqli_query($con,$sqls);
        if($result_s==TRUE)
        {
            echo "1";    
            $sqlw = "DELETE FROM tbl_wishlist WHERE id='$wishid'";
    
            $result_sw = mysqli_query($con,$sqlw);
        }
    
        else{
            echo ("<SCRIPT LANGUAGE='JavaScript'>
            window.alert('Not Updated')
            </SCRIPT>");
        }
    }
    else { 
        // echo 'ii';
       
        
         $sql_rowac = mysqli_fetch_array($sql_ressec);
         
       $aid =  $sql_rowac['id'];
       
       $qtys =  $sql_rowac['qty'];
       
       $qt = $qty + $qtys ;
 
    $cid = $_SERVER['REMOTE_ADDR'];
    
      $sqlsc=" UPDATE `tbl_cart` set qty='$qt'  where id='$aid' and cid='$cid'";
        $result_sc = mysqli_query($con,$sqlsc);
        if($result_sc==TRUE)
        {
            echo "1";    
             $sqlwa = "DELETE FROM tbl_wishlist WHERE id='$wishid'";
    
            $result_swa = mysqli_query($con,$sqlwa);
        }
    
        else{
            echo ("<SCRIPT LANGUAGE='JavaScript'>
            window.alert('Not Updated')
            </SCRIPT>");
        }
    }
?>