teratail
回答率
85.30%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問laravelの１対多の登録処理をしたい

編集履歴

質問編集履歴

4

2021/12/03 18:21

投稿

meron88
meron88

スコア50

title CHANGED
File without changes
body CHANGED
@@ -31,26 +31,4 @@
31
31
  2 => "69"
32
32
  ]
33
33
  ]
34
- ```
35
-
36
- ```php
37
-
38
- $menu = new Menu();
39
- $menu->menu_name = $request->menu_name;
40
- $menu->menu_cd = $request->menu_cd;
41
-
42
- foreach($request->store_cd as $val) {
43
- $menu->menuDetails()->createMany([
44
- ['menu_cd' => $val],
45
- ['store_cd' => $request->store_cd],
46
- ['user_id' => Auth::id()],
47
- ]);
48
- }
49
- $menu->save();
50
- ```
51
-
52
- ### 発生している問題・エラーメッセージ
53
-
54
- ```
55
- SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "user_id" violates not-null constraint DETAIL: Failing row contains (18, A11, 55, 2021-10-22 16:17:37, null).
56
34
  ```

3

タイトル変更

2021/12/03 18:21

投稿

meron88
meron88

スコア50

title CHANGED
@@ -1,1 +1,1 @@
1
- １対多の登録処理について
1
+ laravelの１対多の登録処理をしたい
body CHANGED
File without changes

2

変数名が間違えていた為修正

2021/10/22 07:42

投稿

meron88
meron88

スコア50

title CHANGED
File without changes
body CHANGED
@@ -52,5 +52,5 @@
52
52
  ### 発生している問題・エラーメッセージ
53
53
 
54
54
  ```
55
- SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "update_user" violates not-null constraint DETAIL: Failing row contains (18, A11, 55, 2021-10-22 16:17:37, null).
55
+ SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "user_id" violates not-null constraint DETAIL: Failing row contains (18, A11, 55, 2021-10-22 16:17:37, null).
56
56
  ```

1

コードが間違えていた為修正

2021/10/22 07:41

投稿

meron88
meron88

スコア50

title CHANGED
File without changes
body CHANGED
@@ -38,14 +38,12 @@
38
38
  $menu = new Menu();
39
39
  $menu->menu_name = $request->menu_name;
40
40
  $menu->menu_cd = $request->menu_cd;
41
- $menu->create_user = Auth::id();
42
- $menu->update_user = Auth::id();
43
41
 
44
42
  foreach($request->store_cd as $val) {
45
43
  $menu->menuDetails()->createMany([
46
44
  ['menu_cd' => $val],
47
45
  ['store_cd' => $request->store_cd],
48
- ['update_user' => Auth::id()],
46
+ ['user_id' => Auth::id()],
49
47
  ]);
50
48
  }
51
49
  $menu->save();