douqiao6563 2014-04-12 17:54
浏览 188

从Google OAuth PHP API获取用户信息

I would like to get user information like name, family name, email address, image and etc.

After login to the website by Google account, I've used the following PHP code:

<?php

########## Google Settings.. Client ID, Client Secret #############
// I fill these fieds with my keys
$google_client_id       = '............';
$google_client_secret   = '...............';
$google_redirect_url    = '.......................';
$google_developer_key   = '............';

########## MySql details (Replace with yours) #############
// I filled these fields with my data
$db_username = "*******"; //Database Username
$db_password = "*******"; //Database Password
$hostname = "*******"; //Mysql Hostname
$db_name = '**********'; //Database Name
###################################################################

//include google api files
require_once 'src/Google_Client.php';
require_once 'src/contrib/Google_Oauth2Service.php';

//start session
session_start();

$gClient = new Google_Client();
$gClient->setApplicationName('Login to techsa.ir');
$gClient->setClientId($google_client_id);
$gClient->setClientSecret($google_client_secret);
$gClient->setRedirectUri($google_redirect_url);
$gClient->setDeveloperKey($google_developer_key);

$google_oauthV2 = new Google_Oauth2Service($gClient);

//If user wish to log out, we just unset Session variable
if (isset($_REQUEST['reset'])) 
{
  unset($_SESSION['token']);
  $gClient->revokeToken();
  header('Location: ' . filter_var($google_redirect_url, FILTER_SANITIZE_URL));
}


if (isset($_GET['code'])) 
{ 
    $gClient->authenticate($_GET['code']);
    $_SESSION['token'] = $gClient->getAccessToken();
    header('Location: ' . filter_var($google_redirect_url, FILTER_SANITIZE_URL));
    return;
}


if (isset($_SESSION['token'])) 
{ 
        $gClient->setAccessToken($_SESSION['token']);
}


if ($gClient->getAccessToken()) 
{
      //Get user details if user is logged in
      $user                 = $google_oauthV2->userinfo->get();
      $user_id              = $user['id'];
      $user_name            = filter_var($user['name'], FILTER_SANITIZE_SPECIAL_CHARS);
      $email                = filter_var($user['email'], FILTER_SANITIZE_EMAIL);
      $profile_url          = filter_var($user['link'], FILTER_VALIDATE_URL);
      $profile_image_url    = filter_var($user['picture'], FILTER_VALIDATE_URL);
      $personMarkup         = "$email<div><img src='$profile_image_url?sz=50'></div>";
      $_SESSION['token']    = $gClient->getAccessToken();
}
else 
{
    //get google login url
    $authUrl = $gClient->createAuthUrl();
}

//HTML page start
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />';
echo '<title>Login with Google</title>';
echo '</head>';
echo '<body>';
echo '<h1>Login with Google</h1>';

if(isset($authUrl)) //user is not logged in, show login button
{
    echo '<a class="login" href="'.$authUrl.'"><img src="images/google-login-button.png" /></a>';
} 
else // user logged in 
{
   /* connect to mysql */
    $connecDB = mysql_connect($hostname, $db_username, $db_password)or die("Unable to connect to MySQL");
    mysql_select_db($db_name,$connecDB);

    //compare user id in our database
    $result = mysql_query("SELECT COUNT(g_id) FROM social_users WHERE g_id=$user_id");
    if($result === false) { 
        die(mysql_error()); //result is false show db error and exit.
    }

    $UserCount = mysql_fetch_array($result);

    if($UserCount[0]) //user id exist in database
    {
        echo 'Welcome back '.$user_name.'!';
    }else{ //user is new
        echo 'Hello! '.$user_name.', Thanks for Registering!';
        @mysql_query("INSERT INTO social_users (g_id, g_name, g_email, g_link, g_image, created_date) VALUES ($user_id, '$user_name','$email','$profile_url','$profile_image_url', now())");
    }


    echo '<br /><a href="'.$profile_url.'" target="_blank"><img src="'.$profile_image_url.'?sz=50" /></a>';
    echo '<br /><a class="logout" href="?reset=1">Logout</a>';

    //list all user details
    echo '<pre>'; 
    print_r($user);
    echo '</pre>';  
}

echo '</body></html>';
?>

I have a table in my database named social_users. The user gives permission, but the table is empty.

  • 写回答

2条回答 默认 最新

  • dongshan8194 2014-10-10 14:56
    关注

    try this:

    if ($result = $mysqli->query("SELECT COUNT(g_id) as usercount FROM social_users WHERE g_id=$user_id")) {
        $usercount = $result->fetch_object()->usercount;
        $result->close();
        if ($usercount > 0) {
            //has such user
        }
    }    
    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题