在模型中也可以调用数据库的聚合方法进行查询,例如:
静态调用:
User::count();
User::where('status','>',0)->count();
User::where('status',1)->avg('score');
User::max('score');
User::where('status','>',0)->count();
User::where('status',1)->avg('score');
User::max('score');
动态调用:
$user = new User;
$user->count();
$user->where('status','>',0)->count();
$user->where('status',1)->avg('score');
$user->max('score');
$user->count();
$user->where('status','>',0)->count();
$user->where('status',1)->avg('score');
$user->max('score');
- 文章导航