What is the purpose of using a dropdown menu to display values from a database in PHP?

Using a dropdown menu to display values from a database in PHP allows users to select from a list of options retrieved from the database. This can be useful for forms where users need to choose from a predefined set of values. To implement this, you need to query the database to fetch the values, loop through the results to populate the dropdown menu options, and then display the dropdown menu 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 fetch values from database
$sql = "SELECT id, name FROM table";
$result = $conn->query($sql);

// Populate 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 display

Related Questions