File "regenerate_bearer_token.php"

Full path: /home/stellafo/public_html/api/regenerate_bearer_token.php
File size: 2.19 B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
error_reporting(0);
session_start();
// regenerate_bearer_token.php
include('../admin/inc/connection.php');
$query_select = "SELECT * FROM `stf_token_tbl` ";
$res_select = mysqli_query($conn,$query_select);
$num_row = mysqli_num_rows($res_select);
$row_select = mysqli_fetch_array($res_select);
echo $refresh_token = $row_select['refresh_token']; // "7V1OAN1S60DE351NDDBO3S6T4EAICFBWB0FV8JFS4NFX3AC2BA5K5TB7CG365BC00BCU7HD9FADQDI7W226H9P9B4V4L0YFS8T2W3ADF6W2VFCDO171J5YCSAE6AET5O";
$client_id = "BMDRUNFS8glVog47uKZqD0ReU8yEb0qJ";
$client_secret = "J6T5pqntmNzUy7HpcnUMSVe419-9WubwlPZUgyr60zJJ3OFvHilGDhO1cxKRwRdg";
//$token_url = "https://signon.sso.services.sage.com/SSO/OAuthService/WebGetAccessToken";
$token_url = "https://id.sage.com/oauth/token";
$authorization = base64_encode("$client_id:$client_secret");
	$header = array("Authorization: Basic {$authorization}","Content-Type: application/x-www-form-urlencoded;charset=UTF-8");
	$content = "grant_type=refresh_token&refresh_token=$refresh_token";

	$curl = curl_init();
	curl_setopt_array($curl, array(
		CURLOPT_URL => $token_url,
		CURLOPT_HTTPHEADER => $header,
		CURLOPT_SSL_VERIFYPEER => false,
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_POST => true,
		CURLOPT_POSTFIELDS => $content
	));
	 $response = curl_exec($curl);
	 curl_close($curl);
	
	if (isset(json_decode($response)->error)){
	echo $response;
	}else{
echo $access_token = json_decode($response)->access_token;

$refresh_token1 = json_decode($response)->refresh_token;

        if($access_token != "" && $refresh_token1 != ""){        
				date_default_timezone_set('Asia/Kolkata'); 
	            $last_update = date('d-m-Y h:i a');
			  
				if($num_row == 0){
				$insert_sage_query = "INSERT INTO `stf_token_tbl`(`token_id`, `access_token`, `refresh_token`, `last_update`) 
				VALUES (NULL,'$access_token','$refresh_token1','$last_update')";
				$res = mysqli_query($conn,$insert_sage_query);
				}else{
				$insert_sage_query = "UPDATE `stf_token_tbl` SET `access_token`='$access_token',`refresh_token`='$refresh_token1',`last_update`='$last_update' WHERE token_id = 1";
				$res = mysqli_query($conn,$insert_sage_query);
				}
				
	  }
	
	}
?>