prepare("SELECT id FROM enrollments WHERE user_id = ? AND skill_id = ?"); $stmt->execute([$userId, $skillId]); if ($stmt->fetch()) { $_SESSION['message'] = "You are already enrolled in this skill."; $_SESSION['message_type'] = 'warning'; } else { // Enroll user $stmt = db()->prepare("INSERT INTO enrollments (user_id, skill_id, progress, date_enrolled) VALUES (?, ?, 0, NOW())"); if ($stmt->execute([$userId, $skillId])) { $_SESSION['message'] = "Enrollment successful! You can now continue learning from your dashboard."; $_SESSION['message_type'] = 'success'; } else { $_SESSION['message'] = "An error occurred. Please try again."; $_SESSION['message_type'] = 'danger'; } } header("Location: dashboard.php"); exit; } if (isset($_SESSION['message'])) { $message = $_SESSION['message']; $message_type = $_SESSION['message_type']; unset($_SESSION['message']); unset($_SESSION['message_type']); } $stmt = db()->prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$userId]); $user = $stmt->fetch(PDO::FETCH_ASSOC); if (!$user) { session_destroy(); header("Location: login.php"); exit; } // Fetch all skills, excluding those the user is already enrolled in for the explorer $enrolled_skill_ids = []; $stmt_enrolled_ids = db()->prepare("SELECT skill_id FROM enrollments WHERE user_id = ?"); $stmt_enrolled_ids->execute([$userId]); $enrolled_skill_ids = $stmt_enrolled_ids->fetchAll(PDO::FETCH_COLUMN); $skills_by_category = []; $sql = "SELECT * FROM skills"; if (!empty($enrolled_skill_ids)) { $placeholders = implode(',', array_fill(0, count($enrolled_skill_ids), '?')); $sql .= " WHERE id NOT IN ($placeholders)"; } $sql .= " ORDER BY category, title"; $stmt = db()->prepare($sql); if (!empty($enrolled_skill_ids)) { $stmt->execute($enrolled_skill_ids); } else { $stmt->execute(); } $all_skills = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($all_skills as $skill) { $skills_by_category[$skill['category']][] = $skill; } // Fetch enrolled skills for the current user $stmt = db()->prepare(" SELECT s.id, s.title, s.category, s.thumbnail, e.progress FROM enrollments e JOIN skills s ON e.skill_id = s.id WHERE e.user_id = ? "); $stmt->execute([$userId]); $enrolled_skills = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> Dashboard - TAP2SKILL

Welcome, !

Explore Skills

Continue Learning

Community

My Enrolled Skills

You haven’t enrolled in any skills yet. Explore new skills to start learning!

Explore Skills

<?php echo htmlspecialchars($skill['title']); ?>

Continue Learning

Skill Explorer

You've enrolled in all available skills. Great job!

$skills): ?>