laravel 事务不提交 不知道哪里写错了

Question

laravel 事务不提交 不知道哪里写错了

以下是代码
DB::transaction(function () use ($payment,$userBalance) {

            Payment::insert($payment);
            $userName = $payment['payment_user_name'];
            User::where('user_name', $userName)
                 ->increment('user_balance', $userBalance);
        });
        
        
        跪求指教

Answer 1

DB::transaction(function () use ($payment,$userBalance) {
         try {
            Payment::insert($payment);
            $userName = $payment['payment_user_name'];
            User::where('user_name', $userName)->increment('user_balance', $userBalance);
         } catch (\Exception $e) {
            var_dump($e);
            exit;
         }
});

Answer 2

//打印输出下sql 看是否有问题，因为在 transaction 闭包若抛出任何异常会导致事务自动回滚
\DB::listen(function ($sql,$bind) { 
   dump($sql,$bind);
}