我正在从构建器表中获取数据并将其显示在下拉列表中,这是代码。
<select style="width:154px;">
<?php
include('connection.php');
$show_builder = "SELECT * FROM builders";
$result_builder = mysqli_query($conn,$show_builder);
while($data_builder = mysqli_fetch_array($result_builder)){
echo"<option>".$data_builder['builder_name']."</option>";
}
?>
我想选择一个值并将其作为id
存储在用户表中,作为表中的builder_id
。
<?php
include('connection.php');
$show_builder = "SELECT * FROM builders";
$result_builder = mysqli_query($conn,$show_builder);
echo '<select name="builder">';
while($data_builder = mysqli_fetch_array($result_builder)){
echo'<option value="'.$data_builder['id'].'" >'.$data_builder['builder_name'].'</option>';
}
echo "</select>";
?>
简而言之,
您必须拥有select
name
属性,并将builder_id
添加为option
标签value
属性:
<select name="builder_id" style="width:154px;">
<?php
include('connection.php');
$show_builder = "SELECT * FROM builders";
$result_builder = mysqli_query($conn, $show_builder);
while ($data_builder = mysqli_fetch_array($result_builder)) {
echo '<option value="'.$data_builder['builder_id'].'">' . $data_builder['builder_name'] . '</option>';
}
?>
</select>