public function get_activity_user() { $sql1 = "set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"; $sql2 = "SELECT `phone`,`create_time`,`name` FROM `fast_account` GROUP BY `phone` order by create_time DESC LIMIT 30"; $this->db->query("$sql1"); $query =$this->db->query("$sql2"); $info =$query->result_array(); foreach($info as $k => $v) { $info[$k]['phone'] = substr_replace($v['phone'],"****",3,4); $info[$k]['name'] = mb_substr($v['name'], 0, 1, 'utf-8').str_repeat('*', mb_strlen($v['name'], 'utf-8') - 1); $info[$k]['create_time'] = date('Y-m-d',$v['create_time']); } return $info; }
获取用户信息数组 ,姓名和手机号部分加符号替换
最新推荐文章于 2023-03-16 18:50:05 发布