/** * @descrpition 检测微信ACCESS_TOKEN是否过期 * -10是预留的网络延迟时间 * @return bool */ private static function _checkJsapiTicket() { //获取access_token。是上面的获取方法获取到后存起来的。 $db = new mysql(); $db->connect(DBHOST, DBUSER, DBPASSWORD, DBNAME); $tempJsapiTicket = $db->fetch_first("select * from jsapiticket"); $JsapiTicket['value'] = $tempJsapiTicket['ticket']; if (!empty($JsapiTicket['value'])) { $JsapiTicket = json_decode($JsapiTicket['value'], true); if (time() - $JsapiTicket['time'] < $JsapiTicket['expires_in'] - 20) { return $JsapiTicket; } } return false; }
/** * @descrpition 检测微信ACCESS_TOKEN是否过期 * -10是预留的网络延迟时间 * @return bool */ private static function _checkAccessToken() { //获取access_token。是上面的获取方法获取到后存起来的。 $db = new mysql(); $db->connect(DBHOST, DBUSER, DBPASSWORD, DBNAME); $tempaccessToken = $db->fetch_first("select * from accesstoken"); $accessToken['value'] = $tempaccessToken['access_token']; if (!empty($accessToken['value'])) { $accessToken = json_decode($accessToken['value'], true); if (time() - $accessToken['time'] < $accessToken['expires_in'] - 10) { return $accessToken; } } return false; }
/** * 检查用户是否已经在数据库存在 * @param $openid 用户openid * @return id:已存在, false,不存在 */ public static function isUserExists($openid) { $db = new mysql(); $db->connect(DBHOST, DBUSER, DBPASSWORD, DBNAME); $sql = "select id from users where openid='" . $openid . "'"; $result = $db->fetch_first($sql); if (!empty($result) && $result != false) { return $result['id']; } return false; }