19 lines
427 B
PHP
19 lines
427 B
PHP
<?php
|
|
// php/read_kemiskinan.php
|
|
include 'koneksi.php';
|
|
|
|
header('Content-Type: application/json; charset=utf-8');
|
|
|
|
$query = "SELECT *, DATE_FORMAT(updated_at, '%Y-%m-%d %H:%i:%s') as updated_at_fmt FROM kemiskinan ORDER BY updated_at DESC, id DESC";
|
|
$result = mysqli_query($conn, $query);
|
|
$data = [];
|
|
|
|
if ($result) {
|
|
while ($row = mysqli_fetch_assoc($result)) {
|
|
$data[] = $row;
|
|
}
|
|
}
|
|
|
|
echo json_encode($data);
|
|
?>
|