<?php
// php/read_anggota.php
require_once 'koneksi.php';
header('Content-Type: application/json; charset=utf-8');

$kemiskinanId = intval($_GET['kemiskinan_id'] ?? 0);
if (!$kemiskinanId) {
    echo json_encode([]); exit;
}

$stmt = $conn->prepare(
    "SELECT *, 
        TIMESTAMPDIFF(YEAR, tanggal_lahir, CURDATE()) AS umur,
        DATE_FORMAT(updated_at, '%Y-%m-%d %H:%i') AS updated_at_fmt,
        DATE_FORMAT(tanggal_lahir, '%d/%m/%Y') AS tgl_lahir_fmt
     FROM anggota_keluarga 
     WHERE kemiskinan_id = ? 
     ORDER BY hubungan_keluarga, nama"
);
$stmt->bind_param('i', $kemiskinanId);
$stmt->execute();
$result = $stmt->get_result();
$data = [];
while ($row = $result->fetch_assoc()) {
    $data[] = $row;
}
$stmt->close();
echo json_encode($data);
?>