How can values from a database be dynamically assigned to each option in a dropdown list in PHP?

To dynamically assign values from a database to each option in a dropdown list in PHP, you can retrieve the values from the database using SQL queries and then loop through the results to populate the dropdown list options with the values. 

<?php
// Connect to the database
$connection = new mysqli('localhost', 'username', 'password', 'database_name');

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

// Retrieve values from the database
$query = "SELECT id, value FROM table_name";
$result = $connection->query($query);

// Populate dropdown list with values
echo '<select name="dropdown">';
while ($row = $result->fetch_assoc()) {
    echo '<option value="' . $row['id'] . '">' . $row['value'] . '</option>';
}
echo '</select>';

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

Keywords

PHP database dropdown list dynamic values

Related Questions