27 lines
767 B
PHP
27 lines
767 B
PHP
<?php
|
|
/**
|
|
* get_pending_users.php — Ambil daftar user yang statusnya 'pending'
|
|
* Hanya admin yang boleh akses
|
|
*/
|
|
session_start();
|
|
require_once 'koneksi.php';
|
|
header('Content-Type: application/json');
|
|
|
|
if (!isset($_SESSION['user_role']) || $_SESSION['user_role'] !== 'admin') {
|
|
echo json_encode(['success' => false, 'message' => 'Akses ditolak. Hanya Admin.']);
|
|
exit;
|
|
}
|
|
|
|
$stmt = $conn->prepare("SELECT id, nama, email, role, DATE_FORMAT(created_at, '%d %M %Y %H:%i') as waktu FROM users WHERE status = 'pending' ORDER BY created_at ASC");
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
$users = [];
|
|
while ($row = $result->fetch_assoc()) {
|
|
$users[] = $row;
|
|
}
|
|
|
|
echo json_encode(['success' => true, 'data' => $users]);
|
|
$stmt->close();
|
|
$conn->close();
|