Eloquent 中的 IN 语句 [英] IN statement in Eloquent

问题描述

我正在尝试在 Eloquent 查询中执行 IN 语句.我试过这个:

I'm trying to execute IN statement in Eloquent query. I tried this:

$id = urldecode($id);

$news = News::whereHas('newsCategories', function($q) use($id)
{
    $q->where('category_id', 'IN', '('.$id.')')->orderBy('created_at', 'desc');
})->get();

但我得到空结果.

当我将 IN 切换为 = 并传递一个数字而不是数组时，我会得到结果.我做错了什么吗?

When I switch IN for = and pass a number instead of array I get results. Did I do something wrong?

所以这是有效的:

$id = 2;

$news = News::whereHas('newsCategories', function($q) use($id)
{
    $q->where('category_id', '=', $id)->orderBy('created_at', 'desc');
})->get();

推荐答案

您希望 whereIn 带有要检查的 id 数组...

You want whereIn with an array of your ids to be checked...

$news = News::whereHas('newsCategories', function($q) use($array_of_ids)
{
    $q->whereIn('category_id', $array_of_ids)
      ->orderBy('created_at', 'desc');
})->get();

只要确保你传递的是真正的数组:)

Just make sure that you're passing in something that is truly an array :)

这篇关于Eloquent 中的 IN 语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！