如何在下拉菜单中输出MySql行 - How to Output MySql rows in Drop Down Menu

How to Output MySql rows in Drop Down Menu

本文关键字：输出 MySql 下拉菜单 | 更新日期: 2023-09-27

我在这段代码中遇到了一个问题：`

                 <?php echo "Choose a date"; 
                     $reservation_date = $rm->retrieveReservation(); 
                              $data_date = array();
                              while($row_date = mysql_fetch_assoc($reservation_date)){
                                array_push($data_date, $row_date);
                                $dateOptions = ""
    .                               "<select class='filter'>"
    .                                  "<option value='<?php echo $row['date']  ; ?>'><?php echo $row['date']  ; ?></option>"
    .                               "</select>";
                                echo $dateOptions;
                              } ?>
                           ?>

我想在下拉菜单中输出Sql行值。提前感谢！

您不必在这段时间内回显<select>，您应该这样做：

 <?php echo "Choose a date"; 
                 $reservation_date = $rm->retrieveReservation(); 
                          $data_date = array();
                          $dateOptions = "<select class='filter'>";
                          while($row = mysql_fetch_assoc($reservation_date)){
                            array_push($data_date, $row_date);
                            $dateOptions = "<option value='". $row['date']."'>". $row['date'] ."</option>";
                          } ?>
                          $dateOptions = "</select>";
                          echo $dateOptions;
                       ?>

这应该有效：

echo "<select class='filter'>";
while($row = mysql_fetch_assoc($reservation_date)){
    echo "<option value='".$row['date']."'>".$row['date']."</option>";
}
echo "</select>";

您需要将select标记置于循环之外。您的PHP中也有一些语法错误。

 <?php echo "Choose a date"; 
       echo "<select class='filter'>";
       $reservation_date = $rm->retrieveReservation(); 
              $data_date = array();
              while($row_date = mysql_fetch_assoc($reservation_date)){
                  array_push($data_date, $row_date);
                  $dateOptions = "<option value='{$row['date']}'>{$row['date']}</option>";
                  echo $dateOptions;
              } 
       echo  "</select>";
 ?>

愿这个代码对你有用。