4.4.2 查询

4.4.2 查询

find()：根据主键查询

<?php
namespace App\Controller;

class IndexController extends AbstractController
{
    public function index()
    {
        return [
            // 查询单条数据
            'find_one' => \App\Model\UserActivity::query()->find(10012),
            // 查询多条数据
            'find_many' => \App\Model\UserActivity::query()->find([10012, 10013]),
        ];
    }
}

get(): 根据条件查询

<?php
namespace App\Controller;


class IndexController extends AbstractController
{
    public function index()
    {
        // 查询出status = 2的所有数据
        return \App\Model\UserActivity::query()->where('status', 2)->get()->toArray();
    }
}

paginate()：分页获取

<?php
namespace App\Controller;

class IndexController extends AbstractController
{
    public function index()
    {
        // 获取分页的结果信息
        $paginate = \App\Model\UserActivity::query()->paginate(5);
        return [
            'total_count' => $paginate->total(), // 数据的总数量
            'list' => $paginate->items() // 当前页的结果集
        ];
    }
}