我正在使用一种表单,其中用户添加一个或多个输入值
<form class="col s12" action="my_resume.php" method="post" enctype="multipart/form-data">
<div class="row">
<div class="col s12" style="padding-top: 12px;">
<div class="col s12 m12 ">
<div id="dynamic_field">
<div>
<div class="col s12 m12 "><label for="title">Title</label>
<textarea class="materialize-textarea" style="padding: 0px;" id="title" name="title[]"></textarea>
</div>
<div class="col s12 m12 "><label for="title">Location</label>
<textarea id="location" name="location[]" class="materialize-textarea" style="padding: 0px;"></textarea>
</div>
<div class="col s3 m3 "><label for="title">Marks</label>
<input id="marks" name="marks[]" type="text" value="" />
</div>
<div class="col s3 m3 "><label for="title">Division</label>
<input id="divsion" name="divsion[]" type="text" value="" />
</div>
<div class="col s3 m3 "><label for="title">Year</label>
<input id="year" name="year[]" type="text" value="" />
</div>
<div class="col s3 m3"><button type="button" name="add" id="add" class="btn btn-success pull-right">Add More</button></div>
</div>
</div>
<div class="row">
<div class="input-field col s6">
<button class="btn waves-effect waves-light right"
type="submit" name="submit">Save
<i class="mdi-content-send right"></i>
</button>
</div>
</div>
</div>
</div>
</div>
</form>
用户可以通过单击添加更多按钮来添加有关他的教育的更多信息,当单击关闭按钮时,div 将消失
<script>
$(document).ready(function(){
var i=1;
$('#add').click(function(){
i++;
$('#dynamic_field').append('<div id="row'+i+'"><div class="col s12 m12 "><label for="title">Title</label><textarea class="materialize-textarea" style="padding: 0px;" id="title" name="title[]"></textarea></div><div class="col s12 m12 "><label for="title">Location</label><textarea id="location" name="location[]" class="materialize-textarea" style="padding: 0px;"></textarea></div><div class="col s3 m3 "><label for="title">Marks</label><input id="marks" name="marks[]" type="text" value="" /></div><div class="col s3 m3 "><label for="title">Division</label><input id="divsion" name="divsion[]" type="text" value="" /></div><div class="col s3 m3 "><label for="title">Year</label><input id="year" name="year[]" type="text" value="" /></div><div class="col s3 m3"><button type="button" name="remove" id="'+i+'" class="btn btn-danger button btn_remove">X</button></div></div>');
$('.btn_remove').click(function(){
var button_id = $(this).attr("id");
$('#row'+button_id+'').remove();
});
});
</script>
我很困惑如何将多个输入值插入到数据库中我是这样尝试的。
<?php
// Submit Form
if(isset($_POST['submit'])){
$field1_array = isset($_POST['marks']) ? $_POST['divsion'] : array();
$total_rows = count($field1_array);
for($i=0 ; $i<$total_rows;$i++){
$trans = array("degree"=>$_POST['title'][$i],"location"=>$_POST['location'][$i],"marks"=>$_POST['marks'][$i],"divsion"=>$_POST['divsion'][$i],"passing_year"=>$_POST['year'][$i]);
$query = ("Insert into tbl_student_education".$trans);
}
}
?>
<script>alert('Record Save Successfully');</script>
<?php } ?>
尝试下面的代码插入多个数据
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// Submit Form
if(isset($_POST['submit'])){
$total_rows = !empty($_POST['marks'])?count($_POST['marks']):0;
if ($total_rows > 0) {
for($i=0 ; $i<$total_rows;$i++){
$sql = "INSERT INTO tbl_student_education (degree, location, marks,divsion,passing_year) VALUES ('".$_POST['title'][$i]."', '".$_POST['location'][$i]."', '".$_POST['marks'][$i]."','".$_POST['divsion'][$i]."','".$_POST['year'][$i]."')";
$query = mysqli_multi_query($conn, $sql);
}
if ($query) {
?><script>alert('Record Save Successfully');</script><?php
}else{
?><script>alert('somethings went wrong');</script><?php
}
}else{
?><script>alert('No data');</script><?php
}
}
?>
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句