Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

unknownUser17's avatar

Filter by date range OR member ID

I am trying to filter the data either by date range or by member ID. Below is what I have tried but it returns page not found.

enter image description here

I been tried many ways but still can't display out the data. The route url to blade is all correct however it just not displaying the blade file. It is something wrong in my controller codes?

Controller

$members = Membership::with(['profile'])
    ->when($request->memberId, function ($query) use ($request) {
        $query->where('id', 'LIKE', '%' . $request->value . '%');
    })
    ->when($request->dateStarted, function ($query) use ($request) {
        $dateS = date('Y-m-d', strtotime($request->dateStarted));
        $query->whereDate('created_at', '>=', $dateS);
    })
    ->when($request->dateEnded, function ($query) use ($request) {
        $dateE = date('Y-m-d', strtotime($request->dateEnded));
        $query->whereDate('created_at', '<=', $dateE);
    })
    ->latest()
    ->paginate(15);
0 likes
2 replies
MohamedTammam's avatar

If it sends 404, mostly there's something wrong in your routes.

Sinnbeck's avatar

If you get 404, the error probably happens before this code is ever run. You can test this by adding dd('test'); above your code

Please show the url you get and the route

Please or to participate in this conversation.