1#@!#!123s

https 1#@!#!123s

: / home5 / ragvieco / public_html / ajax /

Filename : select_pincode.php

back

<?php
include '../function.php'; // or your DB file

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

    // Assuming you have a table `pincode_price` with fields `pincode` and `price`
    $query = mysqli_query($connect, "SELECT price FROM pincode_price WHERE pincode = '$billing_pincode'");
    $row = mysqli_fetch_assoc($query);

    if ($row && !empty($row['price'])) {
        echo number_format($row['price'], 2, '.', '');
    } else {
        echo '250.00'; // Default shipping price
    }
}
?>