1#@!#!123s

https 1#@!#!123s

: / home5 / ragvieco / public_html / ajax /

Filename : grand_total.php

back

<?php
include '../function.php';

$sub_total = 1000; // Get this from session/cart logic

if (isset($_POST['billing_pincode'])) {
    $billing_pincode = $_POST['billing_pincode'];

    $query = mysqli_query($connect, "SELECT price FROM pincode_price WHERE pincode = '$billing_pincode'");
    $row = mysqli_fetch_assoc($query);

    $shipping_cost = $row && !empty($row['price']) ? $row['price'] : 250;

    $grand_total = $sub_total + $shipping_cost;
    echo number_format($grand_total, 2, '.', '');
}
?>