PHP表单提交：循环生成多条数据一次性更新MySQL数据库

<form method="post" enctype="multipart/form-data">
    <?php
        // 假设 $connection 和 $user_id 已定义并初始化
        $stmt = $connection->prepare("SELECT id, filename FROM lj_imageposts WHERE user_id = :user_id");
        $stmt->execute([':user_id' => $user_id]);

        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $db_image_id = htmlspecialchars($row['id']);
            $db_image_filename = htmlspecialchars($row['filename']);
    ?>
    <div class="upload-details-component">                
        <div class="form-row">
            @@##@@
        </div>
        <div class="edit-zone">
            <div class="form-row">
                <label for="upload-details-title-<?php echo $db_image_id; ?>">Image Title</label>
                <!-- 注意：为确保ID唯一性，这里将ID添加到label的for和input的id中 -->
                <input id="upload-details-title-<?php echo $db_image_id; ?>" type="text" name="image-title[]">
            </div>
            <div class="form-row">
                <label for="upload-details-tags-<?php echo $db_image_id; ?>">Comma Separated Image Tags</label>
                <textarea id="upload-details-tags-<?php echo $db_image_id; ?>" name="image-tags[]"></textarea>
            </div>
            <div class="form-row">
                <!-- 关键：同时传递每条记录的唯一标识符（例如ID或文件名） -->
                <input type="hidden" name="image-id[]" value="<?php echo $db_image_id; ?>">
                <!-- 如果必须使用文件名作为标识，也应改为数组形式 -->
                <!-- <input type="hidden" name="image-filename[]" value="<?php echo $db_image_filename; ?>"> -->
            </div>
        </div>
    </div>
    <?php } ?>
    <button type="submit" name="upload-submit">COMPLETE UPLOAD</button>
</form>

<?php 
if (isset($_POST['upload-submit'])) {
    // 假设 $connection 已定义并初始化
    try {
        // 准备SQL更新语句
        $sql = "UPDATE lj_imageposts SET
                image_title = :image_title,
                image_tags = :image_tags
                WHERE id = :id"; // 强烈建议使用主键ID进行更新

        $stmt = $connection->prepare($sql);

        // 遍历接收到的数组数据
        // 假设 image-title[], image-tags[], image-id[] 的索引顺序是一致的
        foreach ($_POST['image-id'] as $key => $id) {
            $image_title = $_POST['image-title'][$key] ?? ''; // 使用 ?? 运算符处理可能为空的值
            $image_tags = $_POST['image-tags'][$key] ?? '';

            $stmt->execute([
                ':image_title' => $image_title,
                ':image_tags'  => $image_tags,
                ':id'          => $id
            ]);
        }

        // 更新成功后重定向
        // 假设 $username 变量已通过某种方式（如session）获取
        header("Location: upload-details.php?username={$username}");
        exit(); // 重定向后应立即退出
    } catch (PDOException $e) {
        echo "Error: " . $e->getMessage();
        // 生产环境中应记录错误日志而非直接输出
    }
}
?>

<form method="post" enctype="multipart/form-data">
    <?php
        // 假设 $connection 和 $user_id 已定义并初始化
        $stmt = $connection->prepare("SELECT id, filename, image_title, image_tags FROM lj_imageposts WHERE user_id = :user_id");
        $stmt->execute([':user_id' => $user_id]);

        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $db_image_id = htmlspecialchars($row['id']);
            $db_image_filename = htmlspecialchars($row['filename']);
            $db_image_title = htmlspecialchars($row['image_title']);
            $db_image_tags = htmlspecialchars($row['image_tags']);
    ?>
    <div class="upload-details-component">                
        <div class="form-row">
            @@##@@
        </div>
        <div class="edit-zone">
            <div class="form-row">
                <label for="upload-details-title-<?php echo $db_image_id; ?>">Image Title</label>
                <!-- 使用ID作为数组键 -->
                <input id="upload-details-title-<?php echo $db_image_id; ?>" type="text" 
                       name="image-title[<?php echo $db_image_id; ?>]" value="<?php echo $db_image_title; ?>">
            </div>
            <div class="form-row">
                <label for="upload-details-tags-<?php echo $db_image_id; ?>">Comma Separated Image Tags</label>
                <!-- 使用ID作为数组键 -->
                <textarea id="upload-details-tags-<?php echo $db_image_id; ?>" 
                          name="image-tags[<?php echo $db_image_id; ?>]"><?php echo $db_image_tags; ?></textarea>
            </div>
            <!-- 在这种方案下，无需单独的隐藏ID字段 -->
        </div>
    </div>
    <?php } ?>
    <button type="submit" name="upload-submit">COMPLETE UPLOAD</button>
</form>

<?php 
if (isset($_POST['upload-submit'])) {
    // 假设 $connection 已定义并初始化
    try {
        $sql = "UPDATE lj_imageposts SET
                image_title = :image_title,
                image_tags = :image_tags
                WHERE id = :id";

        $stmt = $connection->prepare($sql);

        // 遍历 image-title 关联数组，键即为记录ID
        foreach ($_POST['image-title'] as $id => $title_value) {
            $image_title = $title_value ?? '';
            $image_tags = $_POST['image-tags'][$id] ?? ''; // 通过ID访问对应的标签值

            $stmt->execute([
                ':image_title' => $image_title,
                ':image_tags'  => $image_tags,
                ':id'          => $id
            ]);
        }

        header("Location: upload-details.php?username={$username}");
        exit();
    } catch (PDOException $e) {
        echo "Error: " . $e->getMessage();
    }
}
?>