Laravel 4 Eloquent Dynamic Where Clause

Question

I recently learned about dynamic where clauses (I think that's what is called) in Laravel 4 Eloquent which makes where clauses like User::where('first_name', 'Jon')->get() becomes nicer User::whereFirstName('Jon')->get(). How flexible is this??

Can i for example do the following

• multiple columns User::whereFirstNameOrLastName('Jon', 'Smith')->get();
• use operator other than = like >= or LIKE

Answer 1

You can use Query Scope to achieve what you needed.

A simple illustration:

public function scopeFirstOrLastName($query, $first, $last)
{
    return $query->where('first_name', 'LIKE', '%' . $first . '%')
                 ->where('last_name', 'LIKE', '%' . $last . '%');
}

Using it:

$user->firstOrLastName('John', 'Doe')->get();

You can name it as you see fit, and you can use any operator (or any query builder operation) inside.