<?php
header("Content-Type: application/json");

$host = "127.0.0.1"; 
$user = "root";
$pass = "root"; // Pastikan sesuai dengan yang terakhir kita set
$db   = "webgis_db";

$conn = mysqli_connect($host, $user, $pass, $db);

if (!$conn) {
    echo json_encode(["status" => "error", "message" => "Koneksi Gagal"]);
    exit;
}

// Ambil semua data dari tabel
$query = "SELECT * FROM spbu_locations";
$result = mysqli_query($conn, $query);

$data_spbu = [];
while ($row = mysqli_fetch_assoc($result)) {
    $data_spbu[] = $row;
}

// Kirim data ke file HTML dalam bentuk JSON
echo json_encode(["status" => "success", "data" => $data_spbu]);

mysqli_close($conn);
?>