php - 如果另一条记录无法保存/存储，如何回滚新记录

Question

我想直接将数据存储在5个表中。我成功地将数据存储/保存在 4 个表中，但在最后一个表中出现错误。如何回滚前4个表的记录？

这是我的 Controller

$booking = new Book();
$booking->date = Carbon::now();
$booking->unique_number = mt_rand(1, 999);
$booking->save();
$bookingDetail = new BookDetail();
$bookingDetail->book()->associate($booking);
$bookingDetail->qty = $request->qty;
$bookingDetail->event_id = $id;
$bookingDetail->price = $event->price;
$bookingDetail->subtotal = $bookingDetail->qty * $bookingDetail->price;
$bookingDetail->save();
$booking->total = $bookingDetail->subtotal + $booking->unique_number;
$booking->save();
$bookingConfirmation = new BookConfirmation();
$bookingConfirmation->book()->associate($booking);
$bookingConfirmation->save();
$bookingCompletion = new BookCompletion();
$bookingCompletion->book()->associate($booking);
$bookingCompletion->save();
$participants = explode(', ', $request->participant_name);
if(count($participants) === $bookingDetail->qty){
    foreach ($participants as $participant) {
        $bookingParticipant = new BookParticipant();
        $bookingParticipant->participant_name = $participant;
        $bookingParticipant->save();
    }
}else{
    echo '<script language="javascript">alert("Jumlah orang tidak sesuai")</script>';
}

Answer 1

您可以通过 rollBack 方法回滚事务:

DB::rollBack();

如果您想手动开始事务并完全控制回滚和提交，您可以在数据库外观上使用 beginTransaction 方法:

DB::beginTransaction();

您可以使用 try catch block ，这样如果任何想法出错，那么您可以在 catch block 中回滚事务

DB::beginTransaction();
    try{
    here you can add your code to exicute and commit db transaction
    } catch (Exception $e) {
        DB::rollback();

    }

引用: https://laravel.com/docs/5.5/database#database-transactions

这里也已经回答了堆栈问题 Laravel: Using try...catch with DB::transaction()