How can PHP be used to dynamically populate dropdown menus with values from a database table?

To dynamically populate dropdown menus with values from a database table in PHP, you can first query the database to fetch the values and then use a loop to generate the <option> tags for the dropdown menu. Finally, echo out the generated options within the <select> tag to display the dropdown menu with the database values. 

&lt;?php
// Connect to database
$pdo = new PDO(&#039;mysql:host=localhost;dbname=database_name&#039;, &#039;username&#039;, &#039;password&#039;);

// Query to fetch values from database table
$stmt = $pdo-&gt;query(&quot;SELECT * FROM table_name&quot;);

// Generate dropdown menu options
$options = &#039;&#039;;
while ($row = $stmt-&gt;fetch(PDO::FETCH_ASSOC)) {
    $options .= &#039;&lt;option value=&quot;&#039; . $row[&#039;value_column&#039;] . &#039;&quot;&gt;&#039; . $row[&#039;display_column&#039;] . &#039;&lt;/option&gt;&#039;;
}

// Display dropdown menu
echo &#039;&lt;select name=&quot;dropdown&quot;&gt;&#039; . $options . &#039;&lt;/select&gt;&#039;;
?&gt;

Keywords

PHP dropdown menus database table dynamic population values

Related Questions