Hi, 

• A connection to your MySQL database is established using mysqli.
• A prepared statement is used to fetch the course names and statuses for the registered courses of a specific student.
• The results are displayed in an HTML table. If no courses are found, a message indicates that the student is not registered in any courses.

Database Structure

• courses table:

  • id (int, primary key)
  • course_name (varchar)
  • status (varchar)

• registrations table:

  • id (int, primary key)
  • student_id (int)
  • course_id (int)

connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Assuming we have the student ID
$student_id = 1; // Replace with dynamic value based on logged-in student

// SQL query to fetch the registered courses and their status
$sql = "SELECT c.course_name, c.status 
        FROM registrations r 
        JOIN courses c ON r.course_id = c.id 
        WHERE r.student_id = ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("i", $student_id);
$stmt->execute();
$result = $stmt->get_result();

$courses = [];
while ($row = $result->fetch_assoc()) {
    $courses[] = $row;
}

$stmt->close();
$mysqli->close();
?>
Your Registered Courses
You are not registered in any courses.
Course Name
Status