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

extract($_POST);

 $proid;
 $pprice;
 $quantity;
 
 $cid = $_SERVER['REMOTE_ADDR'];
 
  $sqlsec = "select * from tbl_wishlist where pid='$proid' 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_wishlist`(`pid`, `cid`, `qty`, `status`, `price`) VALUES ('$proid','$cid','$quantity','1','$pprice')";
            $result_s = mysqli_query($con,$sqls);
            if($result_s==TRUE)
            {
                echo "1";    
            }
        
            else{
                echo ("<SCRIPT LANGUAGE='JavaScript'>
                window.alert('Not Updated')
                </SCRIPT>");
            }
    
    }
    else { 
        
        $sql_rowac = mysqli_fetch_array($sql_ressec);
         
       $aid =  $sql_rowac['id'];
       
       $qty =  $sql_rowac['qty'];
       
       $qt = $quantity + $qty ;
       
       $cid = $_SERVER['REMOTE_ADDR'];
    
      $sqlsc=" UPDATE `tbl_wishlist` set qty='$qt'  where id='$aid' and cid='$cid'";
        $result_sc = mysqli_query($con,$sqlsc);
        if($result_sc==TRUE)
        {
            echo "1";    
        }
    
        else{
            echo ("<SCRIPT LANGUAGE='JavaScript'>
            window.alert('Not Updated')
            </SCRIPT>");
        }
 
        
    }
?>