<?php
include 'koneksi.php';

// =====================
// SPBU (POINT)
// =====================
$spbu = [];
$q1 = $conn->query("SELECT * FROM lokasi");
while($row = $q1->fetch_assoc()){
    $spbu[] = $row;
}

// =====================
// JALAN (POLYLINE)
// =====================
$jalan = [];
$q2 = $conn->query("SELECT * FROM jalan");
while($row = $q2->fetch_assoc()){
    $jalan[] = $row;
}

// =====================
// KAVLING (POLYGON)
// =====================
$kavling = [];
$q3 = $conn->query("SELECT * FROM kavling");
while($row = $q3->fetch_assoc()){
    $kavling[] = $row;
}

// gabungkan
echo json_encode([
    "spbu" => $spbu,
    "jalan" => $jalan,
    "kavling" => $kavling
]);
?>