What is the best practice for dynamically populating a dropdown list in PHP with values from a MySQL database?

When dynamically populating a dropdown list in PHP with values from a MySQL database, the best practice is to first establish a connection to the database, retrieve the data you want to populate the dropdown with, and then loop through the data to create the dropdown options. You can achieve this by using PHP's MySQLi or PDO extension to connect to the database and fetch the data. 

<?php
// Establish a connection to the 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 data for dropdown list
$sql = "SELECT id, name FROM table";
$result = $conn->query($sql);

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

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

Keywords

PHP MySQL dropdown list dynamic population database retrieval

Related Questions