Forum Change query based on variable from URL

hardist

posted 9 years ago

Database Eloquent Views

Last updated 2 years ago.

thomastkim

replied 9 years ago

Solution

Hmm....I can't really see anything except maybe calling paginate(25) at the end instead of repeating it by building upon a single query:

public function index($label = 'false')
{
    $search = Input::get('search');
    $query = Appointment::query();

    if(Input::has('search')) {
        $query->where('appointment', 'LIKE', '%'. $search .'%');
    } elseif($label !== 'false') {
        $query->orderBy($order, $sort)->where('label', '=', $label);
    }
    
    $appointments = $query->paginate(25);
    return view('appointments.index', compact('appointments', 'search', 'label'));
}