<?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`, `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>");

        }

    }

?>