How to realize OAuth authentication and storage

This article introduces the "how to achieve OAuth authentication and storage" related knowledge, in the actual case of the operation process, many people will encounter such a dilemma, then let the editor lead you to learn how to deal with these situations! I hope you can read it carefully and be able to achieve something!

Here is a basic example of Mysql:

CREATE TABLE `oauth_ users` (`id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT, `oauth_ provider` VARCHAR (10), `oauth_ uid` text, `oauth_ token` text, `oauth_ secret`username` text, PRIMARY KEY (`id`) ENGINE=MyISAM DEFAULT CHARSET=utf8

Notice the oauth_token and oauth_secret fields. Sina's OAuth authentication requires two parameters, token and token_secret, to complete the authentication, so we need to reserve two fields to record them.

Then we need to complete the following tasks in turn:

Initiate authentication to SinaAPI to apply for registration / or login, and save the relevant data in Session if the user already has an account.

The OAuth-based authentication process begins with the generation of a URL. The user is redirected to the URL to require authentication. After the authentication is passed, the user will be redirected to our application server, and the two authenticated parameters will be sent back through URL.

Establish index.php