if ($_SERVER["REQUEST_METHOD"] == "POST") {
    foreach ($_POST as $field => $value) {
        // 更新记录中的每个字段
        $updateQuery = "UPDATE atte2 SET $field = '$value' WHERE id = ?";
        $stmt = $conn->prepare($updateQuery);
        $stmt->bind_param("i", $_POST['id']);
        $stmt->execute();
    }
}

// 查询 "atten2" 表的数据
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$limit = 30;
$offset = ($page - 1) * $limit;

$selectQuery = "SELECT * FROM attedance2 LIMIT ?, ?";
$stmt = $conn->prepare($selectQuery);
$stmt->bind_param("ii", $offset, $limit);
$stmt->execute();
$result = $stmt->get_result();

// 输出表格并为每个字段创建输入框
echo '<form method="POST">';
echo '<table>';
while ($row = $result->fetch_assoc()) {
    echo '<tr>';
    echo '<td><input type="hidden" name="id" value="' . $row['id'] . '">' . $row['id'] . '</td>';
    echo '<td><input type="text" name="field1" value="' . $row['field1'] . '"></td>';
    echo '<td><input type="text" name="field2" value="' . $row['field2'] . '"></td>';
    // 继续为其他字段创建输入框...
    echo '</tr>';
}