21,886
社区成员
发帖
与我相关
我的任务
分享
<label class="form-label col-xs-4 col-sm-2">
<span class="label label-success radius"> 使用部门:</span>
</label>
<div class="formControls col-xs-8 col-sm-4">
<span class="select-box">
<select name="frm_UsingDepartment_Name" class="select">
<option value="0">请选择使用部门</option>
<?php
$sql = "select * from catageory_department";//sql语句
$result = mysqli_query($link, $sql);//执行sql语句
while ($row = mysqli_fetch_assoc($result)) {
//循环,拼凑下拉框选项
?>
<option value="<?php echo $row['department_name'];?>"><?php echo $row['department_name'] ?></option>
<?php
}
?>
</select>
</span>
</div>
<label class="form-label col-xs-4 col-sm-2">
<span class="label label-success radius"> 设备类别:</span>
</label>
<div class="formControls col-xs-8 col-sm-4">
<span class="select-box">
<select name="frm_Device_Type" class="select">
<option value="0">请选择设备类别</option>
<?php
$sql = "select * from catageory_device";//sql语句
$result = mysqli_query($link, $sql);//执行sql语句
while ($row = mysqli_fetch_assoc($result)) {
//循环,拼凑下拉框选项
?>
<option value="<?php echo $row['type_name'];?>"><?php echo $row['type_name'] ?></option>
<?php
}
?>
</select>
</span>
</div>
$UsingDepartment_Name = $_REQUEST['frm_UsingDepartment_Name'];
$Device_Type = $_REQUEST['frm_Device_Type'];