php - 具有多个输入的 Laravel 高级查询

Question

我有一些带有多个参数的搜索，我想查询输入是否不为 null 然后进行查询参数。

我试了很多方法都无法得到查询结果。

这是我的示例代码

$products = Product::where('game_id',$tg->id);
        if($keyword !=null){
            $products->where("name","like",$keyword);
        }
        if($price_start !=null){
            $products->where("price",">",$price_start);
        }
        if($price_end !=null){
            $products->where("price","<",$price_end);
        }
        if($avalibility !=null){
            $products->where("status","=",$avalibility);
        }

        $products->orderBy("created_at","DESC");
        $products->get();

Answer 1

试试这个

 $products = Product::select('*')
                ->where(function ($query) use($request){
                            if($keyword !=null){
                                $query->where('name','like','%'.$keyword.'%');
                            }
                            if($price_start !=null){
                                $query->where("price",">",$price_start);
                            }
                            if($price_end !=null){
                                $query->where("price","<",$price_end);
                            }
                            if($avalibility !=null){
                                $query->where("status","=",$avalibility);
                            }
                        })
                ->where('game_id',$tg->id)
                ->orderBy('created_at', 'DESC')
                ->get();