26 lines
618 B
PHP
26 lines
618 B
PHP
<?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();
|
|
?>
|