<?php 
include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
$user_id = $_POST['user_id'];
$session_id = $_POST['session_id'];
$sql = "SELECT count(*) as num FROM addto_cart WHERE (user_id='".$user_id."' OR 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'];
$sql_ttl="select SUM(quantity * price) as ttl from addto_cart  where (user_id='".$user_id."' OR session_id='".$session_id."') and addto_cart.invoice_id='1'";
$resu_ttl = mysqli_query($conn, $sql_ttl);
$res_ttl= mysqli_fetch_assoc($resu_ttl);
$total=$res_ttl['ttl'];
$sql_qrys="select Sum(product_detail.prod_cross_price * quantity) as prcs,addto_cart.quantity from addto_cart join product_detail on addto_cart.prod_details_id=product_detail.id where (user_id='".$user_id."' OR session_id='".$session_id."') and addto_cart.invoice_id='1'";
$resus = mysqli_query($conn, $sql_qrys);
$res_prds= mysqli_fetch_assoc($resus);
$price_cross= $res_prds['prcs'];
if(mysqli_num_rows($result) > 0) {
$sql1 = "select addto_cart.*,product.prod_img1,sub_sub_category.sub_sub_cat_name from addto_cart join product on addto_cart.prod_id=product.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id WHERE (user_id='".$user_id."' OR 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;
}
}
$discount=$price_cross - $res_ttl['ttl'];
 $response['price_cross']=$price_cross;
 $response['total_price']=$total;
 $response['count']=$num;
 $response['discount']=$discount;
 $response['status']=1;
}else{
$response['status']=0;
}


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

?>