在Laravel中使用标签搜索

Question

我是Laravel的新手，

尝试通过标签创建搜索系统，例如我有一个products表，每个产品在product_tags表中都有多个标签。product_tags表有两列product_id和product_tag

$search = $req->get('search'); // Input from user 

$products = Product::with(['images', 'tags'])
->where('id', 'LIKE' , '%'.$search.'%')
->orWhere('product_name', 'LIKE' , '%'.$search.'%')
->orWhere('product_price', 'LIKE' , '%'.$search.'%')
->get();
dd($products);

产品模态

class Product extends Model
{
use HasFactory;
public function images()
{
return $this->hasMany(ProductImage::class, 'product_id', 'id')->orderBy('id', 'desc');
}
public function tags()
{
return $this->hasMany(ProductTag::class, 'product_id', 'id')->orderBy('id', 'desc');
}
}

Answer 1

Product::with(['images', 'tags'])
->where(function ($query) use ($search) {
$query->where('id', 'LIKE' , '%'.$search.'%')
->orWhere('product_name', 'LIKE' , '%'.$search.'%')
->orWhere('product_price', 'LIKE' , '%'.$search.'%');
})
->orWhereHas('tags', function ($query) use ($search) {
$query->where('product_tag', 'LIKE', '%'.$search.'%');
})
->get();

• 查询:逻辑分组
• 雄辩关系:查询关系存在