提交后保留查询生成的下拉框的值 - Retaining value of query generated dropdown box after submission

Retaining value of query generated dropdown box after submission

本文关键字：保留查询提交 | 更新日期: 2023-09-27

我使用查询结果填充了下拉框的选项。用户提交后，如何保留所选值？

这是代码：

$query="SELECT trainingName,trainingID FROM training ORDER BY trainingName";
$result = mysql_query ($query);
echo "<select name='training' value=selected>Training Name</option>";
$training = strip_tags(@$_POST['training']);
echo "<option>---------------------Select---------------------</option>";
while($nt=mysql_fetch_array($result)){
echo "<option value=$nt[trainingID]>$nt[trainingName]</option>";
}

谢谢！

试试这个：

$query="SELECT trainingName,trainingID FROM training ORDER BY trainingName";
$result = mysql_query ($query);
echo "<select name='training'>";
echo "<option>---------------------Select---------------------</option>";
while($nt=mysql_fetch_array($result)){
   $selected = false;
   // check if the current value equals the value submited
   if($_POST['training'] == $nt['trainingID']){
       $selected = true;
   }
   // show selected attribute only if $selected is true
   echo "<option value='{$nt['trainingID']}' ". ($selected ? "selected" : "") .">{$nt['trainingName']}</option>";
}
echo '</select>';