28 lines
499 B
PHP
28 lines
499 B
PHP
<?php
|
|
include 'koneksi.php';
|
|
|
|
$data = [];
|
|
|
|
// jalan
|
|
$q1 = $conn->query("SELECT * FROM jalan");
|
|
while($r = $q1->fetch_assoc()){
|
|
$r['tipe'] = "jalan";
|
|
$data[] = $r;
|
|
}
|
|
|
|
// tanah
|
|
$q2 = $conn->query("SELECT * FROM tanah");
|
|
while($r = $q2->fetch_assoc()){
|
|
$r['tipe'] = "tanah";
|
|
$data[] = $r;
|
|
}
|
|
// ================= RUSAK =================
|
|
$q3 = $conn->query("SELECT * FROM rusak");
|
|
|
|
while($r = $q3->fetch_assoc()){
|
|
$r['tipe'] = "rusak";
|
|
$data[] = $r;
|
|
}
|
|
|
|
echo json_encode($data);
|
|
?>
|