Relationship Table Data With Route Model Binding In Laravel

Many times you might want to use this wonderful thing called Route Model Binding in Laravel but back off because you might need its related table data too. Yup! I too had come across this situation.

Example - You want to show Customer details and CustomerAddress details so you would have done something like the following

Common Way

public function show($customer)
{
    $customer = Customer::with('customerAddress')->where('id', $customer)->first();
    return view('customer.show', [
        'customer' => $customer
    ]);
}

But let me explain 2 simple approaches to achieve it.

---

1) Relationship Table Data Along With Route Model

Route Model Binding (Common Way)

public function show(Customer $customer)
{
    $customerAddress = CustomerAddress::where('id', $customer)->get();
    return view('customer.show', [
        'customer'          => $customer,
        'customerAddress'   => $customerAddress
    ]);
}

Now lets see the simple way

Route Model Binding (Super cool way - load)

public function show(Customer $customer)
{
    /** Super Awesome Right? */
    $customer->load(['customerAddress']);

    return view('customer.show', [
        'customer'          => $customer
    ]);
}

Yup the following is the super cool line.

$customer->load(['customerAddress']);

---

2) $with In Model (Use wisely)

Make sure to use this wisely as it will load all the related table every time you query.

class Customer extends Model
{
    use SoftDeletes;
    protected $with = ['customerAddress'];
}

---

Conclusion

Hope the article was helpful. Kindly share it with your friends.

Articles For You

Send SMS With Amazon SNS (Simple Notification Service) Using PHP

Detect AdBlocker With Javascript And Increase Website Ads Revenue

Laravel Last Executed Query In Plain SQL Statement For Debugging

@stack @push and @prepend In Laravel Blade

Route Model Binding In Laravel & Change Default Column id To Another Column

Upload File From Frontend Server {GuzzleHttp} To REST API Server In PHP {Laravel}

Plain PHP Resumable Large File Uploads In Chunks Using FlowJs

Resolve 404 Not Found In NGINX

Simple Way To Create Resourceful API Controller In Laravel

Create Gmail App Password For SMTP Mails

Why You Should Run Cronjobs In Laravel?

Supervisor For Laravel Queue Scheduling

Setup AMP (Accelerated Mobile Pages) In PHP Laravel

Dependency Dropdowns With Javascript And PHP

Factories To Speed Up Test-Driven Development In Laravel