Laravel从外键获取数据

Question

I have two table one is called Submission one called AssignSubmission

Submission belongTo AssignSubmission

public function assignsubmission()
{
    return $this->belongsTo('App\AssignSubmission');
}

AssignSubmissionhasManySubmission

public function submissions()
{
    return $this->hasMany('App\Submission');
}

They are linked with foreign keys In AssignSubmission has id, user_id and submission_id the foreign key is submission_id. In Submission table, it has id, user_id and file, url etc

in AssignSubmission submission_id -> links to -> Submission id. I have assigned different submission to 2 users.

How can I get data from the foreign key? I want to display the url or file in the view

Answer 1

If you have a Submission object $submission already,

$submission->assignSubmission->url will give you the url.

It converts to camalCase for property name.