Laravel 如何向 2 个表中插入数据？

Question

我的用户模型<?phpnamespace App;use Illuminate\Contracts\Auth\MustVerifyEmail;use Illuminate\Foundation\Auth\User as Authenticatable;use Illuminate\Notifications\Notifiable;class User extends Authenticatable{    use Notifiable;    /**     * The attributes that are mass assignable.     *     * @var array     */    protected $fillable = [        'role_id', 'name', 'email', 'password',    ];    /**     * The attributes that should be hidden for arrays.     *     * @var array     */    protected $hidden = [        'password', 'remember_token',    ];    /**     * The attributes that should be cast to native types.     *     * @var array     */    protected $casts = [        'email_verified_at' => 'datetime',    ];}医院模型namespace App;use Illuminate\Database\Eloquent\Model;class Hospital extends Model{    /**     * @var String $table;     */    protected $table = 'hospitals';    /**     * @var Array $fillable;     */    protected $fillable = [        'user_id', 'companyname', 'adress', 'postalcode', 'residence',        'phonenumber', 'mailadress'    ];}

Answer 1

首先你不需要像这样在你的动作中注入User模型store

public function store(User $user, Request $request)

您可以在hospital控制器的store操作中使用类似以下代码的事务

public function store(Request $request)

{

    $request->validate([

        'name' => 'required|max:255',

        'email' => 'required|max:255|unique:users',

        'password' => 'required|min:8',

    ]);

    DB::transaction(function () use($request){

        // $user = User::create($this->transformForm($request)); 

        $user = User::create([

            'name' => $request->input('name'),

            'email' => $request->input('email'),

            'password' => $request->input('password'),

        ]);

        // update or insert here

        Hospital::Create([

            'user_id' => $user->id,

            'companyname' => $request->input('companyname'),

            'adress' => $request->input('adress'),

            'postalcode' => $request->input('postalcode'),

            'residence' => $request->input('residence'),

            // 'phonenumber' => $request->input(), //missing in your form

            // 'mailadress' => $request->input() // missing in your form

        ]);

    });

    return //redirecto to a success page or somewhere else

}