How to display course status when student register?

Question

Hi Team I need help how only the course that the student is registered in and also course status in php and html.

Sangeetha S · Answer

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(); ?> Registered Courses Your Registered Courses You are not registered in any courses. Course Name Status