我有一个动态表单,其中用户可以在一个表单中添加兄弟姐妹
当用户单击该按钮时。系统将添加另一行兄弟姐妹名称、Date of Birth、Age和。
现在,兄弟的信息存储在我的dabatabe中,表名为 Siblings
我的问题是如何检索数据并根据行数以动态形式存储它,这是我的代码:
$querySiblings = "SELECT * FROM siblings WHERE stud_inven_id = '$id'";
$resultSib = mysqli_query($connections, $querySiblings);
confirm_query($resultSib);
$check_row = mysqli_num_rows($resultSib);
if($check_row > 0){
$fetch = mysqli_fetch_assoc($resultSib);
//retrieve the dynamic form here...
}
和我的动态表单:
<div class="row">
<div class="col-md-12">
<h4>Name of Sibling/s according to birth order including you:</h4>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Name of Siblings</label>
<input type="text" class="form-control" name="s_name[]" id="s_name">
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label>Date of Birth<span id="check"></span></label>
<input type="date" class="form-control" name="s_dob[]" id="s_dob" value="<?php echo date("Y-m-d"); ?>">
</div>
</div>
<div class="col-md-1">
<div class="form-group">
<label>Age<span id="check"></span></label>
<input type="text" class="form-control" name="s_age[]" id="s_age">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Education<span id="check"></span></label>
<input type="text" class="form-control" name="s_educ[]" id="s_educ">
</div>
</div>
</div>
<a href="#" id="addSiblings" class="btn btn-primary sib" >
<i class="fa fa-fw fa-md fa-user-plus"></i>
</a>
我正在更新用户信息的。提前感谢您的帮助。
发布于 2018-08-04 08:08:08
我认为最好的解决方案是使用while循环。
$querySiblings = "SELECT * FROM siblings WHERE stud_inven_id = '$id'";
$resultSib = mysqli_query($connections, $querySiblings);
confirm_query($resultSib);
while(($fetch = mysqli_fetch_assoc($resultSib)) != null){
// Your form with $fetch['sib_id'], $fetch['stud_inven_id'], etc...
echo <<<EOF
<div class="row">
<div class="col-md-12">
<h4>Name of Sibling/s according to birth order including you:</h4>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Name of Siblings</label>
<input type="text" class="form-control" name="s_name[]" id="s_name" value="$fetch[name]">
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label>Date of Birth<span id="check"></span></label>
<input type="date" class="form-control" name="s_dob[]" id="s_dob" value="$fetch[dob]">
</div>
</div>
<div class="col-md-1">
<div class="form-group">
<label>Age<span id="check"></span></label>
<input type="text" class="form-control" name="s_age[]" id="s_age" value="$fetch[age]">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Education<span id="check"></span></label>
<input type="text" class="form-control" name="s_educ[]" id="s_educ" value="$fetch[education]">
</div>
</div>
</div>
<a href="#" id="addSiblings" class="btn btn-primary sib" >
<i class="fa fa-fw fa-md fa-user-plus"></i>
</a>
EOF;
}
注意不要在最后一个“EOF”前添加空格或任何其他字符;
我希望这是你想要的。
发布于 2018-08-04 09:33:10
我注意到你的文本中写着“根据出生顺序”,所以我在你的查询中添加了额外的ORDER by。
这是我到目前为止想出来的:
<?php
$querySiblings = "SELECT * FROM siblings WHERE stud_inven_id = '$id' ORDER BY dob ASC";
$resultSib = mysqli_query($connections, $querySiblings);
confirm_query($resultSib);
$check_row = mysqli_num_rows($resultSib);
?>
<div class="row">
<div class="col-md-12">
<h4>Name of Siblings according to birth order including you:</h4>
</div>
</div>
<?php if ($check_row) { foreach (mysqli_fetch_all($resultSib, MYSQLI_ASSOC) as $results) { ?>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Name of Sibling</label>
<input type="text" class="form-control" value="<?= $results['name'] ?>" disabled>
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label>Date of Birth<span id="check"></span></label>
<input type="date" class="form-control" value="<?= $results['dob'] ?>" disabled>
</div>
</div>
<div class="col-md-1">
<div class="form-group">
<label>Age<span id="check"></span></label>
<input type="text" class="form-control" value="<?= $results['age'] ?>" disabled>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Education<span id="check"></span></label>
<input type="text" class="form-control" value="<?= $results['education'] ?>" disabled>
</div>
</div>
</div>
<?php }} ?>
https://stackoverflow.com/questions/51681239
复制相似问题