Breaking News: Grepper is joining You.com. Read the official announcement!

laravel eager loading where clause

ssbrar answered on August 16, 2020 Popularity 10/10 Helpfulness 4/10

answer laravel eager loading where clause

related laravel eager-loading with selected columns

laravel eager loading where clause

Comment

$query = ""    

if ($request->has('country'){
$query = Post::with("country")->whereHas("country",function($q) use($request){
    $q->where("name","=",$request->country);
})->get()
}else{
    $query = Post::with("country")->get();
}

Popularity 10/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: eager-loading laravel php where-clause

Link to this answer
Share Copy Link

Contributed on Aug 16 2020

ssbrar

0 Answers Avg Quality 2/10

Closely Related Answers

laravel eager-loading with selected columns

Comment

$results = User::with([
	'country' => function ($query) {
		$query->select('id','name');
	},'posts' => function ($query) {
		$query->select('id','user_id','title');
	},'posts.attachments' => function ($query) {
		$query->select('id','post_id','type');
	}])->get(['id','country_id','name']);

Popularity 9/10 Helpfulness 3/10 Language php

Source: laravel.io

Tags: eager-loading ea

Link to this answer
Share Copy Link

Contributed on Nov 03 2022

Dizzy Dotterel

0 Answers Avg Quality 2/10

laravel eager loading where clause

Contents

More Related Answers

laravel eager loading where clause

Closely Related Answers

laravel eager-loading with selected columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.