Book Image

Laravel 5 Essentials

By : Martin Bean
Book Image

Laravel 5 Essentials

By: Martin Bean

Overview of this book

Table of Contents (15 chapters)
Laravel 5 Essentials
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Query scopes


The previous section introduced you to the concept of query scopes. This builds on from the query builder that allows you to build conditions on an ad hoc basis. However, what if you need certain conditions to apply to every request? Or a single condition that is actually the combination of multiple WHERE clauses? This is where query scopes come in.

Query scopes allow you to define these conditions once in your model, and then re-use them without having to manually define the clauses that make up that condition. For example, imagine we need to find users above the age of 21 in multiple places in our application. We can express this as a query scope:

class User extends Model {

  public function scopeOver21($query)
  {
    $date = Carbon::now()->subYears(21);
    return $query->where('birth_date', '<', $date);
  }
}

Thanks to the fluent query builder, we can now use this as follows:

$usersOver21 = User::over21()->get();

As you can see, query scopes are methods that begin...