User Management System

Sign In

Demo Accounts

Username Email Password Role
adminadmin@example.comAdminPass123!admin
janejane@gmail.comUserPass123!user
bobbob@gmail.comBobPass123!editor
inactive_userinactive_user@outlook.comInactivePass123!user

Admin Dashboard

Total Users
0
Active Users
0
Inactive Users
0

Role Breakdown

Search Users Across Username and Email

User Growth Chart - Created Per Month

Recent Activity Log - Last 20 Actions

Users CRUD

Edit User

User List - Search and Pagination

SQL Query Simulation

These JavaScript functions simulate SQL queries against the simulated `localStorage` database. 

SQL A: SELECT * FROM users WHERE role = 'admin' AND is_active = TRUE;
SQL B: SELECT u.*, p.* FROM users u JOIN user_profiles p ON u.user_id = p.user_id WHERE u.email LIKE '%@gmail.com';
SQL C: SELECT COUNT(*) as total, role FROM users GROUP BY role;
SQL D: SELECT * FROM activity_logs WHERE user_id = ? ORDER BY timestamp DESC LIMIT 10;

User Profile

Edit Own Profile

Update Password

Personal Activity History