61 lines
1.5 KiB
PHP
61 lines
1.5 KiB
PHP
<?php
|
|
// ambil_data.php
|
|
// Mengambil semua data jalan dan parsil tanah dari database dalam format JSON.
|
|
|
|
require_once "koneksi.php";
|
|
|
|
if ($_SERVER["REQUEST_METHOD"] !== "GET") {
|
|
json_response([
|
|
"success" => false,
|
|
"message" => "Method tidak diizinkan."
|
|
], 405);
|
|
}
|
|
|
|
$jalan = [];
|
|
$parsil = [];
|
|
|
|
// Ambil data jalan
|
|
$queryJalan = "SELECT id, nama_jalan, status_jalan, panjang_meter, geojson, created_at, updated_at
|
|
FROM jalan
|
|
ORDER BY id ASC";
|
|
$resultJalan = $koneksi->query($queryJalan);
|
|
|
|
if (!$resultJalan) {
|
|
json_response([
|
|
"success" => false,
|
|
"message" => "Gagal mengambil data jalan: " . $koneksi->error
|
|
], 500);
|
|
}
|
|
|
|
while ($row = $resultJalan->fetch_assoc()) {
|
|
$row["id"] = (int) $row["id"];
|
|
$row["panjang_meter"] = (float) $row["panjang_meter"];
|
|
$jalan[] = $row;
|
|
}
|
|
|
|
// Ambil data parsil tanah
|
|
$queryParsil = "SELECT id, nama_parsil, status_kepemilikan, luas_meter, geojson, created_at, updated_at
|
|
FROM parsil_tanah
|
|
ORDER BY id ASC";
|
|
$resultParsil = $koneksi->query($queryParsil);
|
|
|
|
if (!$resultParsil) {
|
|
json_response([
|
|
"success" => false,
|
|
"message" => "Gagal mengambil data parsil tanah: " . $koneksi->error
|
|
], 500);
|
|
}
|
|
|
|
while ($row = $resultParsil->fetch_assoc()) {
|
|
$row["id"] = (int) $row["id"];
|
|
$row["luas_meter"] = (float) $row["luas_meter"];
|
|
$parsil[] = $row;
|
|
}
|
|
|
|
json_response([
|
|
"success" => true,
|
|
"jalan" => $jalan,
|
|
"parsil" => $parsil
|
|
]);
|
|
?>
|