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

extract($_POST);

 $proid;
 $pprice;
 $quantity;
  $goodies;
 ($goodies);

 if ($goodies == '') {
$tot = 0;
 }
 else
 {
   $gs = implode(',', $goodies);
     $gd =  explode(',', $gs);
     $tot = 0;
    for($i=0; $i<count($gd); $i++)
    {
         $gdv = $gd[$i];

        $sql = "select * from tbl_goodies where id='$gdv'";
        $sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
        $sql_rowg = mysqli_fetch_array($sql_res);
        $p  = $sql_rowg['price'];

         $tot += $p;
    }
     
 $tot;
 }

  $tot;
  
   $sqlsec = "select * from tbl_cart 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)
    {
        // echo 'oo';
        
         $cid = $_SERVER['REMOTE_ADDR'];
    
      $sqls=" INSERT INTO `tbl_cart`(`pid`, `cid`, `qty`, `status`, `price`, extra_p, gid) VALUES ('$proid','$cid','$quantity','1','$pprice','$tot','$gs')";
        $result_s = mysqli_query($con,$sqls);
        if($result_s==TRUE)
        {
            echo "1";    
        }
    
        else{
            echo ("<SCRIPT LANGUAGE='JavaScript'>
            window.alert('Not Updated')
            </SCRIPT>");
        }
        
    }
    else { 
        // echo 'ii';
       
        
         $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_cart` 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>");
        }
    }
?>