Laravel Eloquent ORM in Bangla Part-Models Retrieving)

Laravel Eloquent provides convenient and readable methods to interact with the database, making it easy to obtain database data. Several data acquisition techniques are introduced below:

1. Get all records

Use the all() method to get all records in the table:

use App\Models\Post;

$posts = Post::all();

This will return a Collection. You can access data using foreach loops or other collection methods:

foreach ($posts as $post) {
    echo $post->title;
}

2. Get a single record

1. find() Method: Get a single record based on the primary key.

$post = Post::find(1);

if ($post) {
    echo $post->title;
}

2. findOrFail() Method: Get a single record based on the primary key. If the record does not exist, a 404 exception will be thrown.

$post = Post::findOrFail(1);

3. first() Method: Get the first record that meets the conditions.

$post = Post::where('status', 'published')->first();

4. firstOrFail() Method: Get the first record that meets the conditions. If the record does not exist, a 404 exception will be thrown.

$post = Post::where('status', 'published')->firstOrFail();

3. Use query conditions to filter records

Use where and other conditional statements to filter data.

1. where Method:

$posts = Post::where('status', 'published')->get();

2. Multiple conditions:

$posts = Post::where('status', 'published')
             ->where('user_id', 1)
             ->get();

3. orWhere Method:

$posts = Post::where('status', 'published')
             ->orWhere('status', 'draft')
             ->get();

4. Select specific fields

Eloquent gets all fields by default. Use the select() method to select a specific field:

$posts = Post::select('title', 'content')->get();

5. Pagination

Use the paginate() method to get data in pages:

$posts = Post::paginate(10);

Show pagination links in Blade templates:

{{ $posts->links() }}

6. Data Chunking

When processing large amounts of data, memory usage can be effectively reduced:

Post::chunk(100, function ($posts) {
    foreach ($posts as $post) {
        echo $post->title;
    }
});

7. Sorting results (Ordering)

Use the orderBy() method to sort in the specified order:

$posts = Post::orderBy('created_at', 'desc')->get();

8. Limit and Offset

Use take() or limit() and skip() methods to limit the number of records fetched:

$posts = Post::take(5)->get(); // 获取前 5 条记录
$posts = Post::skip(10)->take(5)->get(); // 跳过前 10 条，获取接下来的 5 条

9. Aggregate functions (Aggregates)

1. Count:

$count = Post::count();

2. Maximum value:

$maxViews = Post::max('views');

3. Minimum value:

$minViews = Post::min('views');

4. Average:

$avgViews = Post::avg('views');

5. Sum:

$totalViews = Post::sum('views');

10. Customized relationship retrieval

Eloquent supports obtaining data from other models through relationships.

1. Eager Loading:

$posts = Post::with('comments')->get();

2. Specify relationship:

$posts = Post::with(['comments', 'user'])->get();

11. Raw Queries

Execute custom SQL queries using Laravel’s DB facade:

use App\Models\Post;

$posts = Post::all();

These methods provide flexible data acquisition methods to meet various database operation needs. Please choose the appropriate method according to the actual situation.

The above is the detailed content of Laravel Eloquent ORM in Bangla Part-Models Retrieving). For more information, please follow other related articles on the PHP Chinese website!