Eloquent 中的 IN 语句

2021-12-26 00:00:00 mysql laravel 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 :)

相关文章