Google OpenID authentication in PHP

This post explains you about how to implement Google OpenID authentication in PHP.

In this post we are using  Openid API for google authentication. After download this script change database connectivity in inc/dbConnect.inc.php file and change $callback_website_url variable in login_process.php file.

Download Link   Demo Link

Sample database design for table name contact.

This table contains  id (primary key),tutorial and link.

CREATE TABLE IF NOT EXISTS `google_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `inserted_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
)

$mysql_db_hostname = "Host name";
$mysql_db_user = "UserName";
$mysql_db_password = "Password";
$mysql_db_database = "Database Name";

$con = mysql_connect($mysql_db_hostname, $mysql_db_user,
       $mysql_db_password or die("Could not connect database");
//Create a new connection
mysql_select_db($mysql_db_database, $con) or
                 die("Could not select database");
// select database

index.php

 if (isset($_SESSION['UNAME']) && !(empty($_SESSION['UNAME']))){
    echo '<a href="logout.php"><b><u>Logout</u></b></a><br/><br/>';
    echo "Name:-".$_SESSION['UNAME']."<br/><br/>";
    echo "Email:-".$_SESSION['UEMAIL'];
    // After Successful Authentication
 }else{
    echo '<a href="login_process.php">Login With Gmail</a>';
    // login page link
 }

login_process.php

Contains the login part and include openid api file.

include('inc/lightopenid.php');
$callback_website_url='http://www.91weblessons.com/demo/GoogleOpenIDAuthenticationInPHP/google_landing.php';
// After Authentication, google will redirect page to $callback_website_url

googleAuthenticate($callback_website_url);

function googleAuthenticate($callback_website_url) {
   $openid = new lightopenid;
   $openid->identity = 'https://www.google.com/accounts/o8/id';
   $openid->returnUrl = $callback_website_url;
   $endpoint = $openid->discover('https://www.google.com/accounts/o8/id');

   $fields ='?openid.ns=' . urlencode('http://specs.openid.net/auth/2.0') .
             '&openid.return_to=' . urlencode($openid->returnUrl) .
             '&openid.claimed_id=' . urlencode('http://specs.openid.net/auth/2.0/identifier_select') .
             '&openid.identity=' . urlencode('http://specs.openid.net/auth/2.0/identifier_select') .
             '&openid.mode=' . urlencode('checkid_setup') .
             '&openid.ns.ax=' . urlencode('http://openid.net/srv/ax/1.0') .
             '&openid.ax.mode=' . urlencode('fetch_request') .
             '&openid.ax.required=' . urlencode('email,firstname,lastname') .
             '&openid.ax.type.firstname=' . urlencode('http://axschema.org/namePerson/first') .
             '&openid.ax.type.lastname=' . urlencode('http://axschema.org/namePerson/last') .
             '&openid.ax.type.email=' . urlencode('http://axschema.org/contact/email');

   header('location:'.$endpoint . $fields);
   // Redirect to google site
}

 google_landing.php

After Authentication, google will redirect page

session_start();
include('inc/dbConnect.inc.php');
if (!empty($_GET['openid_ext1_value_firstname']) && !empty($_GET['openid_ext1_value_lastname']) && !empty($_GET['openid_ext1_value_email'])) {
  $username = $_GET['openid_ext1_value_firstname'] . $_GET['openid_ext1_value_lastname'];
  $email = $_GET['openid_ext1_value_email'];

  $uname=$_GET['openid_ext1_value_firstname'].' '.$_GET['openid_ext1_value_lastname'];
  $email=$_GET['openid_ext1_value_email'];

  $checkUserSql="select * from google_login where email= '$email'";
  $checkUserRes=mysql_query($checkUserSql);
  $checkUserCount=mysql_num_rows($checkUserRes);
  // Check email id checking in database

  if($checkUserCount == 0){
    $sql="insert into google_login(name,email,inserted_on)
          values('$uname','$email',now())";
    mysql_query($sql);
    // If user email id not present in database than add it
  }

  $_SESSION['UNAME']=$_GET['openid_ext1_value_firstname'].' '.$_GET['openid_ext1_value_lastname'];
  $_SESSION['UEMAIL']=$_GET['openid_ext1_value_email'];
}

header('location:index.php');