<?php 
include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
$session_id = $_POST['session_id'];
$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'];
$sql_ttl="select SUM(quantity * price) as ttl from addto_cart  where addto_cart.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 addto_cart.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 from addto_cart join product on addto_cart.prod_id=product.id  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['price_cross']=$price_cross;
 $response['total_price']=$total;
 $response['count']=$num;
 $response['status']=1;
}else{
$response['status']=0;
}


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

?>