使用echo的默认“Please Select”值

Question

我正在尝试在我的值之前添加“请选择”。

<?php
      include "dbconnect.php";
      $resultSet = $con->query("SELECT eventDuration, durationName FROM tbl_duration");
      ?>
   <label class="col-sm-2 control-label" for="eventDuration">Duration:</label>
   <div class="col-sm-10">
      <select name="eventDuration">
      <?php
         while($rows = $resultSet->fetch_assoc())
         {
            $durationName = $rows['durationName'];
         echo "<option value='0'>Please select...</option>";
            echo "<option value='$durationName'>$durationName</option>";
         }
         ?>
      </select>
   </div>

我尝试了上面的代码，但结果是重复的，如下所示。我怎样才能使它不再重演呢？

Please select
1 Day
Please select
2 Days
Please select
3 Days

Answer 1

您可以将默认的从循环中取出。

<?php
include "dbconnect.php";
$resultSet = $con->query("SELECT eventDuration, durationName FROM tbl_duration");
?>
<label class="col-sm-2 control-label" for="eventDuration">Duration:</label>
<div class="col-sm-10">
    <select name="eventDuration">
        <option value='0'>Please select...</option>
        <?php foreach ($resultSet as $row): ?>
        <option value='<?=htmlspecialchars($row['durationName']) ?>'><?=htmlspecialchars($row['durationName']) ?></option>
        <?php endforeach; ?>
    </select>
</div>