1#@!#!123s

https 1#@!#!123s
: / home5 / ragvieco / public_html / ajax /
Filename : total_ajax.php
back
<?php
include_once '../function.php';
session_start();

if (!isset($_SESSION['session_id'])) {
    $_SESSION['session_id'] = session_id();
}
$session_id = $_SESSION['session_id'];

// ✅ Get Subtotal
$total_cost = 0;
$get_order = mysqli_query($connect, "SELECT order_price FROM order_cart WHERE session_id = '$session_id' AND orderStatus='no'") or die(mysqli_error($connect));
while ($row = mysqli_fetch_assoc($get_order)) {
    $total_cost += $row['order_price'];
}

// ✅ Get Shipping Price (Default ₹50 if not available)
$default_shipping_price = 50;
$shipping_price = $default_shipping_price;

$get_shipping = mysqli_query($connect, "SELECT shipping_price FROM order_cart_add WHERE session_id = '$session_id'") or die(mysqli_error($connect));
if (mysqli_num_rows($get_shipping) > 0) {
    $fetch_shipping = mysqli_fetch_assoc($get_shipping);
    $shipping_price = (!empty($fetch_shipping['shipping_price']) && $fetch_shipping['shipping_price'] > 0)
        ? $fetch_shipping['shipping_price']
        : $default_shipping_price;
}

// ✅ Return total (Subtotal + Shipping)
echo number_format($total_cost + $shipping_price, 2, '.', '');
?>