防止access_token失效法二（存表）_accesstoken 表-优快云博客

本文链接：https://blog.youkuaiyun.com/stand_forever/article/details/84662604

本文介绍了一种基于钉钉API的访问令牌管理方案，通过创建token表存储令牌及其添加时间，实现对过期令牌的自动刷新。文章详细展示了如何使用PHP与钉钉官方API交互获取新的访问令牌，并在令牌过期时更新数据库中的记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

新建表token，过了有效期的话更新一次数据即可

`id` int(10) NOT NULL AUTO_INCREMENT,

`token` varchar(100) DEFAULT NULL,

`addtime` varchar(255) DEFAULT NULL,

public function getToken(Request $request)
{
    $data = DB::table('token')->first();
    if ($data && (time() - $data->addtime) > 7200) {
        $c = new \DingTalkClient(\DingTalkConstant::$CALL_TYPE_OAPI, \DingTalkConstant::$METHOD_GET, \DingTalkConstant::$FORMAT_JSON);
        $req = new \OapiGettokenRequest();
        $corpid = $this->corpid;
        $corpSecret = $this->corpSecret;
        $req->setCorpid($corpid);
        $req->setCorpsecret($corpSecret);
        $resp = $c->execute($req, '', "https://oapi.dingtalk.com/gettoken");
        $token = $resp->access_token;
        $res = DB::table('token')->where('id',$data->id)->update(['token' => $token, 'addtime' => time()]);
    }elseif(!$data){
        $c = new \DingTalkClient(\DingTalkConstant::$CALL_TYPE_OAPI, \DingTalkConstant::$METHOD_GET, \DingTalkConstant::$FORMAT_JSON);
        $req = new \OapiGettokenRequest();
        $corpid =  $this->corpid ;
        $corpSecret = $this->corpSecret;
        $req->setCorpid($corpid);
        $req->setCorpsecret($corpSecret);
        $resp = $c->execute($req, '', "https://oapi.dingtalk.com/gettoken");
        $token = $resp->access_token;
        $res = DB::table('token')->insert(['token' => $token, 'addtime' => time()]);
    }else{
        $token = $data->token;
    }
    return $token;
}