/** * get token from db */ public static function getWxTokenFromDB() { // 因为在wxindex.php里面已经引用过inc.db.php,所以这里是能拿到db的 global $db; $tokenObj = $db->fetch($db->query("SELECT * FROM wx_token where id = 1")); if ($tokenObj) { // 如果不为空 $tokenFromDB = $tokenObj['token']; $updatetime = $tokenObj['updatetime']; $currenttime = DateUtil::getCurrentTime(); /*$days=floor((strtotime($currenttime)-strtotime($updatetime))/86400); $hour=floor((strtotime($currenttime)-strtotime($updatetime))%86400/3600); $minute=floor((strtotime($currenttime)-strtotime($updatetime))%86400/60); $second=floor((strtotime($currenttime)-strtotime($updatetime))%86400%60); $seconds = $days * 24 + $hour * 60 + $minute * 60 + $second;*/ $seconds = DateUtil::getTimeInterval($currenttime, $updatetime); LogUtil::logs("getWxTokenFromDB=====> " . $seconds, getLogFile("/business.log")); if ($seconds >= 6000) { // 如果当前操作时间的间隔已经大于或等于6500秒了 //LogUtil::logs("WxUtil getWxTokenFromDB :已超时,重新获取token", getLogFile('/business.log')); return self::initWxTokenToDB(); } //LogUtil::logs("WxUtil getWxTokenFromDB :未超时,使用数据库token", getLogFile('/business.log')); return $tokenFromDB; } //LogUtil::logs("WxUtil self getWxTokenFromDB :数据库不存在token,初始化token", getLogFile('/business.log')); return self::initWxTokenToDB(); }