如何在PHP中生成访问令牌后获取用户邮件

$accessToken = uniqid();

// 假设已连接到数据库
$accessToken = uniqid();
$userEmail = $_POST['email']; // 假设从表单中获取用户邮件

// 将访问令牌和用户邮件插入到数据库中
$query = "INSERT INTO access_tokens (token, email) VALUES ('$accessToken', '$userEmail')";
$result = mysqli_query($connection, $query);
if ($result) {
    echo "访问令牌生成成功！";
} else {
    echo "访问令牌生成失败！";
}

$accessToken = $_GET['access_token']; // 假设从请求参数中获取访问令牌

// 查询数据库获取用户邮件
$query = "SELECT email FROM access_tokens WHERE token = '$accessToken'";
$result = mysqli_query($connection, $query);
if ($result && mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $userEmail = $row['email'];
    echo "用户邮件：$userEmail";
} else {
    echo "无效的访问令牌！";
}