随笔分类 -  TP

判断两个时间段有交集
摘要：$dateMin = I('datemin') ? strtotime(I('datemin')) : ''; $dateMax = I('datemax') ? strtotime(I('datemax')) : ''; if ($dateMin && $dateMax) { $where['b.contract_end'... 阅读全文
posted @ 2018-07-25 15:52 xc_flying 阅读(174) 评论(0) 推荐(0)
TP框架之复合查询
摘要：$where1=array( 'b'=>$keywords, 'c'=>$keywords, '_logic'=>'and' ); $where=array( 'a'=>$keywords, '_complex'=>$where1, '_logic'=>'or' ); M('X')->where($where)->select(); 阅读全文
posted @ 2018-01-26 14:01 xc_flying 阅读(156) 评论(0) 推荐(0)
mysql 时间转换和计算
摘要：select UNIX_TIMESTAMP(FROM_UNIXTIME(add_time-86400,'%Y-%m-%d')) from mht_order WHERE order_id=2591 TP框架中实现自定义查询条件 $where['_string'] = "(f.log_id IS NO 阅读全文
posted @ 2018-01-03 14:24 xc_flying 阅读(145) 评论(0) 推荐(0)