Laravel's Eloquent ORM simplifies database queries through PHP objects. Basic search includes using ::all() to obtain all records, using ::find() or ::findOrFail() to obtain a single record through the primary key, and adding conditions to the where() method to retrieve specific data; you can chain calls where(), whereIn(), whereNull() and other methods to filter the result set; support relationship processing between models, such as defining one-to-many relationships through hasMany and using with() to achieve preloading to avoid N 1 query problems; paging can be implemented through paginate(), and performance optimization suggestions include selecting necessary fields, using cache and indexing reasonably.

Retrieving data from a database using Eloquent in Laravel is straightforward and powerful. Eloquent provides an easy-to-use ORM (Object-Relational Mapping) that lets you interact with your database using PHP objects instead of writing raw SQL queries.

Here's how to get started and some common practices when retrieving data with Eloquent.

Basic Retrieval: Get All or One Record

To fetch all records from a table, use the ::all() method on your model:

 $users = User::all();

This returns a collection of all users in the database. If you want to retrieve a single record by its primary key (like ID), use ::find() :

 $user = User::find(1);

If no record is found, it returns null . For cases where you expect a result and want to throw an exception if not found, use ::findOrFail() instead.

You can also add conditions to your query using methods like where() :

 $user = User::where('email', 'test@example.com')->first();

This retrieves the first user with that email address.

Filtering Results with Conditions

Eloquent allows you to chain conditions to narrow down your query results.

For example:

 $users = User::where('active', 1)
             ->where('role', 'admin')
             ->get();

This gets all active admin users. You can also use more complex conditions like whereIn , whereNull , or even raw expressions if needed.

Some commonly used filtering methods:

• where('column', 'value') – basic condition
• whereIn('column', [values]) – match any value in an array
• whereNull('column') – check for null values
• orderBy('column', 'direction') – sort results

These filters make it simple to build dynamic queries based on user input or application logic.

Working with Relationships

One of Eloquent's biggest strengths is handling relationships between models. Let's say a User has many Posts . You can define that relationship in your model and then retrieve related data easily.

First, define the relationship in the User model:

 public function posts()
{
    return $this->hasMany(Post::class);
}

Then, retrieve the user's posts:

 $user = User::find(1);
$posts = $user->posts;

If you want to filter those posts further, you can chain conditions:

 $publishedPosts = $user->posts()->where('status', 'published')->get();

Eager loading helps avoid performance issues when fetching multiple related models:

 $users = User::with('posts')->get();

This ensures all users and their posts are loaded efficiently in one query instead of making separate queries per user.

Pagination and Performance Tips

When retrieving large datasets, especially for display in web interfaces, pagination is essential. Use the paginate() method:

 $users = User::paginate(10);

This automatically handles splitting results into pages and generating URLs for navigation.

To improve performance:

• Only select the fields you need using select()
• Use with() to eager load relationships
• Avoid N 1 queries by thinking ahead about what data you'll access
• Use caching for frequently accessed but rarely changed data

Also, consider indexing columns that are often queried, especially foreign keys involved in relationships.

That's basically how you retrieve data using Eloquent. It's expressive and clean once you get the hang of it — just remember to structure your queries smartly to keep things fast and readable.

The above is the detailed content of How do I retrieve data from the database using Eloquent?. For more information, please follow other related articles on the PHP Chinese website!