无法填充所有下拉框，只能先从PHP中的数据库填充

Question

这是我的代码只有第一个下拉框正在填充。我可以重复下拉框，但无法填充所有下拉框。请帮帮我...

$sel='select Driver_name from driver_master';
$query=mysqli_query($conn,$sel);
$sel1='select d_status from status';
$query1=mysqli_query($conn,$sel1);

echo "<form action='driver_status.php' method='post'>";
echo "<table cellpadding=5>";
echo "<tr>";
echo "<th>Driver Name</th>";
echo "<th>Status</th>";
echo "<th>From</th>";
echo "<th>To</th>";
echo "</tr>";
while($row=mysqli_fetch_assoc($query)){    
    echo "<tr>";
    echo "<td>".$row['Driver_name']."</td>";?>
    <td><select>
<?php while($row1=mysqli_fetch_assoc($query1)){  
    $st=$row1['d_status'];
    echo "<option value='$st'>$st</option>";
    }?>
    </select></td>
<?php
    echo "</tr>";      
}
echo "</table>";
echo '<input type="submit" name="sub" value="Update"/>';
echo "</form>";

我可以重复下拉框，但无法填充所有下拉框。请帮帮我...

我想将数据库中的数据显示到所有下拉框中，并保存所选值。我使用的提交按钮不起作用，请告诉我原因？

Answer 1

$sel='select Driver_name from driver_master';
$query=mysqli_query($conn,$sel);
$sel1='select d_status from status';
$query1=mysqli_query($conn,$sel1);

echo "<form action='driver_status.php' method='post'>";
echo "<table cellpadding=5>";
echo "<tr>";
echo "<th>Driver Name</th>";
echo "<th>Status</th>";
echo "<th>From</th>";
echo "<th>To</th>";
echo "</tr>";
do {    
    echo "<tr>";
    echo "<td>".$row['Driver_name']."</td>";?>
    <td><select>
<?php do{  
    $st=$row1['d_status'];
    echo "<option value='$st'>$st</option>";
    }while($row1=mysqli_fetch_array($query1)); ?>
    </select></td>
<?php
    echo "</tr>";      
}while($row=mysqli_fetch_array($query));
echo "</table>";
echo '<input type="submit" name="sub" value="Update"/>';
echo "</form>";

Answer 2

我对您的代码做了一些重大更改。在下面的代码中，我将一些变量重命名为一些可读性更强的名称，这样您就不会陷入混乱。

我将检索状态的查询结果保存到一个变量中，您可以轻松地在Foreach循环中重用该变量。我还编辑了html部分，并使它完全PHP节省了一些开始和结束标记与PHP。

如果你怀疑从查询中得到的值与你期望的不太一样，首先在PHPmyadmin中尝试一下，这样你就知道不是PHP语法或格式把它们弄乱了。

我还为select元素指定了一个名称，以便您可以在PHP中链接传递的值。您可以使用print\r（$\u POST） 处于驱动程序状态。php来检查哪些值通过。

<?php
$query_driver = 'select Driver_name from driver_master';
$result_driver = mysqli_query($conn, $query_driver);
$query_statuses ='select d_status from status';
$result_statuses = mysqli_query($conn, $query_statuses);
while($row_status = mysqli_fetch_assoc($result_statuses)){
    $statuses[] = $row_status['d_status'];
}

// $statuses now contains all statuses from the query this saves extra unnecessary queries.

echo "<form action='driver_status.php' method='post'>";
echo "<table cellpadding=5>";
    echo "<tr>";
    echo "<th>Driver Name</th>";
    echo "<th>Status</th>";
    echo "<th>From</th>";
    echo "<th>To</th>";
echo "</tr>";
while($row_driver = mysqli_fetch_assoc($result_driver)){   
    echo "<tr>";
        echo "<td>".$row_driver['Driver_name']."</td>";
        echo "<td><select name='drivers[". $row_driver['Driver_name'] ."][status]'>";
        foreach($statuses as $status){
            echo "<option value='". $status . "'>". $status . "</option>";
        }
        echo "</select>";
        echo "</td>";
    echo "</tr>";      
}
echo "</table>";
echo '<input type="submit" name="sub" value="Update"/>';
echo "</form>";