• 單個(gè)Where條件

    public function seach()
    {
        $name = input('name');
        $pageIndex = input('pageIndex', 1 , 'int');
        $pageSize = input('pageSize', 10 , 'int');

        $total = Db::table('papers')->where($where)->count('id');

        $list = Db::name('papers')->where('name','like','%'.$name.'%')->page($pageIndex, $pageSize)->select();

        $isNext = ($total / $pageSize - $pageIndex) <= 0 ? false : true;
        $isPrev = $pageIndex != 1 ? true : false;

        return json([
            'total' => $total,
            'pageIndex' => intval($pageIndex),
            'pageSize' => intval($pageSize),
            'isPrev' => $isPrev,
            'isNext' => $isNext,
            'data' => $list,
        ]);
    }

• 多個(gè)Where條件

    public function seach()
    {
        $name = input('name');
        $platform = input('platform');//平臺(tái)
        $status = input('status');//開通狀態(tài)
        $effect = input('effect');//生效時(shí)間
        $pageIndex = input('pageIndex', 1,'int');
        $pageSize = input('pageSize', 2,'int');

        //多條件查詢
        $where = [
            ['name','like','%'.$name.'%'],
            ['platform','like','%'.$platform.'%'],
            ['status','like','%'.$status.'%'],
            ['effect','like','%'.$effect.'%'],
        ];

        $list = Db::table('seach')->where($where)->page($pageIndex, $pageSize)->select()

        $total = Db::table('seach')->where($where)->count('id');
       
        $isNext = ($total / $pageSize - $pageIndex) <= 0 ? false : true;
        $isPrev = $pageIndex != 1 ? true : false;

        return json([
            'total' => $total,
            'pageIndex' => intval($pageIndex),
            'pageSize' => intval($pageSize),
            'isPrev' => $isPrev,
            'isNext' => $isNext,
            'data' => $list,
        ]);
    }

• Where條件查詢，模糊查詢，時(shí)間區(qū)間查詢（今天發(fā)現(xiàn)mysql 模糊查詢 無(wú)法查詢到null的值，所以需要加個(gè)條件判斷）

    public function index()
    {
        $pageIndex = input('pageIndex', 1, 'int');
        $pageSize = input('pageSize', 10, 'int');

        $name = input('username');
        $phone = input('phone');
        $timesend = input('time_send', '');
        $timeend = input('time_end', '');
        $$call_start_time= input('call_start_time', '');
        $$call_end_time= input('call_end_time', '');

        $where = [];
        if (!empty($name)) $where[] = ['username', 'like', '%' . $name . '%'];
        if (!empty($phone)) $where[] = ['phone', 'like', '%' . $phone . '%'];
        if (!empty($timesend) && !empty($timeend)) {
            //時(shí)間區(qū)間查詢 :2021-01-01 22:12:11 - 2021-09-11 22:26:31
//            list($begin, $after) = explode(' - ', $timesend);
            $where[] = ['create_time', 'between', [$timesend, $timeend]];
        }

        if (!empty($call_start_time) && !empty($call_end_time)){
            $where = [
                ['call_start_time', '>=', $call_start_time],
                ['call_end_time', '<=', $call_end_time]
            ];
        }
        //查詢數(shù)據(jù)
        $list = Db::table('user')->where($where)->page($pageIndex, $pageSize)->select();
        //統(tǒng)計(jì)數(shù)據(jù)
        $total = Db::table('user')->where($where)->count('id');

        $isNext = ($total / $pageSize - $pageIndex) <= 0 ? false : true;//下一頁(yè)
        $isPrev = $pageIndex != 1 ? true : false;//上一頁(yè)

        return json([
            'total' => $total,
            'pageIndex' => intval($pageIndex),
            'pageSize' => intval($pageSize),
            'isPrev' => $isPrev,
            'isNext' => $isNext,
            'data' => $list,
        ]);
    }

    public function limtPage()
    {
        $page = input('page', 1, 'int');
        $pageSize = input('$pageSize', 10, 'int');
        $offset = ($page - 1) * $pageSize;//計(jì)算起始位置
        $total = Db::name()->count();//總頁(yè)數(shù)
        $res = Db::name()->limit($offset, $pageSize)->select();//分頁(yè)數(shù)據(jù)
    }