<?php
foreach ($xmorder as $xmrow) {
$nr_1 = htmlspecialchars($xmrow['nr_1']);
$nr_2 = htmlspecialchars($xmrow['nr_2']);
$nr_3 = htmlspecialchars($xmrow['nr_3']);
$nr_4 = htmlspecialchars($xmrow['nr_4']);
echo "<div><form>
<button class='btn-primary' type='submit' id='tg' name='tg'>通过</button>
<button class='btn-secondary' type='submit' id='wks' name='wks'>未考试</button>";
// 输出表格
echo "<table style='font-size: 10px;background:#f2f2f2'>";
echo "<tr>";
echo "<th style='width: 5%;background:#8eb832'>分组</th>";
echo "<th style='width: 5%;background:#8eb832'>顺序</th>";
echo "<th style='width: 17%;background:#8eb832'>姓名</th>";
echo "<th style='width: 5%;background:#8eb832'>性别</th>";
echo "<th style='width: 5%;background:#8eb832'>服装</th>";
echo "<th style='width: 12%;font-size: 8px;background:#8eb832'>{$nr_1}</th>";
echo "<th style='width: 12%;font-size: 8px;background:#8eb832'>{$nr_2}</th>";
echo "<th style='width: 12%;font-size: 8px;background:#8eb832'>{$nr_3}</th>";
echo "<th style='width: 12%;font-size: 8px;background:#8eb832'>{$nr_4}</th>";
echo "<th style='width: 15%;background:#8eb832'>结果</th>";
echo "</tr>";
}
// 遍历当前分组中的记录来构建表格行
foreach ($xuorder as $row) {
$zu = htmlspecialchars($row['zu']);
$xu = htmlspecialchars($row['xu']);
$xingming = htmlspecialchars($row['xingming']);
$xingbie = htmlspecialchars($row['xingbie']);
$id = htmlspecialchars($row['id']);
$record_0 = htmlspecialchars($row['record_0']);
$record_1 = htmlspecialchars($row['record_1']);
$record_2 = htmlspecialchars($row['record_2']);
$record_3 = htmlspecialchars($row['record_3']);
$record_4 = htmlspecialchars($row['record_4']);
// 输出表格行
echo "<tr style='font-size:10px; height:40px'>";
echo "<td>{$zu}</td>";
echo "<td>{$xu}</td>";
echo "<td style='font-size:12px;'>
<input type='checkbox' name='ids[]' value='{$id}'>
{$xingming}</td>";
echo "<td>{$xingbie}</td>";
echo "<td><select name='xm_0' id='xm_0' style='width:40px; height:20px;'>
<option value='{$record_0}'>{$record_0}</option>
<option value='X'>X</option>
<option value='\'>\</option>
</select></td>";
echo "<td><select name='xm_1' id='xm_1' style='width:40px; height:20px;'>
<option value='{$record_1}'>{$record_1}</option>
<option value='\'>\</option>
<option value='X'>X</option>
<option value='√'>√</option>
</select></td>";
echo "<td><select name='xm_2' id='xm_2' style='width:40px; height:20px;'>
<option value='{$record_2}'>{$record_2}</option>
<option value='\'>\</option>
<option value='X'>X</option>
<option value='√'>√</option>
</select></td>";
if ($xiangmu == "速度轮滑") {
// 检查$dengji是否包含5到9中的任意一个
$dengji_array = explode(",", $dengji);
$is_valid_grade = false;
foreach (range(5, 9) as $grade) {
if (in_array((string)$grade, $dengji_array)) {
$is_valid_grade = true;
break;
}
}
if ($is_valid_grade) {
echo "<td>
<input type='text' name='xm_3' id='xm_3' value='{$record_3}' style='width:50px;' >
</td>";
} else {
// 其他情况的默认输出
echo "<td>
<select name='xm_3' id='xm_3' style='width:40px; height:20px;'>
<option value='{$record_3}'>{$record_3}</option>
<option value='\'>\</option>
<option value='X'>X</option>
<option value='√'>√</option>
</select>
</td>";
}
} elseif ($xiangmu == "自由式轮滑") {
// 检查$dengji是否包含4S到9S中的任意一个
$dengji_array = explode(",", $dengji);
$is_valid_grade = false;
foreach (range(4, 9) as $grade) {
if (in_array("{$grade}S", $dengji_array)) {
$is_valid_grade = true;
break;
}
}
if ($is_valid_grade) {
echo "<td>
<input type='text' name='xm_3' id='xm_3' value='{$record_3}' style='width:50px;' >
</td>";
} else {
// 其他情况的默认输出
echo "<td>
<select name='xm_3' id='xm_3' style='width:40px; height:20px;'>
<option value='{$record_3}'>{$record_3}</option>
<option value='\'>\</option>
<option value='X'>X</option>
<option value='√'>√</option>
</select>
</td>";
}
} else {
// 其他情况的默认输出
echo "<td>
<select name='xm_3' id='xm_3' style='width:40px; height:20px;'>
<option value='{$record_3}'>{$record_3}</option>
<option value='\'>\</option>
<option value='X'>X</option>
<option value='√'>√</option>
</select>
</td>";
}
echo "<td><select name='xm_4' id='xm_4' style='width:40px; height:20px;'>
<option value='{$record_4}'>{$record_4}</option>
<option value='\'>\</option>
<option value='X'>X</option>
<option value='√'>√</option>
</select></td>";
echo "<td>
<input type='hidden' id='id' name='id' value='{$id}'>
<button style='height:20px;width:40px;padding:1px;font-size:9px;' type='submit' id='bk' name='bk'>补考</button><br>
<button style='height:20px;width:40px;padding:1px;font-size:9px;' type='submit' id='wtg' name='wtg'>未通过</button>";
if ($xiangmu == "速度轮滑") {
// 检查$dengji是否包含5到9中的任意一个
$dengji_array = explode(",", $dengji);
$is_valid_grade = false;
foreach (range(5, 9) as $grade) {
if (in_array((string)$grade, $dengji_array)) {
$is_valid_grade = true;
break;
}
}
if ($is_valid_grade) {
echo "<br><button style='height:20px;width:40px;padding:1px;font-size:9px;' type='submit' id='lr' name='lr'>录入</button>";
}
} elseif ($xiangmu == "自由式轮滑") {
// 检查$dengji是否包含4S到9S中的任意一个
$dengji_array = explode(",", $dengji);
$is_valid_grade = false;
foreach (range(4, 9) as $grade) {
if (in_array("{$grade}S", $dengji_array)) {
$is_valid_grade = true;
break;
}
}
if ($is_valid_grade) {
echo "<br><button style='height:20px;width:40px;padding:1px;font-size:9px;' type='submit' id='lr' name='lr'>录入</button>";
}
}
echo "</td></tr>";
}
echo "</table></form>";
echo "</div>";
?>
<script>// 补考信息异步传递
$(document).ready(function() {
$('#lr').click(function(event) {
event.preventDefault(); // 阻止表单的默认提交行为
// 获取用户输入
var id = $('#id').val();
var xm_3 = $('#xm_3').val();
var xm_4 = $('#xm_4').val();
// 发送Ajax请求到服务器
$.ajax({
url: 'kgrw_update_lr.php',
type: 'POST',
data: {
id: id,
xm_3: xm_3,
xm_4: xm_4
},
success: function(response) {
// 在成功回调中处理服务器返回的数据
$('#top_t-content').html(response);
},
error: function(xhr, status, error) {
// 处理错误情况
alert('查询失败: ' + error);
}
});
});
});
</script>
请问如何修改,可以实现录入完成后点击“录入”,即可实现更新不同行里的数据(将录入的区域input值全部更新到数据库)?