DB::beginTransaction();开启以后,每次都只能插入最开始的一条数据,其它的都被回滚了。
代码如下:
try {
DB::beginTransaction();
foreach ($rightOrWrongRows as $row) {
$question = array_combine($rightOrWrongHeader, $row);
RightOrWrong::create([
'question' => $question['question'],
'answer' => $question['answer'],
'scope' => $question['scope'],
'degree' => 1,
'exam_id' => $this->examId,
]);
}
DB::commit();
} catch (\Exception $exception) {
DB::rollBack();
Log::info($exception->getMessage());
}
如果关闭事务,那么就可以插入多条数据
try {
//DB::beginTransaction();
foreach ($rightOrWrongRows as $row) {
$question = array_combine($rightOrWrongHeader, $row);
RightOrWrong::create([
'question' => $question['question'],
'answer' => $question['answer'],
'scope' => $question['scope'],
'degree' => 1,
'exam_id' => $this->examId,
]);
}
//DB::commit();
} catch (\Exception $exception) {
//DB::rollBack();
Log::info($exception->getMessage());
}
请各位朋友帮解决一下,本人菜鸟。
尝试
雷雷错误信息, 表结构, 图.