mysql数据库下拉表单_从MySQL数据库提取数据到html下拉列表

I have a web site that contains a html form, in this form i have a dropdownlist with list of agents that works in the company, i want to fetch data from MySQL database to this dropdownlist so when you add a new agent his name will appear as a option in the drop down list .

Can you help me coding this php code please, thank you

解决方案

To do this you want to loop through each row of your query results and use this info for each of your drop down's options. You should be able to adjust the code below fairly easily to meet your needs.

// Assume $db is a PDO object

$query = $db->query("YOUR QUERY HERE"); // Run your query

echo ''; // Open your drop down box

// Loop through the query results, outputing the options one by one

while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

echo ''.$row['something'].'';

}

echo '';// Close your drop down box