How can PHP be used to dynamically generate dropdown options based on database values in a form?

To dynamically generate dropdown options based on database values in a form using PHP, you can query the database to retrieve the values and then loop through the results to create the dropdown options. You can then echo out the options within the select element in your HTML form. 

<?php
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Query to retrieve dropdown values from database
$sql = "SELECT id, option_value FROM dropdown_options";
$result = $conn->query($sql);

// Create dropdown options based on database values
echo '<select name="dropdown">';
while ($row = $result->fetch_assoc()) {
    echo '<option value="' . $row['id'] . '">' . $row['option_value'] . '</option>';
}
echo '</select>';

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

Related Questions