mysql - 如何在laravel中搜索属于某个标签的所有文章

Question

文章模型

class Article {
    public function Tag(){
      return $this->belongsToMany('App\Tag');
    }
}

标签模型

class Tag {
    public function Article(){
      return $this->belongsToMany('App\Article');
    }
}

数据透视表

article_id === tag_id

我想搜索所有使用标签名称的书籍。我该怎么做？

我的解决方案

public function tagArticle($name)
{
    $tags = $this->tag->where('name',$name)->get();
    $articles = [];
    foreach ($tags as $tag) {
        $articles[] = $tag->articles;
    }
    return view('front.home')->with('articles',$articles);
}

This is my solution, but I don't think it's good. Does anyone has other solutions? Thank you.

Answer 1

使用whereHas()

 $articles=Article::whereHas('tags',function($query)
        {
            $query->where('name',$name);
        })->get();