prepare("SELECT name, email,role, created_at FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();
// Fetch statistics for the profile
// Fetch count directly from database for accuracy and performance
if (($user['role'] ?? '') === 'Admin') {
$stmt_count = $conn->prepare("SELECT COUNT(*) as count FROM projects");
} else {
$stmt_count = $conn->prepare("SELECT COUNT(*) as count FROM projects WHERE created_by_user_id = ?");
$stmt_count->bind_param("i", $user_id);
}
$stmt_count->execute();
$count_result = $stmt_count->get_result()->fetch_assoc();
$project_count = $count_result['count'] ?? 0;
$stmt_count->close();
// Get user initials for avatar
$user_name = $user['name'] ?? 'Admin User';
$initials = strtoupper(substr($user_name, 0, 1));
?>
User Profile - ConstructCRM
