gpt4 book ai didi

php - 只能插入第一个和第二个值,其他值不能插入数据库中。怎么解决这个问题?

转载 作者:行者123 更新时间:2023-11-29 09:58:18 25 4
gpt4 key购买 nike

  <?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 循环 count[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);
}

关于php - 只能插入第一个和第二个值,其他值不能插入数据库中。怎么解决这个问题?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/53475150/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com