我想注冊一個用戶并將數據插入到帳戶表中，并將帳戶的 user_id 作為創建的用戶 ID 插入，我從我的管理控制器中執行此操作；public function store(StoreUsersRequest $request) { DB::transaction(function($request) { $newUser = User::create($request->all()); $newAccounts = Accounts::create([ 'user_id' => $newUser->id, 'balance' => '0', 'amt' => '0', ]); if( !$newAccounts ) { throw new \Exception('accounts not created for new user'); } }); return redirect()->route('users.create'); } 任何人都可以告訴我怎么做嗎？
2 回答
猛跑小豬
TA貢獻1858條經驗 獲得超8個贊
試試這個代碼。我假設你的表名是“accounts”
$result = DB::transaction(function () use ($request) {
$data = new User;
$data->name = $request->name;
$data->other_values = $request->values;
$data->save();
DB::table('accounts')->insert(['user_id' => $data->id, 'balance' => '0', 'amount' => '0']);
return true;
}, 5);
if($result) {
// Redirect after successful execution
return redirect()->route('users.create');
} else {
// Redirect after unsuccessful execution
Session::flash('failed','Oops, accounts not created for new user');
return redirect()->route('previous.route');
}
在查看文件中
@if (session('failed'))
<div class="alert alert-danger">
{{ session('failed') }}
</div>
@endif
烙印99
TA貢獻1829條經驗 獲得超13個贊
try {
DB::beginTransaction();
$newUser = User::create($request->all());
$newAccounts = Accounts::create([
'user_id' => $newUser->id,
'balance' => '0',
'amt' => '0',
]);
DB::commit();
} catch (\Exception $e) {
DB::rollback();
throw new \Exception('accounts not created for new user');
}
- 2 回答
- 0 關注
- 103 瀏覽
添加回答
舉報
0/150
提交
取消