我正在嘗試將圖像上傳到預先存在的表單,但是在提交表單時出現錯誤 SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value。我已經設法讓表單上的實際按鈕和文件選擇器起作用,但是,在提交時它會引用上述錯誤。關于這個問題的任何幫助或資源都會很棒。后控制器<?phpnamespace App\Http\Controllers;use App\Post;use Illuminate\Http\Request;class PostController extends Controller{ public function __construct() { $this->middleware('auth'); } /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $posts = Post::all(); return view('post.index', compact('posts')); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $post = new Post(); return view('post.create', compact ('post')); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $data = request()->validate([ 'title' => 'required', 'body' => 'required', ]); $post = \App\Post::create($data); return redirect('/posts'); } /** * Display the specified resource. * * @param \App\Post $post * @return \Illuminate\Http\Response */ public function show(Post $post) { return view('post.show', compact('post')); } /** * Show the form for editing the specified resource. * * @param \App\Post $post * @return \Illuminate\Http\Response */ public function edit(Post $post) { return view('post.edit', compact('post')); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param \App\Post $post * @return \Illuminate\Http\Response */
1 回答

MYYA
TA貢獻1868條經驗 獲得超4個贊
我認為默認情況下 user_id 沒有默認值。在您的帖子模型中,
protected $fillable = ['user_id', 'title', 'body', 'image'];
同樣在您的商店功能中,您必須包括來自當前登錄用戶的用戶。
use App\Post;
use Auth;
public function store(Request $request)
{
$request->validate([
'title' => 'required',
'body' => 'required',
]);
$post = new Post();
$post->user_id = Auth::user()->id;
$post->title = $request->title;
$post->body = $request->body;
$post->save();
return redirect('/posts');
}
- 1 回答
- 0 關注
- 146 瀏覽
添加回答
舉報
0/150
提交
取消