How can a dropdown menu be populated with values from a database in PHP?

To populate a dropdown menu with values from a database in PHP, you can first query the database to fetch the values you want to display in the dropdown menu. Then, iterate over the results and create HTML <option> tags for each value to be displayed in the dropdown menu. 

&lt;?php
// Connect to database
$servername = &quot;localhost&quot;;
$username = &quot;username&quot;;
$password = &quot;password&quot;;
$dbname = &quot;database_name&quot;;

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
}

// Query database to fetch values for dropdown menu
$sql = &quot;SELECT id, name FROM dropdown_values&quot;;
$result = $conn-&gt;query($sql);

// Create dropdown menu
echo &quot;&lt;select name=&#039;dropdown&#039;&gt;&quot;;
while($row = $result-&gt;fetch_assoc()) {
    echo &quot;&lt;option value=&#039;&quot; . $row[&#039;id&#039;] . &quot;&#039;&gt;&quot; . $row[&#039;name&#039;] . &quot;&lt;/option&gt;&quot;;
}
echo &quot;&lt;/select&gt;&quot;;

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

Keywords

PHP dropdown menu database values population

Related Questions