<?php
include("includes/db_config.php"); // Make sure your database connection is included

if (isset($_GET['punit']) && isset($_GET['sunit'])) {
    $punit = intval($_GET['punit']);
    $sunit = intval($_GET['sunit']);

    $query = "SELECT conversion_rate FROM conversion_rates WHERE primary_unit_id = $punit AND secondary_unit_id = $sunit";
    $result = mysqli_query($conn, $query);
    
    if ($row = mysqli_fetch_assoc($result)) {
        echo json_encode(["rate" => $row['conversion_rate']]);
    } else {
        echo json_encode(["rate" => "0.0"]);
    }
}
?>