Laravel advanced query with multiple inputs

Question

I have some search with multiple arguments and I want to query if the input is not null then make query argument.

I tried many ways but I cannot get query results.

Here is my sample code

$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();

You are not doing anything with the result of $products->get() — apokryfos
– apokryfos, Commented Jan 5, 2020 at 9:08

Gorkhali Khadka · Accepted Answer · 2020-01-05 09:50:05Z

2

Try this

 $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();

answered Jan 5, 2020 at 9:50

Gorkhali Khadka

8358 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sasindu Jayampathi Over a year ago

This method worked for me. Thank you and others all. You Saved My Time

khaleelibrahim · Accepted Answer · 2020-01-05 10:08:08Z

2

In your code assign the result of query to the variable products as follows:

$products = $products->get();

now the $products will contain the result

answered Jan 5, 2020 at 10:08

khaleelibrahim

944 bronze badges

Comments

Tilieth · Accepted Answer · 2020-01-05 09:17:33Z

1

Try adding ->get() to the query builder.

$products = Product::where('game_id',$tg->id)->orderBy->('created_at', 'desc')->get().

Use the explicit ->get() on the query builder to get a collection. And then use laravels collection methods (https://laravel.com/docs/5.8/collections#available-methods) to add further where clauses and sort the results (see sortBy method) or add the orderBy clause to the intial query (as above). You can leave out the final ->get() since it's called on the query builder.

Using the 'where' collection method inside the if statement:

if(isset($keyword)) {
    $products = $products->where('name','like', '%' . $keyword . '%');
}

answered Jan 5, 2020 at 9:17

Tilieth

212 bronze badges

Comments

Md. Amirozzaman · Accepted Answer · 2020-01-05 09:25:01Z

0

First you need to validate your data as follow

$request->validate([
    'id' => 'required',
    'keyword' => 'required',
    'price_start' => 'required',
    'availability' => 'required'
]);

Now you can perform your data query with these validate Data. If you have multiple data for where method you might be put all of them in array ,after that to fetch the data-you should use get() method; like as bellow

$products = Product::where([
              ['id', '=', $request->id],
              ['keyword', 'like', $request->keyword]
            ])
            ->orderBy("created_at","DESC")
            ->get();

edited Jan 5, 2020 at 9:25

answered Jan 5, 2020 at 9:13

Md. Amirozzaman

1,14311 silver badges22 bronze badges

1 Comment

Sasindu Jayampathi Over a year ago

Arguments do not need to validate because query must run if required some inputs

Collectives™ on Stack Overflow

Laravel advanced query with multiple inputs

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related