如何获取选项源自数据库的下拉菜单选中值？

你的核心问题是表单结构错误加上下拉菜单缺少name属性，导致提交后PHP拿不到选中值——和选项来自数据库完全没关系，不管选项是静态写死还是动态从数据库生成，获取选中值的逻辑都是一样的。下面分两种场景给你解决方案：

一、表单提交后用PHP获取选中值（适合点击按钮查询的场景） #

关键修正点： #

• 把<form>标签移到<fieldset>外面，确保所有表单元素（下拉框、提交按钮）都在form内部，否则提交时不会传递下拉框的选中值。
• 给每个<select>添加name属性，PHP通过$_POST['name值']就能拿到对应的选中值。
• 移除<option>里的<br>标签，这是无效的HTML语法，会导致选项显示异常。
• 把查询SQL里硬编码的'Malaysia'换成获取到的选中值，同时必须做SQL注入防护（用mysqli预处理语句）。

修正后的完整代码： #

<div class="one">
    <form method="post">
        <fieldset>
            <legend>Commodity Balance:</legend>
            <?php
            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "dbtest";
            $usertable_commodity = "t_commodity";
            $columnname_commodity = "commodity";
            $usertable_country = "t_country";
            $columnname_country = "country";
            $usertable_mood = "t_mood";
            $columnname_mood = "commodity";

            $mysqli = new mysqli($servername, $username, $password, $dbname);
            if ($mysqli->connect_errno) {
                echo "Failed to connect to MySQL: " . $mysqli->connect_error;
                exit();
            }

            $sql_commodity = "select * from $usertable_commodity";
            $result_commodity = $mysqli->query($sql_commodity);
            $sql_country = "select * from $usertable_country";
            $result_country = $mysqli->query($sql_country);
            ?>

            <label for="Commoditylb">Commodity/Country:</label>
            <!-- 给select添加name属性，id和label的for对应 -->
            <select name="selected_commodity" id="Commoditylb" style="border: 2px solid black;border-radius: 2px;">
                <option value="">请选择商品</option>
                <?php
                if ($result_commodity) {
                    while ($row = mysqli_fetch_array($result_commodity)) {
                        $stname_commodity = $row[$columnname_commodity];
                        // 给option设置value属性，和显示文本一致（如果数据库有ID也可以用ID）
                        echo "<option value=\"$stname_commodity\">$stname_commodity</option>";
                    }
                }
                ?>
            </select>

            <select name="selected_country" style="border: 2px solid black;border-radius: 2px;">
                <option value="">请选择国家</option>
                <?php
                if ($result_country) {
                    while ($row = mysqli_fetch_array($result_country)) {
                        $stname_country = $row[$columnname_country];
                        echo "<option value=\"$stname_country\">$stname_country</option>";
                    }
                }
                ?>
            </select>

            <?php
            if (isset($_POST['button1'])) {
                // 获取提交的选中值，先判断是否为空
                $selectedCountry = $_POST['selected_country'] ?? '';
                $selectedCommodity = $_POST['selected_commodity'] ?? '';

                if (!empty($selectedCountry)) {
                    // 用预处理语句防止SQL注入
                    $sql_mood = "select * from $usertable_mood where country = ?";
                    $stmt = $mysqli->prepare($sql_mood);
                    $stmt->bind_param("s", $selectedCountry);
                    $stmt->execute();
                    $result_mood = $stmt->get_result();

                    if ($result_mood && $result_mood->num_rows > 0) {
                        while ($row = mysqli_fetch_array($result_mood)) {
                            $stname_mood = $row[$columnname_mood];
                            echo "<p>$stname_mood</p>";
                        }
                    } else {
                        echo "没有找到对应数据";
                    }
                    $stmt->close();
                } else {
                    echo "请选择国家";
                }
            }
            ?>

            <input type="submit" name="button1" value="查询数据" />
        </fieldset>
    </form>
</div>

二、用JavaScript实时获取选中值（适合无需提交表单，实时触发查询的场景） #

如果想选中选项后立刻查询，不需要点击按钮，可以给select加onchange事件，用JS获取选中值，再通过AJAX请求PHP接口获取数据：

1. 给select添加id和onchange事件： #

<select id="commoditySelect" onchange="fetchData()" style="border: 2px solid black;border-radius: 2px;">
    <!-- 选项生成逻辑不变 -->
</select>
<select id="countrySelect" onchange="fetchData()" style="border: 2px solid black;border-radius: 2px;">
    <!-- 选项生成逻辑不变 -->
</select>
<!-- 用来显示查询结果的容器 -->
<div id="resultContainer"></div>

2. 编写JavaScript的fetchData函数： #

function fetchData() {
    // 获取选中值
    const commodity = document.getElementById('commoditySelect').value;
    const country = document.getElementById('countrySelect').value;

    if (!commodity || !country) {
        document.getElementById('resultContainer').innerHTML = "请选择完整选项";
        return;
    }

    // 用fetch发送AJAX请求
    fetch('fetch_data.php', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/x-www-form-urlencoded',
        },
        body: `commodity=${encodeURIComponent(commodity)}&country=${encodeURIComponent(country)}`
    })
    .then(response => response.text())
    .then(data => {
        document.getElementById('resultContainer').innerHTML = data;
    })
    .catch(error => {
        document.getElementById('resultContainer').innerHTML = "查询出错：" + error;
    });
}

3. 创建fetch_data.php处理查询： #

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dbtest";
$usertable_mood = "t_mood";
$columnname_mood = "commodity";

$mysqli = new mysqli($servername, $username, $password, $dbname);
if ($mysqli->connect_errno) {
    echo "数据库连接失败：" . $mysqli->connect_error;
    exit();
}

$commodity = $_POST['commodity'] ?? '';
$country = $_POST['country'] ?? '';

if (!empty($commodity) && !empty($country)) {
    $sql = "select * from $usertable_mood where commodity = ? and country = ?";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("ss", $commodity, $country);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($result->num_rows > 0) {
        while ($row = mysqli_fetch_array($result)) {
            echo "<p>" . $row[$columnname_mood] . "</p>";
        }
    } else {
        echo "无匹配数据";
    }
    $stmt->close();
} else {
    echo "参数不全";
}
$mysqli->close();
?>

核心要点总结 #

• 不管选项是静态还是动态生成，获取选中值的逻辑完全一致：PHP靠name属性拿$_POST值，JS靠id或DOM选择器拿value。
• 永远要做SQL注入防护，用预处理语句代替直接拼接SQL。
• 表单元素必须放在<form>内部，否则提交时不会传递数据。

内容的提问来源于stack exchange，提问作者Va SA