/**     * 获取激活码     */    public function getnum()    {        $time = Db::name('fangchan_jihuoma')->group('id desc')->limit(1)->find();//从上一次生成的时间开始计算        $num='';        if(empty($time)){            $num = microtime(true);        }else{            $num = $time['info_time'];        }        for ($i = $num; $i < ($num + 5); $i++) {//            dump(substr(md5($i), 0, 6));exit;            Db::name("fangchan_jihuoma")->insert([                'num' => substr(md5($i), 0, 6),                'status' => '',                'created_time' => time(),                'info_time' => $i            ]);        }        $sql = "select count(*) as sum,num from osc_fangchan_jihuoma group by num HAVING sum>1";//查出有多少个重复的验证码和重复验证码内容        $data = Db::query($sql);        if(!empty($data)) {            foreach($data as $k=> $v) {                for($j=0;$j<$v['sum'];$j++){                    Db::name("fangchan_jihuoma")->where('num',1)->where('status',0)->delete();删除重复的验证码                }            }        }        $this->success('激活码已生成！');    }

 

CREATE TABLE `osc_fangchan_jihuoma` (  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长id',  `num` varchar(8) NOT NULL COMMENT '激活码',  `uid` int(10) unsigned zerofill DEFAULT NULL COMMENT 'member表id',  `status` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0' COMMENT '是否核销 0：未核销，1：已核销',  `created_time` int(11) NOT NULL DEFAULT '0' COMMENT '激活码创建时间',  `info_time` int(11) NOT NULL DEFAULT '0' COMMENT '标记用时间',  PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4;