How can PHP be used to dynamically populate dropdown menus with course options from a database table in an enrollment form?

To dynamically populate dropdown menus with course options from a database table in an enrollment form, you can use PHP to query the database for the course options and then loop through the results to generate the dropdown menu options. This way, the dropdown menu will always display the most up-to-date list of available courses. 

<?php
// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "dbname";
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query database for course options
$sql = "SELECT course_id, course_name FROM courses";
$result = $conn->query($sql);

// Generate dropdown menu options
echo "<select name='course'>";
while($row = $result->fetch_assoc()) {
    echo "<option value='" . $row['course_id'] . "'>" . $row['course_name'] . "</option>";
}
echo "</select>";

// Close database connection
$conn->close();
?>

Keywords

PHP dropdown menus database table enrollment form dynamic population

Related Questions