<?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;

  $cid = $_SERVER['REMOTE_ADDR'];

   $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`, extra_p, gid) VALUES ('$proid','$cid','$quantity','1','$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>");

        }

    }

?>