php多条件查询

 

$sql="select *from think_kaoqin WHERE(1=1)";      if(!empty($uid))            {                $sql .=" and uid= ".$uid;            }             if(!empty($time1) && empty($time2))            {                                   $sql .=" and riqi >= '".$time1."'";            }            if (!empty($time2) &&empty($time1)) {                           $sql .=" and riqi <= '".$time2."'";            }           if (!empty($time1) && !empty($time2)) {                $sql .=" and riqi >= '".$time1."' and riqi <='".$time2."'";            }  $this->info=M('kaoqin')->query($sql);