Laravel limit query param results

Question

i have a query which filters films based upon the input by the user, i am needing to add a limit as a query parameter so it limits the amount of films that are returned, how do i add this in, i am new to writing eloquent queries.

query

$films = Film
::when($request->input('first'), function ($query, $first) {
    $query->whereHas('options', function ($query) use ($first) {
        $query->where('first', $main);
    });
})
->when($request->input('second'), function ($query, $second) {
    $query->whereHas('options', function ($query) use ($second) {
        $query->where('second', $second );
    });
})
->when($request->input('age'), function ($query, $age) {
    $query->whereHas('ageRatings', function ($query) use ($age) {
        $query->where('age', $age);
    });
})
->when($request->input('country'), function ($query, $country) {
    $query->whereHas('locations', function ($query) use ($country) {
        $query->where('country', $country);
    });
})
->when($request->input('city'), function ($query, $city) {
    $query->whereHas('locations', function ($query) use ($city) {
        $query->where('city', $city);
    });
})
->get();

Use ->take(10) -> get... See other question: stackoverflow.com/questions/35643192/… — Bert Maurau
– Bert Maurau, Commented Jan 21, 2020 at 15:06

Patrick Schocke · Accepted Answer · 2020-01-21 15:09:28Z

1

You can use $query->limit(5) or $query->take(5).

If you want to skip the first 5 results, use $query->skip(5)

If you want to add pagination, you can use $query->paginate(5)

See More: Query Builder

answered Jan 21, 2020 at 15:09

Patrick Schocke

1,4912 gold badges15 silver badges25 bronze badges

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

2 Comments

lilnoobcoder Over a year ago

thanks will the url look like this then /films?limit=5

Patrick Schocke Over a year ago

This has nothing to do with urls. You need to update your url or get the value from the url manually

lilnoobcoder · Accepted Answer · 2020-01-23 00:15:12Z

0

You can use both of these method

the Limit method

$limit = 10;
$films = Film
::when($request->input('first'), function ($query, $first) {
    $query->whereHas('options', function ($query) use ($first) {
        $query->where('first', $first);
    });
})
->when($request->input('second'), function ($query, $second) {
    $query->whereHas(‘options', function ($query) use ($second) {
        $query->where('second', $second);
    });
})
->when($request->input('age'), function ($query, $age) {
    $query->whereHas('ageRatings', function ($query) use ($age) {
        $query->where('age', $age);
    });
})
->when($request->input('country'), function ($query, $country) {
    $query->whereHas('locations', function ($query) use ($country) {
        $query->where('country', $country);
    });
})
->when($request->input('city'), function ($query, $city) {
    $query->whereHas('locations', function ($query) use ($city) {
        $query->where('city', $city);
    });
})
->limit($limit)
->get();

the Take method

$limit = 10;
    $films = Film
    ::when($request->input('first'), function ($query, $first) {
        $query->whereHas('options', function ($query) use ($first) {
            $query->where('first', $first);
        });
    })
    ->when($request->input('second'), function ($query, $second) {
        $query->whereHas('options', function ($query) use ($second) {
            $query->where('second', $second);
        });
    })
    ->when($request->input('age'), function ($query, $age) {
        $query->whereHas('ageRatings', function ($query) use ($age) {
            $query->where('age', $age);
        });
    })
    ->when($request->input('country'), function ($query, $country) {
        $query->whereHas('locations', function ($query) use ($country) {
            $query->where('country', $country);
        });
    })
    ->when($request->input('city'), function ($query, $city) {
        $query->whereHas('locations', function ($query) use ($city) {
            $query->where('city', $city);
        });
    })
    ->take($limit)
    ->get();

edited Jan 23, 2020 at 0:15

lilnoobcoder

952 silver badges12 bronze badges

answered Jan 21, 2020 at 15:10

Qonvex620

3,9801 gold badge12 silver badges17 bronze badges

4 Comments

lilnoobcoder Over a year ago

thanks will the url look like this then /films?limit=10

lilnoobcoder Over a year ago

get the value of limit in url do you mean this solution you provided will return the above url or am i needing to get something else

Qonvex620 Over a year ago

no it does not, you have to get first the value of limit in your url and initialize it to a variable before you execute the query

Qonvex620 Over a year ago

btw there are two options on how you can get the value of limit you want to pass, just visit this article 5balloons.info/…

Collectives™ on Stack Overflow

Laravel limit query param results

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related