Implementing Google login system in your website is very easy with OAuth2 support, a simple and standard authorization method. With minimal line of PHP codes, we can acquire required user information from Google, and use the information to register or login users on click of a button. In this article let us learn to easily register/login users using Google PHP API library and MySQL.
This tutorial requires only one PHP page, all task are performed within the page with support of Google APIs Client Library for PHP. These library files are included in downloadable file at the bottom of this page, also look at their sample code, because this tutorial is based on it.
Database Table
Run SQL query below to create a new MySQL table called “google_users” using phpMyAdmin. There are five columns in the database table for the tutorial, and you will find that the length of Google profile IDs are too long (21 characters), it is not possible to accommodate these IDs into INT or BIGINT field, hence I have used DECIMAL(21,0), but you can also store them as string in VARCHAR field and create a separate auto increment primary field.
CREATE TABLE IF NOT EXISTS `google_users` (
`google_id` decimal(21,0) NOT NULL,
`google_name` varchar(60) NOT NULL,
`google_email` varchar(60) NOT NULL,
`google_link` varchar(60) NOT NULL,
`google_picture_link` varchar(60) NOT NULL,
PRIMARY KEY (`google_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; Continue reading