Laravel Query Builder to Eloquent

Question

I have the following PHP code:

$users = DB::table('users');

if (Input::has('minAge') && Input::has('maxAge')) {
    $users = $users->whereBetween('age', array(Input::get('minAge'), Input::get('maxAge')));
} else if (Input::has('minAge')) {
    $users = $users->where('age', '>=', Input::get('minAge'));
} else if (Input::has('maxAge')) {
    $users = $users->where('age', '>=', Input::get('maxAge'));
}

if (Input::has('sex') && Input::get('sex') !== "0") {
    $users = $users->where('sex', '=', Input::get('sex'));
}

$users = $users->paginate(15);

return View::make('search.result', compact('users'));

However I would like to retrieve through Eloquent as the entity object has some functionality needed in view.

Anyway, I've tried to mimic the above but it doesn't work, I think the objects are rather overriden than chained.

Here is my attempt:

if (Input::has('minAge') && Input::has('maxAge')) {
            $users = User::whereBetween('age', array(Input::get('minAge'), Input::get('maxAge')));

} else if (Input::has('minAge')) {
            $users = User::where('age', '>=', Input::get('minAge'));

} else if (Input::has('maxAge')) {
            $users = User::where('age', '>=', Input::get('maxAge'));
}

if (Input::has('sex') && Input::get('sex') !== "0") {
            $users = User::where('sex', '=', Input::get('sex'));
}

$users = User::paginate(15);

return View::make('search.result', compact('users'));

peterm · Accepted Answer · 2014-07-27 04:10:02Z

1

Try

$input = Input::only('minAge', 'maxAge', 'sex');

$query = User::query();

if (! is_null($input['minAge'])) {
    $query->where('age', '>=', $input['minAge']);
}

if (! is_null($input['maxAge'])) {
    $query->where('age', '<=', $input['maxAge']);
}

if (! is_null($input['sex'])) && $input['sex'] !== "0") {
    $query->where('sex', '=', $input['sex']);
}

$users = $query->paginate(15);

return View::make('search.result', compact('users'));

edited Jul 27, 2014 at 4:10

answered Jul 26, 2014 at 22:06

peterm

93k16 gold badges157 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

Laravel Query Builder to Eloquent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related