在这里,我使用updateOrCreate
方法来发布数据,但是当我使用这个方法时,旧数据被新数据替换,但是我想添加新数据,而不更新或替换现有数据。
以下是插入数据的代码
$booking = Bookings::updateOrCreate(
['schedules_id' => $schedules_id], // match the row based on this array
[ // update this columns
'buses_id' => $buses_id,
'routes_id' => $routes_id,
'seat' => json_encode($seat),
'price' => $request->price,
'profile' => 'pending',
]
);
发布于 2019-04-28 01:06:44
我自己解决了,我将旧数据存储到$extSeat中,然后与新数据合并,我不知道逻辑是正确还是错误,但工作正常
$extSeat = DB::table('bookings')->select('seat')->first();
$extSeat = explode(",", $extSeat->seat);
$booking = Bookings::updateOrCreate(
['schedules_id' => $schedules_id],// row to test if schedule id matches existing schedule id
[ // update this columns
'buses_id' => $buses_id,
'routes_id' => $routes_id,
'seat' => implode(",", array_merge($seat,$extSeat )),
'price' => $request->price,
'profile' => 'pending',
]);
https://stackoverflow.com/questions/55545681
复制相似问题