时间段搜索

最新推荐文章于 2024-06-06 00:23:04 发布

weixin_33734785

最新推荐文章于 2024-06-06 00:23:04 发布

阅读量207

点赞数

原文链接：http://www.cnblogs.com/wangfenphph2/p/10019959.html

版权

first:
        $time_start = I('time_start') ? date("Y-m-d 00:00:00", strtotime(I('time_start'))) : null;
        $time_end   = I('time_end')   ? date("Y-m-d 23:59:59", strtotime(I('time_end'))) : null;
        I('time_start') ? $where['time'] = ['egt', $time_start] : null;
        I('time_end')   ? $where['time'] = ['elt', $time_end] : null;
        I('time_start') && I('time_end') ? $where['time'] =['between', [$time_start, $time_end]] : null;

second:
        $time_start = trim($this->request->get('time_start')) ? strtotime(trim($this->request->get('time_start'))) : null;
        $time_end = trim($this->request->get('time_end')) ? strtotime(trim($this->request->get('time_end'))) : null;
        //日期搜索
        $time_start ? $where['f_user_entry'] = ['egt', $time_start] : null;
        $time_end ? $where['f_user_entry'] =['elt', $time_end] : null;
        $time_start && $time_end ? $where['f_user_entry'] = ['between', [$time_start, $time_end]] : null;
        //分页
        $p = $this->request->get('p');
        (empty($p) || !is_numeric($p)) && $p = 1;
        $limit = $this->request->get('limit');
        (empty($limit) || !is_numeric($limit)) && $limit = 15;

转载于:https://www.cnblogs.com/wangfenphph2/p/10019959.html