JOIN JKSSB COURSE
auth/register.php
prepare($sql);
$stmt->execute([
$name,
$email,
$hashedPassword
]);
$message = "Registration successful.";
} catch (PDOException $e) {
$message = "Email already registered.";
}
}
}
?>
Register - Home Academy
Login - Home Academy
Student Dashboard - Home Academy
100 lessons SELECT COUNT(*) AS completed_lessons FROM progress JOIN lessons ON progress.lesson_id = lessons.id WHERE progress.user_id = ? AND lessons.course_id = ? AND progress.completed = 1 $progress = ( $completedLessons / $totalLessons ) * 100;
Home Academy Student Registration
auth/login.php prepare($sql); $stmt->execute([$email]); $user = $stmt->fetch(PDO::FETCH_ASSOC); if ($user && password_verify( $password, $user["password"] )) { $_SESSION["user_id"] = $user["id"]; $_SESSION["user_name"] = $user["name"]; header( "Location: ../student/dashboard.php" ); exit; } else { $message = "Invalid email or password."; } } ?>Student Login
student/dashboard.php prepare($sql); $stmt->execute([$userId]); $courses = $stmt->fetchAll(PDO::FETCH_ASSOC); ?>Welcome,
My Courses
100 lessons SELECT COUNT(*) AS completed_lessons FROM progress JOIN lessons ON progress.lesson_id = lessons.id WHERE progress.user_id = ? AND lessons.course_id = ? AND progress.completed = 1 $progress = ( $completedLessons / $totalLessons ) * 100;