将Select Options设置为等于MySQL Query - Set Select Options Equal To MySQL Query

Set Select Options Equal To MySQL Query

本文关键字：MySQL Query Select Options 设置 | 更新日期: 2023-09-27

我正在运行sql查询并返回结果，如何将选择列表设置为等于查询结果？以下是我的语法，但我不确定如何将返回的结果与select相关联？

默认情况下，我希望select的值为null。

<?php
 $servername = "localhost";
  $username = "username";
  $password = "password";
  $dbname = "dbTest";
  $conn = new mysqli($servername, $username, $password, $dbname);
  if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }
  $sql = "Select CONCAT_WS(' ', name1, name2) As 'employeeName' from employees";
  $result = $conn->query($sql);
  if ($result->num_rows > 0) 
  {
    while($row = $result->fetch_assoc()) { echo $row['employeename'] ."<br>"; }
  } 
  $conn->close();
?>  
<html>
    <body>
       <h4>Opening Header</h4>
        <form> 
          <select> 
            <option>Set this to $result</option>
          </select> 
        </form>
    </body>
</html>

EDIT--因此$result将包含类似的值

Bob Jones
Mitch Sandberg
Jose Mintz

我希望这三个值都是不同的值，可以在选择中进行选择。

只需将php脚本放在select标记之后，并将option标记放在循环中的echo上。

<html>
<body>
   <h4>Opening Header</h4>
    <form> 
      <select> 
      <option value="null" selected="selected">Default</option>
          <?php
         $servername = "localhost";
          $username = "username";
          $password = "password";
          $dbname = "dbTest";
          $conn = new mysqli($servername, $username, $password, $dbname);
          if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }
          $sql = "Select CONCAT_WS(' ', name1, name2) As 'employeeName' from employees";
          $result = $conn->query($sql);
          if ($result->num_rows > 0) 
          {
            while($row = $result->fetch_assoc()) { echo "<option value=".$row['employeename'].">".$row['employeename']."</option><br>"; }
          } 
          $conn->close();
        ?>
      </select> 
    </form>
</body>