国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Table of Contents
What Are Query Scopes?
How to Define a Local Scope
When Should You Use Scopes?
A Few Things to Watch Out For
Home PHP Framework Laravel How do I use query scopes in Eloquent?

How do I use query scopes in Eloquent?

Jun 26, 2025 am 10:28 AM

Query scopes in Eloquent help organize and reuse query logic by defining custom methods on models. 1. Local scopes are defined with a scope prefix and apply reusable constraints, like filtering popular users via scopePopular(). 2. They can accept parameters, such as scopeWithMinFollowers() for dynamic filtering. 3. Scopes should be used to avoid repetitive where clauses, streamline controllers, and model-level filters like active() or published(). 4. They work only on query builders, not collections, and should have clear, descriptive names. 5. Combine scopes with conditionals for flexible dynamic queries, improving maintainability and testability across applications like APIs or admin panels.

When you're working with Eloquent in Laravel and find yourself repeating the same types of query constraints across different parts of your app, query scopes are a great way to keep your code clean and reusable. They let you define common query logic inside your model so you can reuse it anywhere without duplicating code.

What Are Query Scopes?

In simple terms, query scopes are custom methods you define on your Eloquent models that apply certain query constraints. These can be used to filter results based on specific conditions every time you need them.

There are two types:

  • Local Scopes: These start with scope and allow you to add reusable query constraints.
  • Global Scopes: These automatically apply to all queries for a model — useful for things like soft-deleting or tenant-based filtering.

We'll focus mainly on local scopes here since they're more commonly used by developers in day-to-day work.

How to Define a Local Scope

Let's say you often want to get "popular" users — maybe those with more than 100 followers. Instead of writing this condition manually each time, you can define a scope:

// In your User model
public function scopePopular($query)
{
    return $query->where('followers', '>', 100);
}

Then, when querying, you just do:

$users = User::popular()->get();

It’s important to note that the method must start with scope, and the first parameter should always be the $query. This tells Eloquent it's a scope.

You can also chain scopes together:

$users = User::popular()->active()->orderBy('name')->get();

If your scope needs parameters, like filtering by a minimum number of followers, you can do that too:

public function scopeWithMinFollowers($query, $min)
{
    return $query->where('followers', '>', $min);
}

And call it like:

User::withMinFollowers(50)->get();

When Should You Use Scopes?

Use scopes when:

  • You’re writing the same where clauses in multiple places.
  • You want to make your controllers thinner and push logic into the model layer.
  • You have filters that are meaningful at the model level (like active(), published(), recent()).

They help avoid messy controller methods and make your code easier to test and maintain.

Some real-world examples include:

  • Filtering out inactive users
  • Getting posts published in the last week
  • Returning only verified accounts

Also, if you're building an API or admin panel with lots of filters, scopes can help you cleanly build dynamic queries.

A Few Things to Watch Out For

  • Scopes only work on the query builder — not on collections. So don’t try to use them after calling get() or looping through results.
  • Make sure your naming is clear. A scope called active() should clearly indicate what it does — ideally without needing extra comments.
  • If you're using complex logic, consider combining scopes with query builder conditionals for flexibility.

For example:

$query = User::query();

if ($request->has('only_popular')) {
    $query->popular();
}

$users = $query->get();

This keeps your logic flexible and easy to extend later.


That's basically how query scopes work in Eloquent. It's not complicated, but it’s super useful once you start organizing your queries this way.

The above is the detailed content of How do I use query scopes in Eloquent?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What are routes in Laravel, and how are they defined? What are routes in Laravel, and how are they defined? Jun 12, 2025 pm 08:21 PM

In Laravel, routing is the entry point of the application that defines the response logic when a client requests a specific URI. The route maps the URL to the corresponding processing code, which usually contains HTTP methods, URIs, and actions (closures or controller methods). 1. Basic structure of route definition: bind requests using Route::verb('/uri',action); 2. Supports multiple HTTP verbs such as GET, POST, PUT, etc.; 3. Dynamic parameters can be defined through {param} and data can be passed; 4. Routes can be named to generate URLs or redirects; 5. Use grouping functions to uniformly add prefixes, middleware and other sharing settings; 6. Routing files are divided into web.php, ap according to their purpose

What are policies in Laravel, and how are they used? What are policies in Laravel, and how are they used? Jun 21, 2025 am 12:21 AM

InLaravel,policiesorganizeauthorizationlogicformodelactions.1.Policiesareclasseswithmethodslikeview,create,update,anddeletethatreturntrueorfalsebasedonuserpermissions.2.Toregisterapolicy,mapthemodeltoitspolicyinthe$policiesarrayofAuthServiceProvider.

How do I create new records in the database using Eloquent? How do I create new records in the database using Eloquent? Jun 14, 2025 am 12:34 AM

To create new records in the database using Eloquent, there are four main methods: 1. Use the create method to quickly create records by passing in the attribute array, such as User::create(['name'=>'JohnDoe','email'=>'john@example.com']); 2. Use the save method to manually instantiate the model and assign values ??to save one by one, which is suitable for scenarios where conditional assignment or extra logic is required; 3. Use firstOrCreate to find or create records based on search conditions to avoid duplicate data; 4. Use updateOrCreate to find records and update, if not, create them, which is suitable for processing imported data, etc., which may be repetitive.

How do I run seeders in Laravel? (php artisan db:seed) How do I run seeders in Laravel? (php artisan db:seed) Jun 12, 2025 pm 06:01 PM

Thephpartisandb:seedcommandinLaravelisusedtopopulatethedatabasewithtestordefaultdata.1.Itexecutestherun()methodinseederclasseslocatedin/database/seeders.2.Developerscanrunallseeders,aspecificseederusing--class,ortruncatetablesbeforeseedingwith--trunc

What is the purpose of the artisan command-line tool in Laravel? What is the purpose of the artisan command-line tool in Laravel? Jun 13, 2025 am 11:17 AM

Artisan is a command line tool of Laravel to improve development efficiency. Its core functions include: 1. Generate code structures, such as controllers, models, etc., and automatically create files through make: controller and other commands; 2. Manage database migration and fill, use migrate to run migration, and db:seed to fill data; 3. Support custom commands, such as make:command creation command class to implement business logic encapsulation; 4. Provide debugging and environment management functions, such as key:generate to generate keys, and serve to start the development server. Proficiency in using Artisan can significantly improve Laravel development efficiency.

How do I install Laravel on my operating system (Windows, macOS, Linux)? How do I install Laravel on my operating system (Windows, macOS, Linux)? Jun 19, 2025 am 12:31 AM

Yes,youcaninstallLaravelonanyoperatingsystembyfollowingthesesteps:1.InstallPHPandrequiredextensionslikembstring,openssl,andxmlusingtoolslikeXAMPPonWindows,HomebrewonmacOS,oraptonLinux;2.InstallComposer,usinganinstalleronWindowsorterminalcommandsonmac

How do I define methods (actions) in a controller? How do I define methods (actions) in a controller? Jun 14, 2025 am 12:38 AM

Defining a method (also known as an action) in a controller is to tell the application what to do when someone visits a specific URL. These methods usually process requests, process data, and return responses such as HTML pages or JSON. Understanding the basic structure: Most web frameworks (such as RubyonRails, Laravel, or SpringMVC) use controllers to group related operations. Methods within each controller usually correspond to a route, i.e. the URL path that someone can access. For example, there may be the following methods in PostsController: 1.index() – display post list; 2.show() – display individual posts; 3.create() – handle creating new posts; 4.u

How do I run tests in Laravel? (php artisan test) How do I run tests in Laravel? (php artisan test) Jun 13, 2025 am 12:02 AM

ToruntestsinLaraveleffectively,usethephpartisantestcommandwhichsimplifiesPHPUnitusage.1.Setupa.env.testingfileandconfigurephpunit.xmltouseatestdatabaselikeSQLite.2.Generatetestfilesusingphpartisanmake:test,using--unitforunittests.3.Writetestswithmeth

See all articles