<?php
require_once('includes/connection.php');

if (isset($_POST['name'])) {
    $name = $_POST['name'];

    $stmt = $conn->prepare("SELECT cus_address, cus_destination, cus_state FROM customer_master WHERE cus_name = ?");
    $stmt->bind_param("s", $name);
    $stmt->execute();
    $stmt->bind_result($address, $destination, $cus_state);
    $stmt->fetch();
    $stmt->close();

    // Return as JSON
    echo json_encode([
        'address' => $address ?: '',
        'destination' => $destination ?: '',
        'cus_state' => $cus_state ?: ''
    ]);
}
?>