在laravel中，如何从一个表中检索数据时排除行，这些表链接到另一个表上的已删除行

Question

I have a model like this

public function getProduct() {

        return $this->belongsTo('App\Product','product_id','id');

    }

This function is from a model called Support. The data in product_id matches to the id column in Product table. Some of the entries in supports table fetch product details using this relationship function. Now, when a row in the products table, for example:having id = 4, gets deleted or softdeleted, the rows in the supports table having product_id = 4 gets affected i.e. for a code like this

{{$support->getProduct->name}}

gives an error saying "Trying to get the property of a non object".

How do i get around this error such that if the rows in product table gets deleted or soft deleted, the rows in supports table having product_id equal to the id in products table do not get retrieved during query?

Answer 1

if you can do this using blade.

{{$support->getProduct->name or ''}}

or

{{ isset($support->getProduct->name) ?  $support->getProduct->name:'' }}