/**
* @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;
}
