摘要: //根据时间类型来组装时间条件 if ($time_type == 2){ //周报表 $group = "concat_ws('~',subdate(FROM_UNIXTIME(create_time,'%Y-%m-%d'),date_format(FROM_UNIXTIME(create_tim 阅读全文
posted @ 2021-08-30 14:07 知冷知热 阅读(363) 评论(0) 推荐(0)
摘要: $list = [ ['name'=>'zhang','age'=>23,'sex'=>'男'], ['name'=>'李刚','age'=>31,'sex'=>'男'], ['name'=>'带善人','age'=>56,'sex'=>'男'], ['name'=>'莎宝宝 阅读全文
posted @ 2021-08-30 11:10 知冷知热 阅读(60) 评论(0) 推荐(0)
摘要: //查询 SET @rank = 0; SELECT phone,CONCAT(LEFT (18800000000,11 - char_length(@rank :=@rank + 1)) ,@rank),char_length(@rank + 1) FROM `el_user` ORDER BY 阅读全文
posted @ 2021-08-30 11:08 知冷知热 阅读(412) 评论(0) 推荐(0)
摘要: /* * 解决反序列化时由于字符长度原因导致报错 * unserialize(): Error at offset 126 of 691 bytes */ function common_unserialize($str) { if(empty($str)){ return ''; } $str= 阅读全文
posted @ 2021-08-30 10:59 知冷知热 阅读(201) 评论(0) 推荐(0)