从不同的表中获取并添加下拉菜单

Question

我已经有了一个启动连接，我想添加另一个下拉菜单，它将从不同的表中提取数据，并在我尝试工作时将其分配给所有用户，但它只显示一个用户，而数据库中有许多用户。当我删除下拉菜单时，它会显示数据库中的所有用户。

<div class="table-responsive">
<?php
include 'config.php';
$sql = "SELECT * FROM tbl_department";
$result = $conn->query($sql);

if ($result->num_rows > 0) {?>
<table>
<tr>
<th>NO</th>
<th>Department</th>
<th>Status</th>
<th>Action</th>
</tr>
<tbody>
<?php
$no = 1;
while($row = $result->fetch_assoc()) {
$session = $row['session'];
if ($session == "AM") {
$st = 'Morning';
}else{
$st = 'Afternoon';                                          
}?>

<tr>
<td><?php echo $no; ?></td>
<td><?php echo $row['department'] ?></td>
<td><?php echo $row['status'] ?></td>
<td><select class="form-control" id="school" required>
<option value="" selected disabled>-Select School-</option>
<?php
include '../database/config.php';
$sql = "SELECT * FROM tbl_school WHERE status = 'Active' ORDER BY name";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
print '<option value="'.$row['school_id'].'">'.$row['name'].'</option>';
}
} else {
}
?>
</td>
<?php
$no++;
}}?>
</tr>

</tbody>
</table>

Answer 1

是否包含'/database/config.php’；并包括"config.php"；来自不同的数据库源，如果是，您应该在两个不同的资源连接之间进行区分，或者正如@Sean所说，您应该更改tbl_school行和tbl_department行的变量名

我创建了$select_options作为保留tbl_school中所有行的示例，防止您查询每个tbl_department行：

<div class="table-responsive">
<?php

include '../database/config.php';
$sql = "SELECT * FROM tbl_school WHERE status = 'Active' ORDER BY name";
$result = $conn->query($sql);
$select_options = "";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$select_options .= '<option value="'.$row['school_id'].'">'.$row['name'].'</option>';
}
}
?>
<?php
include 'config.php';
$sql = "SELECT * FROM tbl_department";
$result = $conn->query($sql);
?>
<table>
<thead>
<tr>
<th>NO</th>
<th>Department</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<?php
if ($result->num_rows > 0) { 
?>
<tbody>
<?php
$no = 1;
while($row = $result->fetch_assoc()) {
$session = $row['session'];
if ($session == "AM") {
$st = 'Morning';
}else{
$st = 'Afternoon';                                          
}
?>
<tr>
<td><?php echo $no; ?></td>
<td><?php echo $row['department'] ?></td>
<td><?php echo $row['status'] ?></td>
<td>
<select class="form-control" id="school" required>
<option value="" selected disabled>-Select School-</option>
<?php
echo $select_options;
?>
</select>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
<?php
}
?>
</table>
</div>

Answer 2

要覆盖id，您可以在$select_options收集数据的地方获取它，或者您可以创建另一个值，比如说它是$collected_ids

$collected_ids = array();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$select_options .= '<option value="'.$row['school_id'].'">'.$row['name'].'</option>';
$collected_ids[] = $row['school_id'];
}
}