laravel - 在不使用 foreach 的情况下将单个结果存储到变量中

Question

我想将数据库中的单个结果存储到一个变量中。我以不同的方式尝试过，但并没有真正得到我想要的东西。请在下面查看我的代码:这是在 Controller 中

public function create()
{
    //
    $user_id = Auth::id();

    $company_id = User::select('company_id')->where('id', $user_id)->first();

    $curriculums = Curriculum::where('company_id','=', $company_id)->get();
    dd($curriculums);


    return view('qualificationheaders.create', ['user_id'=>$user_id]);
}

dd 的结果是:

Collection {#2232 ▼ #items: [] }

如果我用实际 ID 替换 $curriculum_id，我会得到正确的结果。所以我认为这是因为 $company_id = User::select('company_id')->where('id', $user_id)->first(); 甚至没有真正返回单个值虽然我把 ->first() 放在最后。请协助。我是 laravel 的新手

Answer 1

你需要做一些修改:

public function create()
{
    //
    $user_id = Auth::id();
// it return user not value
    $user = User::select('company_id')->where('id', $user_id)->first();   
// $user->company_id not $user
    $curriculums = Curriculum::where('company_id','=', $user->company_id)->first();
    dd($curriculums);


    return view('qualificationheaders.create', ['user_id'=>$user_id]);
}

编辑:您还可以做另一件事:

public function create()
{
    //get company_id 
    $company_id = Auth::user()->company_id;

    $curriculums = Curriculum::where('company_id','=', $company_id)->first();
    dd($curriculums);


    return view('qualificationheaders.create', ['user_id'=>Auth::id()]);
}