Laravel5中如何使用Eloquent与Query Builder实现相关需求？

Hey there! Let's dive into Laravel 5's Eloquent and Query Builder—these are super powerful tools, so I'll walk you through some common practical implementations that might align with what you're trying to build.

1. 基础数据查询 #

Query Builder 写法 #

// 获取所有用户，按创建时间倒序，仅返回name和email字段
$users = DB::table('users')
            ->select('name', 'email')
            ->orderBy('created_at', 'desc')
            ->get();

Eloquent 模型写法（假设你已创建User模型） #

$users = User::select('name', 'email')
            ->latest('created_at')
            ->get();

2. 关联数据查询（例：用户关联文章） #

先在User模型中定义关联关系：

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

然后查询用户及其最新的3篇文章：

$users = User::with(['posts' => function ($query) {
    $query->latest()->take(3);
}])->get();

3. 复杂多条件过滤 #

// 获取状态为活跃，且注册时间在2023年后，或者邮箱包含@example.com的用户
$users = User::where('status', 'active')
            ->where(function ($query) {
                $query->where('created_at', '>', '2023-01-01')
                      ->orWhere('email', 'like', '%@example.com%');
            })
            ->get();

4. 聚合统计操作 #

// 获取活跃用户总数
$activeUserCount = User::where('status', 'active')->count();

// 获取所有用户的平均年龄
$averageAge = User::avg('age');

5. 批量数据操作 #

批量插入 #

User::insert([
    ['name' => 'Alice', 'email' => 'alice@example.com'],
    ['name' => 'Bob', 'email' => 'bob@example.com'],
]);

批量更新 #

// 将所有状态为inactive的用户改为active
User::where('status', 'inactive')
    ->update(['status' => 'active']);

If you have more specific needs—like a particular subquery, pagination setup, or advanced association logic—just share the details and I can help refine the implementation further!

内容的提问来源于stack exchange，提问作者Mingeun Kim