如何在从 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 循环......它对你没有任何作用，并将开始和结束选择标签移到 while 循环之外.

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屋！