Hi Team
I am looking or finding some ways where on this below code i can use php or jquery to handle select option. Where users can select module of their chose. Kindly please assist, thanks.
<!-- BOOKING COURSES -->
<div class="udb-sec udb-cour">
<h4><img src="images/icon/db2.png" alt="" /> Booking Courses</h4>
<p>The courses available for booking or registration by the student.</p>
<form action="register_course.php" method="POST">
<div class="sdb-cours">
<?php
include 'db_connection.php'; // Include the database connection
// Check if the user is logged in
if (!isset($_SESSION['user_id'])) {
header("Location: index.html");
exit;
}
$user_id = $_SESSION['user_id']; // Get the user ID from the session
// Check if the connection is still valid
if (!$conn->ping()) {
die("Database connection failed.");
}
// Query to fetch available courses for the logged-in user
$sql = "
SELECT ac.course_id, ac.course_name, ac.duration, ac.category, ac.image
FROM available_courses ac
LEFT JOIN student_modules sm ON ac.course_name = sm.module_name AND sm.student_id = ?
WHERE sm.student_id IS NULL";
// Prepare the SQL statement
$stmt = $conn->prepare($sql);
if (!$stmt) {
die("Error preparing the query: " . $conn->error);
}
// Bind the parameters
$stmt->bind_param("i", $user_id); // Bind the user_id parameter
// Execute the statement
if (!$stmt->execute()) {
die("Error executing the query: " . $stmt->error);
}
// Get the result
$result = $stmt->get_result();
// Check if courses exist for the logged-in user
if ($result->num_rows > 0) {
echo '<table class="table table-striped">';
echo '<thead class="table-dark">';
echo '<tr>';
echo '<th scope="col">Select</th>';
echo '<th scope="col">Image</th>';
echo '<th scope="col">Course Name</th>';
echo '<th scope="col">Duration</th>';
echo '<th scope="col">Category</th>';
echo '</tr>';
echo '</thead>';
echo '<tbody>';
while ($row = $result->fetch_assoc()) {
// Convert the image path to a web server relative path
$imagePath = str_replace('C:/xampp/htdocs/', '/', htmlspecialchars($row['image']));
// Debugging: Print image path
echo "Image Path: " . $imagePath . "<br>";
echo '<tr>';
echo '<td><input type="radio" name="course_id" value="' . htmlspecialchars($row['course_id']) . '"></td>';
echo '<td><img src="' . $imagePath . '" alt="Course Image" width="100"></td>';
echo '<td class="module-name">' . htmlspecialchars($row['course_name']) . '</td>';
echo '<td>' . htmlspecialchars($row['duration']) . '</td>';
echo '<td>' . htmlspecialchars($row['category']) . '</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
} else {
echo '<p>No courses available at the moment.</p>';
}
// Close the statement and the connection
$stmt->close();
$conn->close();
?>
</div>
<button type="submit" class="btn btn-primary" style="margin-right: 10px;">Register</button>
<button type="button" id="preview-btn" class="btn btn-secondary">Preview Image</button>
</form>
</div>