<?php
require_once 'db_config.php';
header('Content-Type: application/json');

$kemiskinan_id = isset($_GET['kemiskinan_id']) ? intval($_GET['kemiskinan_id']) : 0;

if ($kemiskinan_id <= 0) {
    echo json_encode(['status' => 'error', 'message' => 'Invalid ID']);
    exit;
}

$stmt = $conn->prepare("SELECT * FROM warga WHERE kemiskinan_id = ? ORDER BY id ASC");
$stmt->bind_param("i", $kemiskinan_id);
$stmt->execute();
$res = $stmt->get_result();

$data = [];
while ($row = $res->fetch_assoc()) {
    $data[] = $row;
}

echo json_encode(['status' => 'success', 'data' => $data]);
$stmt->close();
$conn->close();
?>