php - 我的 php 表单只保存表的最后一行。
问题描述
我在一个表格(new_tear.php)中有一个表格,它从单个用户那里获取数据。第一个 cloumn 是从带有名称的数据库表 (ProfileTable) 中填充的。用户必须从下拉列表中为每一行(每个名称)选择一个选项。提交表单时(POST 到 tear_done.php),我想将每一行存储在我的数据库中。但是,我每次只看到最后一行
new_ter.php
<?php
$sqlT1 = "SELECT * FROM ProfileTable WHERE dept = 'T1'";
$queryT1 = mysqli_query($conn, $sqlT1);
if (!$queryT1) {
die ('SQL Error: ' . mysqli_error($conn));
}
?>
<form action="tear_done.php" method="post">
<table>
<?php
$no = 1;
while ($row = mysqli_fetch_array($queryT1))
{
echo '<tr>
<td>'.$no.'</td>
<td>'.$row['name'].'</td>
<td><select id="Dz_M" name="Dz_M">
<option value="4pm">4pm</option>
<option value="8am">8am</option>
<option value="Rest">Rest</option>
</select><br>
</td>
<td><select id="Dz_T" name="Dz_T">
<option value="4pm">4pm</option>
<option value="8am">8am</option>
<option value="Rest">Rest</option>
</select><br>
</td>
<td><select id="Dz_W" name="Dz_W">
<option value="4pm">4pm</option>
<option value="8am">8am</option>
<option value="Rest">Rest</option>
</select><br>
</td>
<td><select id="Dz_F" name="Dz_F">
<option value="4pm">4pm</option>
<option value="8am">8am</option>
<option value="Rest">Rest</option>
</select><br>
</td>
<td><select id="Dz_S" name="Dz_S">
<option value="4pm">4pm</option>
<option value="8am">8am</option>
<option value="Rest">Rest</option>
</select><br>
</td>
</tr>';
$no++;
$no_cont = $no;
}?>
</table>
<br>
<button value="save" type="submit" name="save">Save Tear</button>
</form>
撕裂完成.php
<?php
$sqlT1 = "SELECT * FROM ProfileTable WHERE dept = 'T1'";
$queryT1 = mysqli_query($conn, $sqlT1);
if (!$queryT1) {
die ('SQL Error: ' . mysqli_error($conn));
}
$no = 1;
while ($row = mysqli_fetch_array($queryT1))
{
$Name = $row ['name'];
$Dept = $row ['dept'];
$DZ_M = $_POST ["Dz_M"];
$DZ_T = $_POST ["Dz_T"];
$DZ_W = $_POST ["Dz_W"];
$DZ_F = $_POST ["Dz_F"];
$DZ_S = $_POST ["Dz_S"];
$sql = "INSERT INTO TearTable (name, Mdy, Tdy, Wdy, Fdy, Sdy, dept)
VALUES ('$Name', '$DZ_M', '$DZ_T', '$DZ_W', '$DZ_F', '$DZ_S', '$Dept')";
echo $no;
echo '<br>';
echo $sql; //for testing
echo '<br>';
$no++;
}
?>
我从回显中得到的是所有名称和部门都正确的 sql,但是其他字段 $DZ_M、$DZ_T 等仅重复从 new_tear.php 中的表输入的最后一行。请问我错过了什么?
解决方案
在 While 循环内只需连接插入查询字符串
while ($row = mysqli_fetch_array($queryT1))
{
......
$sql .= "INSERT INTO TearTable (name, Mdy, Tdy, Wdy, Fdy, Sdy, dept)
VALUES ('$Name', '$DZ_M', '$DZ_T', '$DZ_W', '$DZ_F', '$DZ_S', '$Dept');"; // Note .= and semicolon at the end
.....
}
// Outside the loop
execute your query here..
出于安全原因,您应该使用准备好的语句
推荐阅读
- python - Pip 成功安装模块未找到:ImportError: No module named xlwt
- virtualenv - 对同一个 DAG 中的不同任务使用不同的 pandas 版本(气流)
- android - Android 5.1 选择键盘不起作用
- linux - 在 Arch linux 中更改 powerbutton 角色不起作用?
- r - 按 purrr::cross3 中的位置过滤
- amazon-web-services - Designing a User Table with different Identity providers in DynamoDB
- typescript - element.offsetWidth always return 0
- python - PowerShell on MaxOs versionInfo is empty
- angular - How to retain the values selected in a popup when the popup is reloaded again in Angular?
- spring-boot - Waiting for kafka consumer to complete its operations