Laravel处理表单提交时如何保存所有不同长度的嵌套数组数据

问题根源 #

你当前的循环逻辑以pid数组的长度为遍历基准，而从提交的请求数据可以看到pid数组只有2个元素，因此循环仅执行2次，自然无法处理长度为3的descExps、amountExps数组的第三条数据。

解决方案 #

更合理的实现方式是先优化表结构，将产品明细和费用明细拆分到两个独立数据表存储，两类数据属于不同业务维度，混在同一张表会导致数据冗余和逻辑混乱：

1. 新建project_products表存储产品相关字段：pid、qty、discount、subtotal等
2. 新建project_expenses表存储费用相关字段：description_expenses、amount_expenses等

修改后的控制器代码如下：

public function store(Request $request)
{
    // 先保存项目主表公共字段，避免重复冗余存储
    $project = Project::create([
        'projectno' => $fk,
        'user_id' => Auth::user()->id,
        'project_date' => $date,
        'clientName' => $request->clientName,
        'costproject' => $request->garamakaz,
        'comment' => $request->Note,
        'amountpaid' => $request->amountpaid,
    ]);

    // 遍历保存所有产品明细
    if (count($request->pid) > 0) {
        foreach ($request->pid as $key => $v) {
            $project->products()->create([
                'pid' => $v,
                'discount' => $request->discount[$key],
                'qty' => $request->qty[$key],
                'amount' => $request->subtotal[$key],
            ]);
        }
    }

    // 单独遍历保存所有费用明细
    if (count($request->descExps) > 0) {
        foreach ($request->descExps as $key => $desc) {
            $project->expenses()->create([
                'description_expenses' => $desc,
                'amount_expenses' => $request->amountExps[$key],
            ]);
        }
    }
}

如果确实需要保留现有单表存储的逻辑，可以取所有数组的最大长度作为遍历次数，对应索引不存在时补默认值即可：

public function store(Request $request)
{
    // 取所有数组的最大长度作为循环次数
    $maxLength = max(
        count($request->pid ?? []),
        count($request->descExps ?? [])
    );

    for ($i = 0; $i < $maxLength; $i++) {
        $data2 = [
            'projectno' => $fk,
            'user_id' => Auth::user()->id,
            'project_date' => $date,
            'clientName' => $request->clientName,
            'costproject' => $request->garamakaz,
            'comment' => $request->Note,
            'amountpaid' => $request->amountpaid,
            // 索引不存在时赋值为null，可根据业务需求调整默认值
            'pid' => $request->pid[$i] ?? null,
            'discount' => $request->discount[$i] ?? null,
            'qty' => $request->qty[$i] ?? null,
            'amount' => $request->subtotal[$i] ?? null,
            'description_expenses' => $request->descExps[$i] ?? null,
            'amount_expenses' => $request->amountExps[$i] ?? null,
        ];
        Project::create($data2);
    }
}

内容的提问来源于stack exchange，提问作者Melx