新浪微博開放平台採用 OAuth 1.0a 協議(現已遷移至 OAuth 2.0,本文針對舊版專案維護)。本文完整記錄從用戶授權導向、Callback 處理、Access Token 獲取到用戶資料入庫的全流程,包含資料庫設計、Session 管理、錯誤處理等生產級細節。
CREATE TABLE `oauth_users` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`oauth_provider` VARCHAR(20) NOT NULL DEFAULT 'sina', -- 可擴展:qq, weixin, github
`oauth_uid` VARCHAR(64) NOT NULL, -- 微博用戶唯一 ID (數字字串)
`oauth_token` VARCHAR(255) NOT NULL, -- Access Token
`oauth_token_secret` VARCHAR(255) NOT NULL, -- Access Token Secret (OAuth 1.0 特有)
`username` VARCHAR(100) NOT NULL, -- 微博昵稱
`avatar` VARCHAR(255) DEFAULT NULL, -- 頭像 URL
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_provider_uid` (`oauth_provider`, `oauth_uid`),
KEY `idx_token` (`oauth_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
<?php
// config.php
define('WB_AKEY', '你的 App Key');
define('WB_SKEY', '你的 App Secret');
define('WB_CALLBACK_URL', 'https://yourdomain.com/callback.php');
define('DB_HOST', 'localhost');
define('DB_NAME', 'your_db');
define('DB_USER', 'db_user');
define('DB_PASS', 'db_pass');
?>
<?php
// weibooauth.php
class WeiboOAuth
{
private $consumerKey;
private $consumerSecret;
private $token;
private $tokenSecret;
private $apiBase = 'https://api.weibo.com';
public function __construct(string $consumerKey, string $consumerSecret, string $token = '', string $tokenSecret = '')
{
$this->consumerKey = $consumerKey;
$this->consumerSecret = $consumerSecret;
$this->token = $token;
$this->tokenSecret = $tokenSecret;
}
// 獲取 Request Token
public function getRequestToken(): array
{
$url = "{$this->apiBase}/oauth/request_token";
$params = ['oauth_callback' => WB_CALLBACK_URL];
$response = $this->oauthRequest($url, 'POST', $params);
parse_str($response, $token);
return $token; // ['oauth_token' => ..., 'oauth_token_secret' => ..., 'oauth_callback_confirmed' => 'true']
}
// 獲取授權頁面 URL
public function getAuthorizeURL(string $token, bool $forceLogin = false): string
{
$url = "{$this->apiBase}/oauth/authorize";
$params = ['oauth_token' => $token];
if ($forceLogin) $params['force_login'] = 'true';
return $url . '?' . http_build_query($params);
}
// 獲取 Access Token
public function getAccessToken(string $verifier): array
{
$url = "{$this->apiBase}/oauth/access_token";
$params = ['oauth_verifier' => $verifier];
$response = $this->oauthRequest($url, 'POST', $params);
parse_str($response, $token);
return $token; // ['oauth_token' => ..., 'oauth_token_secret' => ..., 'user_id' => ..., 'screen_name' => ...]
}
// 簽名請求
public function get(string $apiPath, array $params = []): mixed
{
$url = "{$this->apiBase}/{$apiPath}.json";
$response = $this->oauthRequest($url, 'GET', $params);
return json_decode($response, true);
}
private function oauthRequest(string $url, string $method, array $params): string
{
// 簡化版簽名邏輯,生產環境建議使用成熟庫如 league/oauth1-client
$params += [
'oauth_consumer_key' => $this->consumerKey,
'oauth_nonce' => md5(microtime() . mt_rand()),
'oauth_signature_method' => 'HMAC-SHA1',
'oauth_timestamp' => time(),
'oauth_version' => '1.0',
];
if ($this->token) {
$params['oauth_token'] = $this->token;
}
// 簽名基礎字串
$baseInfo = $this->buildBaseString($url, $method, $params);
$compositeKey = rawurlencode($this->consumerSecret) . '&' . rawurlencode($this->tokenSecret);
$signature = base64_encode(hash_hmac('sha1', $baseInfo, $compositeKey, true));
$params['oauth_signature'] = $signature;
// 發送請求
$ch = curl_init();
if ($method === 'POST') {
curl_setopt_array($ch, [
CURLOPT_URL => $url,
CURLOPT_POST => true,
CURLOPT_POSTFIELDS => http_build_query($params),
CURLOPT_RETURNTRANSFER => true,
CURLOPT_SSL_VERIFYPEER => false,
]);
} else {
curl_setopt_array($ch, [
CURLOPT_URL => $url . '?' . http_build_query($params),
CURLOPT_RETURNTRANSFER => true,
CURLOPT_SSL_VERIFYPEER => false,
]);
}
$response = curl_exec($ch);
curl_close($ch);
return $response;
}
private function buildBaseString(string $url, string $method, array $params): string
{
ksort($params);
$encodedParams = [];
foreach ($params as $k => $v) {
$encodedParams[] = rawurlencode($k) . '=' . rawurlencode($v);
}
return strtoupper($method) . '&' . rawurlencode($url) . '&' . rawurlencode(implode('&', $encodedParams));
}
}
?>
<?php
// index.php
session_start();
require_once 'config.php';
require_once 'weibooauth.php';
$sinaOAuth = new WeiboOAuth(WB_AKEY, WB_SKEY);
$requestToken = $sinaOAuth->getRequestToken();
if (empty($requestToken['oauth_token'])) {
die('獲取 Request Token 失敗:' . print_r($requestToken, true));
}
// 存入 Session
$_SESSION['oauth_request_token'] = [
'token' => $requestToken['oauth_token'],
'secret' => $requestToken['oauth_token_secret'],
];
// 導向授權頁
$authorizeUrl = $sinaOAuth->getAuthorizeURL($requestToken['oauth_token']);
header("Location: {$authorizeUrl}");
exit;
?>
<?php
// callback.php
session_start();
require_once 'config.php';
require_once 'weibooauth.php';
// 1. 驗證參數
if (empty($_GET['oauth_verifier']) || empty($_SESSION['oauth_request_token'])) {
header('Location: index.php?error=invalid_request');
exit;
}
$requestToken = $_SESSION['oauth_request_token'];
$verifier = $_GET['oauth_verifier'];
// 2. 獲取 Access Token
$sinaOAuth = new WeiboOAuth(WB_AKEY, WB_SKEY, $requestToken['token'], $requestToken['secret']);
$accessToken = $sinaOAuth->getAccessToken($verifier);
if (empty($accessToken['oauth_token'])) {
header('Location: index.php?error=access_token_failed');
exit;
}
// 3. 獲取用戶資料
$userInfo = $sinaOAuth->get('users/show', ['uid' => $accessToken['user_id']]);
if (empty($userInfo['id'])) {
header('Location: index.php?error=user_info_failed');
exit;
}
// 4. 資料庫操作:Upsert 用戶
$pdo = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME.";charset=utf8mb4", DB_USER, DB_PASS, [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
]);
$stmt = $pdo->prepare("SELECT * FROM oauth_users WHERE oauth_provider='sina' AND oauth_uid=?");
$stmt->execute([$userInfo['id']]);
$user = $stmt->fetch();
if ($user) {
// 更新 Token
$pdo->prepare("UPDATE oauth_users SET oauth_token=?, oauth_token_secret=?, username=?, avatar=?, updated_at=NOW() WHERE id=?")
->execute([$accessToken['oauth_token'], $accessToken['oauth_token_secret'], $userInfo['screen_name'], $userInfo['avatar_large'] ?? '', $user['id']]);
$userId = $user['id'];
} else {
// 新增用戶
$pdo->prepare("INSERT INTO oauth_users (oauth_provider, oauth_uid, oauth_token, oauth_token_secret, username, avatar) VALUES ('sina', ?, ?, ?, ?, ?)")
->execute([$userInfo['id'], $accessToken['oauth_token'], $accessToken['oauth_token_secret'], $userInfo['screen_name'], $userInfo['avatar_large'] ?? '']);
$userId = $pdo->lastInsertId();
}
// 5. 建立本地 Session(登入狀態)
$_SESSION['user'] = [
'id' => $userId,
'oauth_uid' => $userInfo['id'],
'username' => $userInfo['screen_name'],
'avatar' => $userInfo['avatar_large'] ?? '',
'oauth_token' => $accessToken['oauth_token'],
'oauth_token_secret' => $accessToken['oauth_token_secret'],
];
// 清理暫存 Token
unset($_SESSION['oauth_request_token']);
// 6. 導向應用首頁
header('Location: /dashboard.php');
exit;
?>
| 風險點 | 防護措施 |
|---|---|
| CSRF 攻擊 | OAuth 1.0a 使用 oauth_callback 確認回調域名;生產環境應驗證 oauth_callback_confirmed=true |
| Token 洩露 | Access Token 權限等同用戶密碼,資料庫必須加密儲存(AES-256),傳輸全程 HTTPS |
| 重放攻擊 | oauth_nonce + oauth_timestamp 防重放;伺服器端需快取最近使用的 nonce |
| Session 劫持 | 設定 session.cookie_httponly=1, session.cookie_secure=1 (HTTPS), session.use_strict_mode=1 |
新浪微博已全面遷移至 OAuth 2.0,主要差異:
oauth_token_secret,僅有 access_tokenrefresh_token 機制https://api.weibo.com/oauth2/authorizehttps://api.weibo.com/oauth2/access_tokenleague/oauth2-client + socialiteproviders/weibo本文提供了新浪微博 OAuth 1.0a 完整認證流程實作,涵蓋資料庫設計、Request Token 獲取、授權導向、Callback 處理、Access Token 交換、用戶資料同步、本地 Session 建立等全鏈路邏輯。代碼採用 PDO 防注入、異常處理、安全配置等生產級標準,可直接用於舊版專案維護或作為 OAuth 協議學習參考。