<?php 
include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
        $product_id = $_POST['product_id'];
        $user_id = $_POST['user_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,user_id,prod_name,prod_size,quantity,price,added_by,created_date) values ('$prd_details','$product_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 user_id = '$user_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 user_id = '$user_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);
}

?>