34 lines
782 B
PHP
34 lines
782 B
PHP
<?php
|
|
include 'koneksi.php';
|
|
|
|
$jenis = isset($_GET['jenis']) ? $_GET['jenis'] : 'jalan';
|
|
|
|
if ($jenis == 'jalan') {
|
|
$sql = "SELECT * FROM jalan";
|
|
} else if ($jenis == 'parsil') {
|
|
$sql = "SELECT * FROM parsil";
|
|
} else {
|
|
die(json_encode(["error" => "Jenis data tidak ditemukan"]));
|
|
}
|
|
|
|
$result = $conn->query($sql);
|
|
$data = array();
|
|
|
|
if ($result && $result->num_rows > 0) {
|
|
while($row = $result->fetch_assoc()) {
|
|
// Convert numbers correctly
|
|
if (isset($row['panjang'])) {
|
|
$row['panjang'] = floatval($row['panjang']);
|
|
}
|
|
if (isset($row['luas'])) {
|
|
$row['luas'] = floatval($row['luas']);
|
|
}
|
|
$data[] = $row;
|
|
}
|
|
}
|
|
|
|
header('Content-Type: application/json');
|
|
echo json_encode($data);
|
|
$conn->close();
|
|
?>
|