query("SELECT users.id, users.username, roles.role_name FROM users JOIN roles ON users.role_id = roles.id ORDER BY users.username");
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Handle role change
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'change_role') {
$user_id = isset($_POST['user_id']) ? (int)$_POST['user_id'] : 0;
$role_id = isset($_POST['role_id']) ? (int)$_POST['role_id'] : 0;
if ($user_id && $role_id) {
$stmt = $pdo->prepare("UPDATE users SET role_id = ? WHERE id = ?");
$stmt->execute([$role_id, $user_id]);
header("Location: admin.php?success=role_changed");
exit();
}
}
// Fetch all roles for the dropdown
$roles_stmt = $pdo->query("SELECT id, role_name FROM roles");
$roles = $roles_stmt->fetchAll(PDO::FETCH_ASSOC);
$page_title = "Admin - User Management";
?>
<?= htmlspecialchars($page_title) ?> - Bhuddi School
User Management
| Username |
Role |
Actions |
|
|
|