Laravel5.8 我无法将数据存储到我的 sql server

Question

我正在设置用户个人资料页面，但我无法将数据插入mysql服务器。

我无法弄清楚并解决这个问题。

我index.blade.php在我的个人资料文件夹中，并从索引页面转到create.blade.php.

当我输入提交按钮时，我的页面重定向到index.blade.php，但在mysql服务器中，没有任何记录。

网页.php

Route::prefix('user')->group(function(){

    Route::resource('profile', 'UserController');

});

创建.blade.php

<form action="{{route('profile.store')}}" method="POST">@csrf

                    <ul class="information">

                        <li>Name :<br>

                            <input type="text" class="name" name="name">

                        </li><br>

                        <li>Gender :<br>

                            <div class="gender">

                                <select name="gender" id="" name="gender">

                                    <option class="option" value="" selected="selected">Select Gender</option>

                                    <option value="male" >Male</option> 

                                    <option value="female" class="selected">Female</option> 

                                    <option value="any">Any</option> 

                                </select>       

                            </div>

                        </li>   

                        <li>Country :<br>

                            <div class="country">

                                <select name="country" id="" name="country">

                                    <option value="" selected="selected">Select Country</option> 

                                    <option value="United States" class="selected">United States</option> 

                                    <option value="United Kingdom">United Kingdom</option>      

                                </select>

                            </div>    

                        </li>

Answer 1

如果您需要更新现有记录：$user_id = auth()->user()->id;$update = Profile::where('user_id',$user_id)->update([&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'name'=>$request->name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'gender'=>$request->gender,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'country'=>$request->country,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'bod'=>$request->bod,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'description'=>$request->description&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]);&nbsp; &nbsp; if($update){&nbsp; &nbsp; &nbsp; &nbsp; return redirect()->route('profile.index');&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; //do something if fails&nbsp; &nbsp; }但是，如果您需要添加新的配置文件，那么：$create= Profile::create([&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'user_id'=>auth()->user()->id,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'name'=>$request->name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'gender'=>$request->gender,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'country'=>$request->country,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'bod'=>$request->bod,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'description'=>$request->description&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]);&nbsp; &nbsp; &nbsp; &nbsp; if($create){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return redirect()->route('profile.index');&nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //do something if fails&nbsp; &nbsp; &nbsp; &nbsp; }

Answer 2

试试这个，假设您正在尝试发布新记录：public function store(Request $request) {&nbsp; &nbsp; $profile = new Profile;&nbsp; &nbsp; $profile->name = $request->input('name');&nbsp; &nbsp; $profile->gender = $request->input('gender');&nbsp; &nbsp; $profile->country = $request->input('country');&nbsp; &nbsp; $profile->bod = $request->input('bod');&nbsp; &nbsp; $profile->description = $request->input('description');&nbsp; &nbsp; $profile->save();&nbsp; &nbsp; return redirect()->route('profile.index');}

Answer 3

Profile如果模型首先存在，您的代码只会更新模型。如果您不知道记录是否存在，您可能需要尝试updateOrCreate方法。它将更新现有记录，或者，如果没有这样的记录，它将创建一个新记录：public function store(Request $request) {&nbsp; &nbsp; $user_id = auth()->user()->id;&nbsp; &nbsp; Profile::updateOrCreate(&nbsp; &nbsp; &nbsp; &nbsp; ['user_id' => $user_id], // search requirements&nbsp; &nbsp; &nbsp; &nbsp; [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // fields to update or create record with&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'name' => request('name'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'gender' => request('gender'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'country' => request('country'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'bod' => request('bod'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'description' => request('description')&nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; );&nbsp; &nbsp; return redirect()->route('profile.index');}