30 lines
768 B
PHP
30 lines
768 B
PHP
<?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);
|
|
?>
|