首页 > 解决方案 > 尝试在单个函数中使用更新和创建的问题

问题描述

我想为一个表创建一行,但更新另一个表中的列,为此我同时使用update()and create(),但无论我如何放下它,它都会以同样的错误结束。

在此处查看错误

    public function createuserinfo(Request $request)
    {
        $user = Auth::user();

        $userupdate = User::update([
            'status' => '1'
        ]);

        $infocreate = Personal::create([
            'user_id' => Auth::user()->id,
            'first_name' => $request->first_name,
            'last_name' => $request->last_name,
            'email' => $request->email,
            'password' => $request->password,
            'address' => $request->address,
            'zipcode' => $request->zipcode,
            'city' => $request->city,
            'phone_number' => $request->phone_number,
            'ss_number' => $request->ss_number,
            'document_number' => $request->document_number,
            'license_number' => $request->license_number,
            'expiration_date' => $request->expiration_date,
            'employer' => $request->employer,
            'jobtitle' => $request->jobtitle,
            'contract' => $request->contract,
            'start_date' => $request->start_date,
            'general_practitioner' => $request->general_practitioner,
            'dentist' => $request->dentist,
            'health_insurance' => $request->health_insurance,
            'contact_one_name' => $request->contact_one_name,
            'contact_one_relation' => $request->contact_one_relation,
            'contact_one_address' => $request->contact_one_address,
            'contact_one_zipcode' => $request->contact_one_zipcode,
            'contact_one_city' => $request->contact_one_city,
            'contact_one_phone_number' => $request->contact_one_phone_number,
            'contact_two_name' => $request->contact_two_name,
            'contact_two_relation' => $request->contact_two_relation,
            'contact_two_address' => $request->contact_two_address,
            'contact_two_zipcode' => $request->contact_two_zipcode,
            'contact_two_city' => $request->contact_two_city,
            'contact_two_phone_number' => $request->contact_two_phone_number
        ]);

        return $userupdate . $infocreate . redirect()->route('users.details');
    }

我需要它重定向到用户详细信息页面并添加/更改他们的信息。我希望有人能够帮助我解决这个问题。

标签: laravelcrud

解决方案


也许试试这个

  public function createuserinfo(Request $request)
{
    $user = Auth::user();

    $userupdate = $user->update([
        'status' => '1'
    ]);

    $infocreate = Personal::create([
        'user_id' => $user->id,
        'first_name' => $request->first_name,
        'last_name' => $request->last_name,
        'email' => $request->email,
        'password' => $request->password,
        'address' => $request->address,
        'zipcode' => $request->zipcode,
        'city' => $request->city,
        'phone_number' => $request->phone_number,
        'ss_number' => $request->ss_number,
        'document_number' => $request->document_number,
        'license_number' => $request->license_number,
        'expiration_date' => $request->expiration_date,
        'employer' => $request->employer,
        'jobtitle' => $request->jobtitle,
        'contract' => $request->contract,
        'start_date' => $request->start_date,
        'general_practitioner' => $request->general_practitioner,
        'dentist' => $request->dentist,
        'health_insurance' => $request->health_insurance,
        'contact_one_name' => $request->contact_one_name,
        'contact_one_relation' => $request->contact_one_relation,
        'contact_one_address' => $request->contact_one_address,
        'contact_one_zipcode' => $request->contact_one_zipcode,
        'contact_one_city' => $request->contact_one_city,
        'contact_one_phone_number' => $request->contact_one_phone_number,
        'contact_two_name' => $request->contact_two_name,
        'contact_two_relation' => $request->contact_two_relation,
        'contact_two_address' => $request->contact_two_address,
        'contact_two_zipcode' => $request->contact_two_zipcode,
        'contact_two_city' => $request->contact_two_city,
        'contact_two_phone_number' => $request->contact_two_phone_number
    ]);

    return $userupdate . $infocreate . redirect()->route('users.details');
}

推荐阅读