1. Home
2. php - Null in relationship belongs to in laravel?

947 votes

1 answers

php - Null in relationship belongs to in laravel?

Get the solution ↓↓↓

I have tableproducts andjob_statuses and there is a relation between them in migration products:

$table->unsignedBigInteger('job_status_id')->index()->nullable();
$table->foreign('job_status_id')->references('id')->on('job_statuses')->onDelete('set null');
Copy code

In Product model:

public function job()
{
    return $this->belongsTo(JobStatus::class);
}
Copy code

in blade dd :

 @foreach ($products as $product)

     @dd($product->job)

 @endforeach
Copy code

I gotnull

The weird thing that when I do the same way but in tinker the relation is worked!

Undefined asked

2021-12-5

Write your answer

---

400

votes

Answer

Solution:

you have to pass the foreign key in relationship. by default laravel assumes the foreign key as relationname_primarykey of related table. in your case the relationship name is job but the foreign key is job_status_id. so the relationship is not biulding. change like

public function job()
{
    return $this->belongsTo(JobStatus::class, 'job_status_id');
}
Copy code

and a note. as you are using nullable you should check for relationship existence first.

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-5

Link To Source
Link To Answer People are also looking for solutions of the problem: property [id] does not exist on this collection instance.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

655 php - Solve PHP4 to PHP5 ugrade error

546 php - How to join and get data from two tables in laravel?

170 mysqli - PHP Not inserting record due to Null id

962 php - XAMPP Apache Won't Start with Modified php5ts.dll

790 php - Laravel form array validation doesn't work

367 laravel - How can I merge array in multidimensional array in PHP

705 php - Laravel schedule job with method when()

577 php - Passing second user model data to a controller in Laravel

254 php - Laravel 5.6: Eloquent + DB::Builder query array indexes

417 php - Doctrine return null in place of EntityNotFoundException

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Laravel

Laravel is a free open source PHP framework that came out in 2011. Since then, it has been able to become the framework of choice for web developers. One of the main reasons for this is that Laravel makes it easier, faster, and safer to develop complex web applications than any other framework.
https://laravel.com/