ThinkPHP5模型聚合操作

​

<?php 

namespace app\index\controller;

use think\Controller;
use app\index\model\User;

class Index extends Controller
{
    public function index()
    {
        # 查询数据库有多少条记录
        //$res = User::count();

        # 求id大于5的数据有多少条
        // $res = User::where("id", ">", "5")
        //     ->count();

        # 求num的最大值
        //$res = User::max('num');

        # id小于5的num最大值
        // $res = User::where("id", "<", 5)
        //     ->max('num');

        # num相加
        // $res = User::sum('num');

        # id小于4的num相加
        // $res = User::where("id", "<", 4)
        //     ->sum('num');

        # 求平均值
        //$res = User::avg('num');

        # 求id小于14的num平均值
        // $res = User::where("id", "<", 4)
        //     ->avg('num');

        # 求num的最小值
        // $res = User::min('num');

        # 求id大于5的num最小值
        // $res = User::where("id", ">", 5)
        //     ->min('num');
        dump($res);
    }
}

?>

​