Login
Demo admin: admin / Admin123!
Demo user: alice / Alice123!
Register
Role Breakdown
User Growth — Users Created Per Month
Users
| ID | Username | Role | Status | Created | Actions |
|---|
Recent Activity — Last 20 Actions
View / Edit Profile
Update Password
My Activity History — Last 10 Actions
Query A — Active Admins
SELECT * FROM users WHERE role = 'admin' AND is_active = TRUE;
Query B — Users JOIN Profiles for Gmail Users
SELECT u.*, p.* FROM users u JOIN user_profiles p ON u.user_id = p.user_id WHERE u.email LIKE '%@gmail.com';
Query C — Count Users By Role
SELECT COUNT(*) AS total, role FROM users GROUP BY role;
Query D — Activity Logs By User
SELECT * FROM activity_logs WHERE user_id = ? ORDER BY timestamp DESC LIMIT 10;