Php选择(选项列表) - Php select (Option list)

Php select (Option list)

本文关键字：列表选项选择 Php | 更新日期: 2023-09-27

我正在使用这些代码

$query = "SELECT date  FROM arrival order by date" ; 
$result = mysqli_query($con,$query)or die ("Error". mysqli_error($con)) ;  
echo "<select name='per1' id='per1'>";
while ($row = mysqli_fetch_array ($result)){?>
<option value=<?php echo $row['date'];?> selected='selected'><?php echo $row['date'];?></option>
</select>
<?php
}
?>

选择(选项列表)显示数据

<>之前2016-07-012016-07-022016-07-032016-07-042016-07-052016-07-06等等......之前

不像一个下拉选项列表。如何使它像下拉列表?

我想从选项中选择一个日期

多次关闭while中的select。把</select>移到外面

}?> </select>

您还应该引用属性值。完整的示例:

$query = "SELECT date  FROM arrival order by date" ; 
$result = mysqli_query($con,$query)or die ("Error". mysqli_error($con)) ;  
echo "<select name='per1' id='per1'>";
while ($row = mysqli_fetch_array ($result)){?>
<option value='<?php echo $row['date'];?>' selected='selected'><?php echo $row['date'];?></option>
<?php } ?>
</select>

稍微整理一下，试试这个

$query = "SELECT date  FROM arrival order by date" ; 
$result = mysqli_query($con,$query)or die ("Error". mysqli_error($con)) ;
$result_array = array();
while($row = mysql_fetch_assoc($result))
{
$result_array[] = $row['date'];
}
echo "<select name='per1' id='per1'>";
foreach($result_array as $name){
echo'<option value="'.$name.'">'.$name.'</option>';
}
echo'</select>';

我相信这会是你想要的。