javascript - 如何从php中单击按钮时动态填充的下拉列表中获取值

Question

我陷入了从下拉菜单中获取值(value)的困境。下拉列表是从 SQL Server 数据库动态填充的。下拉菜单1显示产品名称，并且是动态填充的。下拉菜单 2 显示环境名称，由 HTML 填充。

我获得的是环境的值(value)，而不是产品的值(value)。请帮我。谢谢

这是代码:

<form action="" method="post">

//Dropdown 1
<p>Product Name:
<select name="productname">
  <option value="">Select</option>

<?php
if( $conn ) 
{
    $sql_dd = "SELECT ProductName from Product";
    $stmt = sqlsrv_query( $conn, $sql_dd );
        if( $stmt === false) {die( print_r( sqlsrv_errors(), true) );}
    $rows = sqlsrv_has_rows( $stmt );
    if ($rows === false)
        echo "There is no data. <br />";
    else 
    {    while( $row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) 
           echo "<option value=''>".$row['ProductName']."</option>";
    }
}
?>

//Dropdown 2
Client Type: 
<select name="environment" style="width: 10%;">
<option value="">Select</option>
<option value="en1">en1</option>
<option value="en2">en2</option>
<option value="en3">en3</option>
</select>&emsp;
<input type="submit" class="theme-btn" value="Search" name="submit"/>

<?php
if(isset($_POST['submit']) )
{
    $productname = $_POST['productname'];
    $environment= $_POST['environment'];

echo "productname: ".$productname." environment: ".$environment;
}?>

Answer 1

该值未添加这个:

echo "<option value=''>".$row['ProductName']."</option>";

应该是

echo "<option value='" . $row['ProductName'] . "'>". $row['ProductName'] ."</option>";