Master Laravel Eloquent: Essential Concepts and Practical Usage

What is Eloquent?

Eloquent is Laravel's Object‑Relational Mapping (ORM) layer that maps each model class to a database table and wraps common database operations in convenient methods, allowing developers to work with data using an object‑oriented syntax.

Basic Usage Examples

Find a record by ID and print its title

$article = Article::find(2);

echo $article->title;

Find a record by title and print its ID

$article = Article::where('title', '我是标题')->first();

echo $article->id;

Retrieve all articles and loop through their titles

$articles = Article::all(); // returns a collection of models

foreach ($articles as $article) {
    echo $article->title;
}

Find articles with IDs between 10 and 20 and print titles

$articles = Article::where('id', '>', 10)
    ->where('id', '<', 20)
    ->get();

foreach ($articles as $article) {
    echo $article->title;
}

Retrieve articles in the ID range 10‑20, ordered by latest update

$articles = Article::where('id', '>', 10)
    ->where('id', '<', 20)
    ->orderBy('updated_at', 'desc')
    ->get();

foreach ($articles as $article) {
    echo $article->title;
}

Key Points for Using Eloquent

Every model that extends Eloquent provides two fixed methods: Model::find($id) returns a single object, and Model::all() returns a collection of all records.

Intermediate query methods such as where() and orderBy() can be called statically ( Model::where(...)) or on an instance ( $model->where(...)) and support method chaining.

Non‑fixed query chains must be terminated with a terminal method like get() (to retrieve a collection) or first() (to retrieve a single record).