我正在尝试插入海量数据,但是当我遍历请求时出现此错误:
Symfony \ Component \ Debug \ Exception \ FatalThrowableError无法使用 类型为Symfony \ Component \ HttpFoundation \ ParameterBag的对象作为数组
请求示例:
request: Symfony\Component\HttpFoundation\ParameterBag {#52 ▼
#parameters: array:4 [▼
"_token" => "Z1sF2K5LHU1bsQ4l3JRaOLCTQDmJ47qakigmrfI5"
"name" => "Routine 1"
"sections" => array:1 [▼
"section-1" => array:2 [▼
"name" => "Sectdfs 1"
"exercises" => array:2 [▼
1 => array:1 [▼
"name" => "Exercise 11"
]
2 => array:1 [▼
"name" => "Exercise 12"
]
]
]
]
"submit" => "Submit"
]
}
循环遍历请求并插入:
$routine = new Routine;
$routine->create(['user_id' => 1, 'name' => $request->name, 'description' => 'test description']);
foreach($request as $item){
$section = new Section;
$section->name = $item['name'];
$section->description = 'test description';
$routine->sections()->create([$section]);
foreach($item as $item2){
$exercise = new Exercise;
$exercise->name = $item2['name'];
$exercise->description = 'la la la';
$exercise->duration = 60;
$exercise->duration_unit = 'seconds';
$section->exercises()->create([$exercise]);
}
}
我添加了一些“内联”数据,因为我还没有以表格的形式处理它们,这就是为什么要添加持续时间和持续时间单位的原因。
您可以使用$ request作为数组,如下所示: