1.示例图:
代码:
活动时间
2.当设置了start_time以后,end_time肯定要大于start_time,否则要设置为不可选,
当设置了end_time以后,start_time肯定要小于start_time,否则要设置为不可选,
3.具体操作如下:复制以下代码即可
控制器调用例子:
public function keywords_count(){ $condition1 =strtotime(input('start_time')); $condition2 = strtotime(input('end_time')); // var_dump($condition1); $condition = input('condition'); $where=''; if($condition){ // $where['keyword']=$condition; $where['keyword']=array('like','%'.$condition.'%'); } if($condition1&&$condition2) { $where['create_time'] = array(array('egt', $condition1), array('elt', $condition2), 'AND'); } if($where){ $gust = db('keywords')->where($where)->field('id,keyword,create_time,count(*) as count')->group("keyword")->order("count desc")->select(); $gustcount = db('keywords')->where($where)->field('id,keyword,create_time,count(*) as count')->count(); }else{ $gust = db('keywords')->field('id,keyword,create_time,count(*) as count')->group("keyword")->order("count desc")->select(); $gustcount = db('keywords')->field('id,keyword,create_time,count(*) as count')->count(); // $gust = db('keywords')->order('id DESC')->select(); } $this->assign('condition1',$condition1); $this->assign('condition2',$condition2); $this->assign('condition',$condition); $this->assign('gust',$gust); $this->assign('gustcount',$gustcount); return view(); }