<?php
include '../../../include/conf.php';
$session_id = mysqli_real_escape_string($conn, $_POST['sess_must']);
$v_id = mysqli_real_escape_string($conn, $_POST['v_id_must']);
$product_id = mysqli_real_escape_string($conn, $_POST['product_id']);
$myqty = mysqli_real_escape_string($conn, $_POST['myqty']);

$get_check_prod = mysqli_query($conn, "select * from shop_cart_admin_demo_1 where productid='$product_id' and session_id='$session_id' and v_id='$v_id'");
$num_check_prod = mysqli_num_rows($get_check_prod);
if($num_check_prod > 0){
    $set_check_prod = mysqli_fetch_array($get_check_prod, MYSQLI_ASSOC);
    $qty = $set_check_prod['qty'] + 1;
    $totprice =  $qty * $set_check_prod['price'];
    $totprice = number_format((float)$totprice, 1, '.', '');
    $update = "update shop_cart_admin_demo_1 set `qty`='$qty', `totprice`='$totprice' where id='".$set_check_prod['id']."'";
    mysqli_query($conn, $update);
}else{
    $get_prod = mysqli_query($conn, "select * from shop_cart_admin_demo where session_id='$session_id' limit 1");
    $set_prod = mysqli_fetch_array($get_prod, MYSQLI_ASSOC);
    $get_prod_det = mysqli_query($conn, "select * from shop_product where product_id='$product_id'");
    $set_prod_det = mysqli_fetch_array($get_prod_det, MYSQLI_ASSOC);
    $get_user_id = mysqli_query($conn, "select * from tbl_job_new where id='$v_id'");
    $set_user_id = mysqli_fetch_array($get_user_id, MYSQLI_ASSOC);
    $totprice =  $myqty * $set_prod_det['price'];
    $totprice = number_format((float)$totprice, 1, '.', '');
    $insert = "INSERT INTO `shop_cart_admin_demo_1` (`user_id`, `session_id`, `v_id`, `productid`, `qty`, `price`, `totprice`, `dateadded`, `billing`, `shipping`, `del_country`, `del_city`, `del_state`, `del_address`, `del_inp`, `qty_free`, `d_mobile`, `trans`, `url`) VALUES 
    ('".$set_user_id['name']."', '$session_id', '$v_id', '$product_id', '$myqty', '".$set_prod_det['price']."', '$totprice', '".date('Y-m-d H:i:s')."', '".$set_prod['billing']."', '".$set_prod['shipping']."', '".$set_prod['del_country']."', '".$set_prod['del_city']."', '".$set_prod['del_state']."', '".$set_prod['del_address']."', '".$set_prod['del_inp']."', '".$set_prod['qty_free']."', '".$set_prod['d_mobile']."', '".$set_prod['trans']."', '')";
mysqli_query($conn,$insert);
}
?>