14 lines
507 B
PHP
14 lines
507 B
PHP
<?php
|
|
header("Content-Type: application/json; charset=UTF-8");
|
|
require_once '../koneksi.php';
|
|
|
|
try {
|
|
// Hanya tarik ID Penduduk yang musibahnya belum ditangani
|
|
$stmt = $conn->query("SELECT id_penduduk FROM laporan_musibah WHERE status_penanganan = 'Belum Ditangani'");
|
|
$data = $stmt->fetchAll(PDO::FETCH_COLUMN); // Mengembalikan array [id1, id2, ...]
|
|
|
|
echo json_encode($data);
|
|
} catch(PDOException $e) {
|
|
http_response_code(500); echo json_encode(["error" => $e->getMessage()]);
|
|
}
|
|
?>
|