<?php 
include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
	$user_id = $_POST['user_id'];
        $product_id = $_POST['product_id'];
        $session_id = $_POST['session_id'];
        $prod_quantity = $_POST['prod_quantity'];
        $prod_quantity_type = $_POST['prod_quantity_type'];
        $prod_size=$prod_quantity.$prod_quantity_type;
        $quantity = $_POST['qty'];
        $prd_details = $_POST['product_details_id'];
        $price = $_POST['price'];
         date_default_timezone_set('Asia/Kolkata');
         $date = date('Y-m-d H:i:s');
        $sql = "SELECT * FROM product WHERE id = '$product_id'";
    $result = mysqli_query($conn, $sql) or die(mysqli_error($conn));
    $res= mysqli_fetch_array($result);
        $prod_code=$res['prod_code'];
        $prd_name=$res['prod_name'];
      $sql="INSERT into addto_cart(prod_details_id,prod_id,session_id,user_id,prod_name,prod_size,quantity,price,added_by,created_date) values ('$prd_details','$product_id','$session_id','$user_id','$prd_name','$prod_size','$quantity','$price','$added_by','$date')";
  if  (mysqli_query($conn, $sql))
  {
    $sql = "SELECT count(*) as num FROM addto_cart WHERE session_id = '$session_id' and invoice_id='1'";
    $result = mysqli_query($conn, $sql) or die(mysqli_error($conn));
    $res= mysqli_fetch_array($result);
    $num=$res['num'];

    $sql1 = "select addto_cart.* FROM addto_cart WHERE session_id = '$session_id' and invoice_id='1'";
    $result1 = mysqli_query($conn, $sql1) or die(mysqli_error($conn));
    if(mysqli_num_rows($result1) > 0) {
    while($row[] = mysqli_fetch_assoc($result1)) {
     $tem = $row;
  }
  }
       $response['data']=$tem;
     $response['count']=$num;
     $response['status']=1;
  }else{
    $response['status']=0;
  }
   

  echo json_encode($response);
  mysqli_close($conn);
}

?>