query($query); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $users[] = $row; } } // Handle user activation/deactivation if (isset($_GET['action']) && isset($_GET['id'])) { $action = $_GET['action']; $user_id = (int)$_GET['id']; // Can't modify yourself if ($user_id === (int)$_SESSION['user_id']) { $error = "You cannot modify your own account status."; } else { if ($action === 'activate') { $status = 'active'; $success_msg = "User activated successfully."; } elseif ($action === 'deactivate') { $status = 'inactive'; $success_msg = "User deactivated successfully."; } else { $error = "Invalid action."; } if (empty($error)) { $update_query = "UPDATE users SET status = ? WHERE id = ?"; $update_stmt = $conn->prepare($update_query); $update_stmt->bind_param("si", $status, $user_id); if ($update_stmt->execute()) { $success = $success_msg; // Refresh user list $result = $conn->query($query); $users = []; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $users[] = $row; } } } else { $error = "Failed to update user status: " . $conn->error; } } } } // Count stats $totalUsers = count($users); $activeUsers = 0; $inactiveUsers = 0; $studentUsers = 0; $facultyUsers = 0; foreach ($users as $user) { if ($user['status'] === 'active') $activeUsers++; if ($user['status'] === 'inactive') $inactiveUsers++; if ($user['user_type'] === 'student') $studentUsers++; if ($user['user_type'] === 'faculty') $facultyUsers++; } // Include header include 'includes/header.php'; ?>

Admin Panel

Manage users and system settings

Total Users

Students

Faculty

Active/Inactive

/

User Management
0): ?>
ID Username Email Type Status Created Last Login Actions
Deactivate Activate Current User
No users found in the database.
close(); ?>