How can PHP be used to dynamically populate a dropdown menu with database values for selection?

To dynamically populate a dropdown menu with database values in PHP, you can query the database to fetch the values and then loop through the results to generate the options for the dropdown menu. This can be achieved by using PHP code to connect to the database, execute the query, fetch the results, and then output the options within the HTML select element. 

<?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 fetch values from database
$sql = "SELECT id, name FROM table";
$result = $conn->query($sql);

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

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

Keywords

PHP dropdown menu database values dynamic population selection

Related Questions