只能插入第一个和第二个值,其他值不能插入数据库.如何解决这个问题


<?php
require_once "config.php";
if(isset($_POST['save'])){
$values = array();
for($i=0 ; $i <count($_POST['working']); $i++) {
$values[] = '("' . $_POST['working']['day'][$i] . '","' . 
$_POST['working']['status'][$i] . '")'; }
$sql4 = "INSERT INTO working_day(day,status) VALUES " . implode(',', 
$values);
$result4=mysqli_query($connection,$sql4);}
?>
<form id="sendform" method="post" action="">
<input type="text" value="Monday" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]" />

<input type="text" value="Tuesday" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]" />
<input type="text" value="w" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]"  />
<input type="text" value="T" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]"  />
<input type="text" value="F" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]" />
<input type="text" value="S" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]"  />
<input type="text" value="S" id="day" name="working[day][]" readonly />
<input type="text" value="" id="status" name="working[status][]" />
<input type="submit" value="Send" name="save" />
</form>

**为什么这个代码只能插入第一天&状态和第二天&数据库中的状态?for循环计数[i]无法计数其他值。如何解决这个问题?**

下面给出了正确的方法:-

<?php
require_once "config.php";
if(isset($_POST['save'])){
$values = array();
for($i=0 ; $i <count($_POST['working']['day']); $i++) {
$values[] = '("' . $_POST['working']['day'][$i] . '","' . $_POST['working']['status'][$i] . '")'; 
}
$sql4 = "INSERT INTO working_day(day,status) VALUES " . implode(',', $values);
$result4=mysqli_query($connection,$sql4);
}

相关内容

最新更新