我在 html 输入表单中有一个复选框字段。在这个值是从另一个表中获取的。我想在这个复选框的帮助下选择多个用户。我的代码有什么问题<div class="form-group col-md-6"><label> Supervised BY( At IUAC)<span style="color:red;">*</span></label><input type="checkbox" name="user" > <br> <checkbox value=""> </checkbox><?php $sql = "SELECT * from tblstaff ";$query = $dbh -> prepare($sql);$query->execute();$results=$query->fetchAll(PDO::FETCH_OBJ);$cnt=1;if($query->rowCount() > 0){foreach($results as $result){ ?> <option value="<?php echo htmlentities($result->id);?>"><?php echo htmlentities($result->name);?></option> <?php }} ?>我试过这个代码但它没有显示复选框
3 回答
白猪掌柜的
TA贡献1893条经验 获得超10个赞
使用输入类型Checkbox字段像这样
<?php
foreach($results as $result)
{ ?>
<input type="checkbox" name="<?php echo $result->name; ?>" value="<?php echo $result->name; ?>"> <?php echo $result->name; ?> </br>
<?php } ?>
桃花长相依
TA贡献1860条经验 获得超8个赞
<input type="checkbox">
正确代码：
<div class="form-group col-md-6">
<label> Supervised BY( At IUAC)<span style="color:red;">*</span></label>
<?php
$sql = "SELECT * from tblstaff ";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{
?>
<input type="checkbox" name="user" value="<?php echo htmlentities($result->id);?>"><?php echo htmlentities($result->name);?><br>
<?php
}}
?>
编辑：尝试使用multiple属性<select>
<?php
$sql = "SELECT * from tblstaff ";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
echo "<select name='user' multiple>";
foreach($results as $result)
{
?>
<option value="<?php echo htmlentities($result->id);?>"><?php echo htmlentities($result->name);?></option>
<?php
}
echo "</select>";
}
?>
德玛西亚99
TA贡献1770条经验 获得超3个赞
你可以bootstrap-multiselect像这样使用
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Dropdown Multi Select</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css" type="text/css" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-multiselect/0.9.12/css/bootstrap-multiselect.css" type="text/css" />
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<script type="text/javascript" src="https://maxcdn.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-multiselect/0.9.15/js/bootstrap-multiselect.js"></script>
</head>
<body>
<form id="formone">
<div style="padding:20px">
<select id="chkone" multiple="multiple">
<?php
$sql = "SELECT * from tblstaff ";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<option value="<?php echo htmlentities($result->id);?>"><?php echo htmlentities($result->name);?></option>
<?php }} ?>
</select>
</div>
</form>
</body>
<script type="text/javascript">
$(function() {
$('#chkone').multiselect({
includeSelectAllOption: true
});
});
</script>
</html>
添加回答
举报
0/150
提交
取消