laravel Get all models that have array of relations
I have a Product model with Tags relation:
class Product
{
public function tags()
{
return $this->belongsToMany('tags')
and
class Tags
{
public function products()
{
return $this->belongsToMany('products')
how can i retrieve products
that have all of tags
with id of [1,2,3]
php laravel eloquent
|
show 2 more comments
I have a Product model with Tags relation:
class Product
{
public function tags()
{
return $this->belongsToMany('tags')
and
class Tags
{
public function products()
{
return $this->belongsToMany('products')
how can i retrieve products
that have all of tags
with id of [1,2,3]
php laravel eloquent
1
try: $products->with(['tags' => function($query){ $query->whereIn('id', [1,2,3]);}]);
– Fatemeh Majd
Nov 24 '18 at 11:48
@FatemehMajd this will return products that has tags in this array. i mean a product with 1 tag_id also is in your solution
– Joseph Rback
Nov 24 '18 at 12:08
1
In that case, i'm now aware of the eloquent way, but you can query the tables as in: DB::table('blah_blah-1')-join('...')->...;
– Fatemeh Majd
Nov 24 '18 at 12:49
2
Should the products have one of these tags or all of them?
– Jonas Staudenmeir
Nov 24 '18 at 17:58
1
Are you wanting products that have all 3 tags?
– Ross Wilson
Nov 24 '18 at 18:50
|
show 2 more comments
I have a Product model with Tags relation:
class Product
{
public function tags()
{
return $this->belongsToMany('tags')
and
class Tags
{
public function products()
{
return $this->belongsToMany('products')
how can i retrieve products
that have all of tags
with id of [1,2,3]
php laravel eloquent
I have a Product model with Tags relation:
class Product
{
public function tags()
{
return $this->belongsToMany('tags')
and
class Tags
{
public function products()
{
return $this->belongsToMany('products')
how can i retrieve products
that have all of tags
with id of [1,2,3]
php laravel eloquent
php laravel eloquent
edited Nov 26 '18 at 10:49
Joseph Rback
asked Nov 24 '18 at 11:07
Joseph RbackJoseph Rback
182113
182113
1
try: $products->with(['tags' => function($query){ $query->whereIn('id', [1,2,3]);}]);
– Fatemeh Majd
Nov 24 '18 at 11:48
@FatemehMajd this will return products that has tags in this array. i mean a product with 1 tag_id also is in your solution
– Joseph Rback
Nov 24 '18 at 12:08
1
In that case, i'm now aware of the eloquent way, but you can query the tables as in: DB::table('blah_blah-1')-join('...')->...;
– Fatemeh Majd
Nov 24 '18 at 12:49
2
Should the products have one of these tags or all of them?
– Jonas Staudenmeir
Nov 24 '18 at 17:58
1
Are you wanting products that have all 3 tags?
– Ross Wilson
Nov 24 '18 at 18:50
|
show 2 more comments
1
try: $products->with(['tags' => function($query){ $query->whereIn('id', [1,2,3]);}]);
– Fatemeh Majd
Nov 24 '18 at 11:48
@FatemehMajd this will return products that has tags in this array. i mean a product with 1 tag_id also is in your solution
– Joseph Rback
Nov 24 '18 at 12:08
1
In that case, i'm now aware of the eloquent way, but you can query the tables as in: DB::table('blah_blah-1')-join('...')->...;
– Fatemeh Majd
Nov 24 '18 at 12:49
2
Should the products have one of these tags or all of them?
– Jonas Staudenmeir
Nov 24 '18 at 17:58
1
Are you wanting products that have all 3 tags?
– Ross Wilson
Nov 24 '18 at 18:50
1
1
try: $products->with(['tags' => function($query){ $query->whereIn('id', [1,2,3]);}]);
– Fatemeh Majd
Nov 24 '18 at 11:48
try: $products->with(['tags' => function($query){ $query->whereIn('id', [1,2,3]);}]);
– Fatemeh Majd
Nov 24 '18 at 11:48
@FatemehMajd this will return products that has tags in this array. i mean a product with 1 tag_id also is in your solution
– Joseph Rback
Nov 24 '18 at 12:08
@FatemehMajd this will return products that has tags in this array. i mean a product with 1 tag_id also is in your solution
– Joseph Rback
Nov 24 '18 at 12:08
1
1
In that case, i'm now aware of the eloquent way, but you can query the tables as in: DB::table('blah_blah-1')-join('...')->...;
– Fatemeh Majd
Nov 24 '18 at 12:49
In that case, i'm now aware of the eloquent way, but you can query the tables as in: DB::table('blah_blah-1')-join('...')->...;
– Fatemeh Majd
Nov 24 '18 at 12:49
2
2
Should the products have one of these tags or all of them?
– Jonas Staudenmeir
Nov 24 '18 at 17:58
Should the products have one of these tags or all of them?
– Jonas Staudenmeir
Nov 24 '18 at 17:58
1
1
Are you wanting products that have all 3 tags?
– Ross Wilson
Nov 24 '18 at 18:50
Are you wanting products that have all 3 tags?
– Ross Wilson
Nov 24 '18 at 18:50
|
show 2 more comments
1 Answer
1
active
oldest
votes
Use whereHas()
with all four parameters:
$tagIds = [1, 2, 3];
$products = Product::whereHas('tags', function($query) use($tagIds) {
$query->whereIn('tags.id', $tagIds);
}, '=', count($tagIds))->get();
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53457502%2flaravel-get-all-models-that-have-array-of-relations%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use whereHas()
with all four parameters:
$tagIds = [1, 2, 3];
$products = Product::whereHas('tags', function($query) use($tagIds) {
$query->whereIn('tags.id', $tagIds);
}, '=', count($tagIds))->get();
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
add a comment |
Use whereHas()
with all four parameters:
$tagIds = [1, 2, 3];
$products = Product::whereHas('tags', function($query) use($tagIds) {
$query->whereIn('tags.id', $tagIds);
}, '=', count($tagIds))->get();
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
add a comment |
Use whereHas()
with all four parameters:
$tagIds = [1, 2, 3];
$products = Product::whereHas('tags', function($query) use($tagIds) {
$query->whereIn('tags.id', $tagIds);
}, '=', count($tagIds))->get();
Use whereHas()
with all four parameters:
$tagIds = [1, 2, 3];
$products = Product::whereHas('tags', function($query) use($tagIds) {
$query->whereIn('tags.id', $tagIds);
}, '=', count($tagIds))->get();
answered Nov 26 '18 at 11:44
Jonas StaudenmeirJonas Staudenmeir
12.2k2933
12.2k2933
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
add a comment |
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
Intelligently method!!
– Joseph Rback
Nov 26 '18 at 12:21
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53457502%2flaravel-get-all-models-that-have-array-of-relations%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
try: $products->with(['tags' => function($query){ $query->whereIn('id', [1,2,3]);}]);
– Fatemeh Majd
Nov 24 '18 at 11:48
@FatemehMajd this will return products that has tags in this array. i mean a product with 1 tag_id also is in your solution
– Joseph Rback
Nov 24 '18 at 12:08
1
In that case, i'm now aware of the eloquent way, but you can query the tables as in: DB::table('blah_blah-1')-join('...')->...;
– Fatemeh Majd
Nov 24 '18 at 12:49
2
Should the products have one of these tags or all of them?
– Jonas Staudenmeir
Nov 24 '18 at 17:58
1
Are you wanting products that have all 3 tags?
– Ross Wilson
Nov 24 '18 at 18:50