如何从MySQL数据库中创建PHP中的动态下拉列表 [英] How to Create a Dynamic Drop Down List in PHP populated from MySQL Database

问题描述

我正在尝试使用PHP和mysql数据库创建一个动态下拉列表。我写了下面的代码，并给出了我的输出，但问题是它显示不同的下拉菜单为每个项目，我希望所有项目在一个单一的下拉列表。请仔细检查并指导我。

I am trying to create a dynamic drop down list using PHP and mysql database. I have written the following code and its giving me the output, but the problem is that its showing different drop-down menu for each item, I want all items in a single drop down list. Kindly check it and guide me.

        $select_query=          "Select name from category";
        $select_query_run =     mysql_query($select_query);
        while   ($select_query_array=   mysql_fetch_array($select_query_run) )
        {
            foreach ($select_query_array as $select_query_display)
            {
                echo "  
                    <select>
                        <option value='' >$select_query_display</option>                        
                    </select>
                ";


                }

            }

谢谢

推荐答案

摆脱内部foreach循环...它没有为您做任何事情，并移动开始和结束选择

Get rid of the inner foreach loop... it is doing nothing for you and move the start and end select tags outside of the while loop.

$select_query=          "Select name from category";
$select_query_run =     mysql_query($select_query);
echo "<select name='category'>";
while ($select_query_array=   mysql_fetch_array($select_query_run) )
{
   echo "<option value='' >".htmlspecialchars($select_query_array["name"])."</option>";
}
echo "</select>";

这篇关于如何从MySQL数据库中创建PHP中的动态下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！