How can PHP be used to populate a dropdown menu with values from a MySQL database?

To populate a dropdown menu with values from a MySQL database using PHP, you can retrieve the data from the database using SQL queries and then loop through the results to generate the options for the dropdown menu. You can then echo out the HTML code for the dropdown menu with the dynamic options included. 

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

// Query to retrieve values from the database
$query = "SELECT id, name FROM dropdown_values";
$result = mysqli_query($connection, $query);

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

// Echo out the HTML code for the dropdown menu
echo '<select name="dropdown">' . $options . '</select>';

// Close the database connection
mysqli_close($connection);
?>

Keywords

PHP MySQL dropdown menu database values

Related Questions