How can dynamic dropdown fields be created in PHP based on MySQL database entries?

Dynamic dropdown fields can be created in PHP based on MySQL database entries by querying the database for the options to populate the dropdown. The PHP code snippet below demonstrates how to connect to a MySQL database, retrieve the data for the dropdown options, and dynamically generate the dropdown field in HTML using the retrieved data. 

<?php
// Connect to MySQL 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 database for dropdown options
$sql = "SELECT option_value FROM dropdown_options";
$result = $conn->query($sql);

// Generate dropdown field in HTML
echo "<select name='dropdown'>";
while ($row = $result->fetch_assoc()) {
    echo "<option value='" . $row['option_value'] . "'>" . $row['option_value'] . "</option>";
}
echo "</select>";

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

Keywords

PHP MySQL dynamic dropdown database entries form generation

Related Questions