php - 从使用 mysql 填充列表的所选选项中打印 2 个值

Question

我有一个正在处理查询的 mysql 连接。

<?php
$enlace = mysqli_connect ('localhost:3306',  'user', 'pass');

$consulta = "SELECT id, nameFROM dbapps.dbapp";
$result=mysqli_query($enlace, $consulta);
?>

我有一个包含 2 个值的 SELECT。选项值=ID描述 = id + 名称

<select name="sqllist[]" multiple> 
<?php 
while($row = mysqli_fetch_row($result))
{
    echo "<option value=" .$row['0'].">".$row['0']."  ".$row['1']."</option>";
}

?>
</select>

我正在获取选定的值，但我想通过一个变量获取选定的 id 以及与其他变量的 id 相关的名称

if(isset($_POST['submit'])){
    foreach ($_POST['sqllist'] as $select)
    {
        echo $select."<br>"; 
    }
}

Answer 1

// Read all the results from the query
$rows = mysqli_fetch_all ( $result, MYSQLI_ASSOC);

// Id/name map
$names = array_column($rows, 'name', 'id');

// If the data was submitted, use it, otherwise, consider the list empty
$sqllist = isset($_POST['submit']) ? $_POST['sqllist'] : [];

// Create the select statement
<select name="sqllist[]" multiple> 
<?php 
foreach ($rows as $row)
{
    // If the id for this row is in the sqllist, set the selected attribute
    $selected = in_array($row['id'],$sqllist) ? 'selected' : '';
    echo "<option $selected value='" .$row['id']."'>".$row['id']."  ".$row['name']."</option>";
}
?>
</select>
<?php
foreach ($sqllist as $id) {
    echo $id.' '.$names[$id].'<br>';
}