Create an account


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Tut] Login with Twitter using OAuth1.0a Protocol via API in PHP

#1
Login with Twitter using OAuth1.0a Protocol via API in PHP

<div style="margin: 5px 5% 10px 5%;"><img src="https://www.sickgaming.net/blog/wp-content/uploads/2020/12/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php.png" width="550" height="279" title="" alt="" /></div><div><p>Last modified on December 27th, 2020.</p>
<p>Almost all Internet giants (in good sense) like Google, Facebook, Twitter and LinkedIn support OAuth login. They provide API with detailed documentation to help developers integrate OAuth authentication.</p>
<p>There are many client libraries available to implement Twitter OAuth login. But we will do with just plain core PHP. Yes, actually it is sufficient, lightweight and better.</p>
<p>Application with the OAuth login feature has many advantages.</p>
<ul>
<li>Simplifies the login process.</li>
<li>Reduces friction by minimising user’s effort with a single click.</li>
<li>Saves developers’ effort from building a custom login.</li>
<li>Assures secure authentication flow.</li>
</ul>
<p>We have already seen <a href="https://phppot.com/php/facebook-open-authentication-in-php/">how to integrate Facebook OAuth login</a> into an application. Let us see how to Login with Twitter using OAuth authentication.</p>
<p>In its community API gallery, Twitter lists many PHP libraries. These libraries contain handlers to read-write API data in a secure manner. An authentication step ensures access security on each API request.</p>
<p>Twitter uses various authentication methods. Those are, OAuth 1.0a, OAuth 2.0 Bearer token, Basic authentication. I used <a href="https://developer.twitter.com/en/docs/authentication/oauth-1-0a">OAuth 1.0a authentication</a> to validate <strong>login with Twitter</strong> API requests.</p>
<p>During the login flow, Twitter prompts to enter user credentials to login. Then, it will ask to authorize the App for the first time.</p>
<p>“Login with Twitter” flow is very similar to the 3-legged OAuth flow used to get the access token. With the reference of this token, API will return user data as per the request URL. This example will read user name, photo and more details after successful authentication.</p>
<p>In this article, we will see how to integrate “Login with Twitter” by completing each of the below steps.</p>
<ul>
<li>How to get and configure the API keys.</li>
<li>How to perform the 3-step authentication flow.</li>
<li>Create requests and handle responses during the authentication flow.</li>
<li>Store the authenticated user data into the Database.</li>
</ul>
<h2>What is inside?</h2>
<ol>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#twitter-oauth-login-flow">Twitter OAuth login flow</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#how-to-integrate-twitter-oauth-login">How to integrate Twitter OAuth login?</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#generating-twitter-app-keys">Generating Twitter app keys</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#about-this-example">About this example</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#twitter-oauth-php-service">Twitter OAuth PHP service</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#php-code-to-handle-logged-in-user-data">PHP code to handle logged-in user data</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#database-script">Database script</a></li>
<li><a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#login-with-twitter-php-example-output">Login with Twitter PHP example output</a></li>
</ol>
<h2 id="twitter-oauth-login-flow">Twitter OAuth login flow</h2>
<p>The Twitter login authentication flow includes three steps.</p>
<ol>
<li>Get a <strong>Request token</strong> and a secret-key.</li>
<li>Redirect to Twitter to login and approve access rights to the Twitter app.</li>
<li>Get an <strong>Access token</strong> and the secret-key to access the user account via API.</li>
</ol>
<p>During the OAuth login process, each request has to be signed with an OAuth signature. In this example, it has a service class to prepare signed requests.</p>
<p>The following diagram shows the “Login with Twitter” flow. It indicates the steps, request parameters and API response data.</p>
<p><a href="https://phppot.com/wp-content/uploads/2020/09/twitter-3-step-oauth-login-authentication-diagram.png"><img loading="lazy" class="alignnone size-large wp-image-12239" src="https://phppot.com/wp-content/uploads/2020/09/twitter-3-step-oauth-login-authentication-diagram-550x279.png" alt="Twitter 3-Step OAuth Login Authentication Diagram" width="550" height="279" srcset="https://phppot.com/wp-content/uploads/2020/09/twitter-3-step-oauth-login-authentication-diagram-550x279.png 550w, https://phppot.com/wp-content/uploads/20...00x152.png 300w, https://phppot.com/wp-content/uploads/20...68x390.png 768w, https://phppot.com/wp-content/uploads/20...iagram.png 1200w" sizes="(max-width: 550px) 100vw, 550px"></a></p>
<p>Click to see a larger image.</p>
<h2 id="how-to-integrate-twitter-oauth-login">How to integrate Twitter OAuth login?</h2>
<p>Twitter gives a <em>Login with Twitter</em> or <em>Sign in&nbsp;with Twitter</em> button control to put into an application. It makes users sign in to the application with a couple of clicks.</p>
<p>After obtaining the Twitter API keys and token secret, configure them with the PHP application. The next section will show the config file created for this example.</p>
<p>Then, create the request-response handlers to communicate with the Twitter API. It will proceed step by step process to obtain tokens to process the next request.</p>
<p>Instead of using custom handlers, we can use built-in Twitter client libraries.</p>
<p>With the access_token, API will allow access to hit the endpoints. But, it depends on the App permissions set in the developer console.</p>
<p>On getting the response data from the API, the application login flow comes to end. With this step, it will change the logged-in status of the application users in the UI.</p>
<h2 id="generating-twitter-app-keys">Generating Twitter API keys</h2>
<p>The process of generating Twitter API keys is straight-forward. Once we have seen the steps to get keys for <a href="https://phppot.com/php/php-google-oauth-login/">Google OAuth login integration</a>.</p>
<p>Login to the Twitter developer portal and follow the below steps.</p>
<ol>
<li>Login to Twitter and go to its developer console.</li>
<li>Create a Twitter developer App. (project-specific app or standalone app).</li>
<li>Go to app settings to edit permissions and authentication settings.</li>
<li>Go to the “keys and tokens” tab to copy the consumer key and the secret key.</li>
<li>Save the keys in a secured place and configure them into the application.</li>
</ol>
<p><img loading="lazy" class="alignnone size-large wp-image-12224" src="https://phppot.com/wp-content/uploads/2020/09/twitter-api-keys-550x588.jpg" alt="Twitter API Keys" width="550" height="588" srcset="https://phppot.com/wp-content/uploads/2020/09/twitter-api-keys-550x588.jpg 550w, https://phppot.com/wp-content/uploads/20...81x300.jpg 281w, https://phppot.com/wp-content/uploads/20...68x821.jpg 768w, https://phppot.com/wp-content/uploads/20...i-keys.jpg 800w" sizes="(max-width: 550px) 100vw, 550px"></p>
<p>Twitter allows creating two types of developer App. A project-specific app or a standalone app. The project-specific app can use v2 endpoints. The standalone apps can only access the v1 endpoints.</p>
<p>Twitter API keys will no longer keep the API keys and tokens permanently. This is for security purposes. But it allows regenerating the keys and tokens.</p>
<p>Configure the Twitter App consumer_key and secret_key in Config.php file. This application config defines the application constants. It includes the root path, database config and Twitter consumer and secrete key.</p>
<p class="code-heading">Common/config.php</p>
<pre class="prettyprint lang-php">&lt;?php
namespace Phppot; class Config
{ const WEB_ROOT = "https://yourdomain/twitter-oauth"; // Database Configuration const DB_HOST = "localhost"; const DB_USERNAME = "root"; const DB_PASSWORD = ""; const DB_NAME = "twitter-oauth"; // Twitter API configuration const TW_CONSUMER_KEY = ''; const TW_CONSUMER_SECRET = ''; const TW_CALLBACK_URL = Config::WEB_ROOT . '/signin_with_twitter.php';
}
</pre>
<h2 id="about-this-example">About this example</h2>
<p>There are various ways to implement <strong>Twitter OAuth login</strong> in a PHP application. Generally, people use built-in client-side libraries to implement this. Twitter also recommends one or more PHP libraries in its community API gallery.</p>
<p>This example shows a simple code for “Login with Twitter” integration. It uses <strong>no external libraries</strong> to achieve this.</p>
<p>It has a custom class that prepares the API request and handle responses. It creates OAuth signatures to send valid signed requests to the API.</p>
<p>A landing page will show the “Sign in with Twitter” button to trigger the OAuth login process. On clicking, it invokes the PHP service to proceed with the three steps sign-in flow.</p>
<p>As a result, it gets the Twitter user data on successful authentication. The resultant page will change the logged-in state and display the user data.</p>
<p>If you refuse to approve the app access or login, Twitter will redirect back to the application. This redirect URL is set with the param list of the API request.</p>
<p>This example uses the Database to keep the user details read from the API response. Thus, it records the application’s users logged-in via Twitter OAuth login.</p>
<p><img loading="lazy" class="alignnone size-full wp-image-12234" src="https://phppot.com/wp-content/uploads/2020/09/twitter-oauth-file-structure.jpg" alt="Twitter OAuth File Structure" width="350" height="432" srcset="https://phppot.com/wp-content/uploads/2020/09/twitter-oauth-file-structure.jpg 350w, https://phppot.com/wp-content/uploads/20...43x300.jpg 243w" sizes="(max-width: 350px) 100vw, 350px"></p>
<h2 id="twitter-oauth-php-service">Twitter OAuth PHP service</h2>
<p>This PHP service class request Twitter API for the access key and token. It follows the three steps to obtain the access token.</p>
<p>We have seen such similar steps to get the access token in the <a href="https://phppot.com/php/simple-php-linkedin-oauth-login-integration/">LinkedIn OAuth login example</a> code earlier.</p>
<p>The following three methods perform the three steps.</p>
<p>Step 1: <em>getRequestToken()</em> – sends the <em>oauth_callback</em> with the authentication header. It requests request_token and the secrete key from the Twitter API.</p>
<p>Step 2: <em>getOAuthVerifier()</em> – redirects the user to the Twitter authentication page. It let users sign in and approve the App to access the account. It passes the OAuth request token received in step1 with the URL. After authentication, Twitter will invoke the <em>oauth_callback&nbsp;</em>with the <em>oauth_verifier</em> in the querystring.</p>
<p>Step 3: <em>getAccessToken()</em> – requests the access_token and secrete key from the API. The params are the request_token, request_token_secret, oauth_verifier get from Step 1, 2.</p>
<p>Twitter requires each of the API requests has to be signed. This PHP service class has a function to generate the signature by the use of API request parameters.</p>
<p class="code-heading">lib/TwitterOAuthLogin.php</p>
<pre class="prettyprint lang-php">&lt;?php
namespace Phppot; class TwitterOauthService
{ private $consumerKey; private $consumerSecret; private $signatureMethod = 'HMAC-SHA1'; private $oauthVersion = '1.0'; private $http_status = ""; public function __construct() { require_once __DIR__ . '/../Common/Config.php'; $this-&gt;consumerKey = Config::TW_CONSUMER_KEY; $this-&gt;consumerSecret = Config::TW_CONSUMER_SECRET; } public function getOauthVerifier() { $requestResponse = $this-&gt;getRequestToken(); $authUrl = "https://api.twitter.com/oauth/authenticate"; $redirectUrl = $authUrl . "?oauth_token=" . $requestResponse["request_token"]; return $redirectUrl; } public function getRequestToken() { $url = "https://api.twitter.com/oauth/request_token"; $params = array( 'oauth_callback' =&gt; Config::TW_CALLBACK_URL, "oauth_consumer_key" =&gt; $this-&gt;consumerKey, "oauth_nonce" =&gt; $this-&gt;getToken(42), "oauth_signature_method" =&gt; $this-&gt;signatureMethod, "oauth_timestamp" =&gt; time(), "oauth_version" =&gt; $this-&gt;oauthVersion ); $params['oauth_signature'] = $this-&gt;createSignature('POST', $url, $params); $oauthHeader = $this-&gt;generateOauthHeader($params); $response = $this-&gt;curlHttp('POST', $url, $oauthHeader); $responseVariables = array(); parse_str($response, $responseVariables); $tokenResponse = array(); $tokenResponse["request_token"] = $responseVariables["oauth_token"]; $tokenResponse["request_token_secret"] = $responseVariables["oauth_token_secret"]; session_start(); $_SESSION["oauth_token"] = $tokenResponse["request_token"]; $_SESSION["oauth_token_secret"] = $tokenResponse["request_token_secret"]; session_write_close(); return $tokenResponse; } public function getAccessToken($oauthVerifier, $oauthToken, $oauthTokenSecret) { $url = 'https://api.twitter.com/oauth/access_token'; $oauthPostData = array( 'oauth_verifier' =&gt; $oauthVerifier ); $params = array( "oauth_consumer_key" =&gt; $this-&gt;consumerKey, "oauth_nonce" =&gt; $this-&gt;getToken(42), "oauth_signature_method" =&gt; $this-&gt;signatureMethod, "oauth_timestamp" =&gt; time(), "oauth_token" =&gt; $oauthToken, "oauth_version" =&gt; $this-&gt;oauthVersion ); $params['oauth_signature'] = $this-&gt;createSignature('POST', $url, $params, $oauthTokenSecret); $oauthHeader = $this-&gt;generateOauthHeader($params); $response = $this-&gt;curlHttp('POST', $url, $oauthHeader, $oauthPostData); $fp = fopen("eg.log", "a"); fwrite($fp, "AccessToken: " . $response . "\n"); $responseVariables = array(); parse_str($response, $responseVariables); $tokenResponse = array(); $tokenResponse["access_token"] = $responseVariables["oauth_token"]; $tokenResponse["access_token_secret"] = $responseVariables["oauth_token_secret"]; return $tokenResponse; } public function getUserData($oauthVerifier, $oauthToken, $oauthTokenSecret) { $accessTokenResponse = $this-&gt;getAccessToken($oauthVerifier, $oauthToken, $oauthTokenSecret); $url = 'https://api.twitter.com/1.1/account/verify_credentials.json'; $params = array( "oauth_consumer_key" =&gt; $this-&gt;consumerKey, "oauth_nonce" =&gt; $this-&gt;getToken(42), "oauth_signature_method" =&gt; $this-&gt;signatureMethod, "oauth_timestamp" =&gt; time(), "oauth_token" =&gt; $accessTokenResponse["access_token"], "oauth_version" =&gt; $this-&gt;oauthVersion ); $params['oauth_signature'] = $this-&gt;createSignature('GET', $url, $params, $accessTokenResponse["access_token_secret"]); $oauthHeader = $this-&gt;generateOauthHeader($params); $response = $this-&gt;curlHttp('GET', $url, $oauthHeader); return $response; } public function curlHttp($httpRequestMethod, $url, $oauthHeader, $post_data = null) { $ch = curl_init(); $fp = fopen("eg.log", "a"); fwrite($fp, "Header: " . $oauthHeader . "\n"); $headers = array( "Authorization: OAuth " . $oauthHeader ); $options = [ CURLOPT_HTTPHEADER =&gt; $headers, CURLOPT_HEADER =&gt; false, CURLOPT_URL =&gt; $url, CURLOPT_RETURNTRANSFER =&gt; true, CURLOPT_SSL_VERIFYPEER =&gt; false, ]; if($httpRequestMethod == 'POST') { $options[CURLOPT_POST] = true; } if(!empty($post_data)) { $options[CURLOPT_POSTFIELDS] = $post_data; } curl_setopt_array($ch, $options); $response = curl_exec($ch); $this-&gt;http_status = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); return $response; } public function generateOauthHeader($params) { foreach ($params as $k =&gt; $v) { $oauthParamArray[] = $k . '="' . rawurlencode($v) . '"'; } $oauthHeader = implode(', ', $oauthParamArray); return $oauthHeader; } public function createSignature($httpRequestMethod, $url, $params, $tokenSecret = '') { $strParams = rawurlencode(http_build_query($params)); $baseString = $httpRequestMethod . "&amp;" . rawurlencode($url) . "&amp;" . $strParams; $fp = fopen("eg.log", "a"); fwrite($fp, "Baaaase: " . $baseString . "\n"); $signKey = $this-&gt;generateSignatureKey($tokenSecret); $oauthSignature = base64_encode(hash_hmac('sha1', $baseString, $signKey, true)); return $oauthSignature; } public function generateSignatureKey($tokenSecret) { $signKey = rawurlencode($this-&gt;consumerSecret) . "&amp;"; if (! empty($tokenSecret)) { $signKey = $signKey . rawurlencode($tokenSecret); } return $signKey; } public function getToken($length) { $token = ""; $codeAlphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; $codeAlphabet .= "abcdefghijklmnopqrstuvwxyz"; $codeAlphabet .= "0123456789"; $max = strlen($codeAlphabet) - 1; for ($i = 0; $i &lt; $length; $i ++) { $token .= $codeAlphabet[$this-&gt;cryptoRandSecure(0, $max)]; } return $token; } public function cryptoRandSecure($min, $max) { $range = $max - $min; if ($range &lt; 1) { return $min; // not so random... } $log = ceil(log($range, 2)); $bytes = (int) ($log / 8) + 1; // length in bytes $bits = (int) $log + 1; // length in bits $filter = (int) (1 &lt;&lt; $bits) - 1; // set all lower bits to 1 do { $rnd = hexdec(bin2hex(openssl_random_pseudo_bytes($bytes))); $rnd = $rnd &amp; $filter; // discard irrelevant bits } while ($rnd &gt;= $range); return $min + $rnd; }
}
</pre>
<h3>Initiate login flow with “Sign in with Twitter” control</h3>
<p>The landing page of this example will show a “Sign in with Twitter” button. On clicking this button, it invokes functions to proceed with the 3-step login flow.</p>
<p>The following code shows the&nbsp;<em>index.php</em> file script. It checks if any user logged-in already. If so, it displays the user dashboard. Otherwise, it shows the “Sign in with Twitter” button.</p>
<p>It invokes the <em>TwitterOAuthService</em> to initiate the login flow. This initiation will happen when the user tries to log in.</p>
<p class="code-heading">index.php</p>
<pre class="prettyprint lang-php">&lt;?php
namespace Phppot; if (isset($_GET["action"]) &amp;&amp; $_GET["action"] == "login") { require_once __DIR__ . '/lib/TwitterOauthService.php'; $twitterOauthService = new TwitterOauthService(); $redirectUrl = $twitterOauthService-&gt;getOauthVerifier(); header("Location: " . $redirectUrl); exit();
} session_start();
if ($_SESSION["id"]) { $memberId = $_SESSION["id"];
}
session_write_close(); ?&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Home&lt;/title&gt;
&lt;link rel="stylesheet" href="assets/style.css"&gt;
&lt;/head&gt;
&lt;body&gt; &lt;div class="phppot-container"&gt;
&lt;?php
if (empty($memberId)) { ?&gt; &lt;a href="?action=login"&gt; &lt;img class="twitter-btn" src="sign-in-with-twitter.png"&gt;&lt;/a&gt;
&lt;?php
} else { require_once './lib/Member.php'; $member = new Member(); $userData = $member-&gt;getUserById($memberId); ?&gt;
&lt;div class="welcome-messge-container"&gt; &lt;img src="&lt;?php echo $userData[0]["photo_url"]; ?&gt;" class="profile-photo" /&gt; &lt;div&gt;Welcome &lt;?php echo $userData[0]["screen_name"]; ?&gt;&lt;/div&gt; &lt;/div&gt;
&lt;?php
}
?&gt;
&lt;/div&gt;
&lt;/body&gt;
&lt;/html&gt;
</pre>
<h2 id="php-code-to-handle-logged-in-user-data">PHP code to handle logged-in user data</h2>
<p>After completing the 3-steps, the TwitterOauthService will return the user access token. Then it invokes <em>GET oauth/verify_credentials</em> endpoint to read the user daya.</p>
<p>It will return the logged-in user data as a JSON response. The application callback endpoint receives this data.</p>
<p>Then, the code will save the data into the database and put the logged-in user id into the session. Based on the existence of this user session the landing page will show the user dashboard.</p>
<p>sign-in-with-twitter.php</p>
<pre class="prettyprint lang-php">&lt;?php
namespace Phppot; require_once './lib/TwitterOauthService.php';
$TwitterOauthService = new TwitterOauthService(); session_start();
$oauthTokenSecret = $_SESSION["oauth_token_secret"]; if (! empty($_GET["oauth_verifier"]) &amp;&amp; ! empty($_GET["oauth_token"])) { $userData = $TwitterOauthService-&gt;getUserData($_GET["oauth_verifier"], $_GET["oauth_token"], $oauthTokenSecret); $userData = json_decode($userData, true); if (! empty($userData)) { $oauthId = $userData["id"]; $fullName = $userData["name"]; $screenName = $userData["screen_name"]; $photoUrl = $userData["profile_image_url"]; require_once './lib/Member.php'; $member = new Member(); $isMemberExists = $member-&gt;isExists($oauthId); if (empty($isMemberExists)) { $memberId = $member-&gt;insertMember($oauthId, $fullName, $screenName, $photoUrl); } else { $memberId = $isMemberExists[0]["id"]; } if (! empty($memberId)) { unset($_SESSION["oauth_token"]); unset($_SESSION["oauth_token_secret"]); $_SESSION["id"] = $memberId; header("Location: index.php"); } }
} else { ?&gt;
&lt;HTML&gt;
&lt;head&gt;
&lt;title&gt;Signin with Twitter&lt;/title&gt;
&lt;link rel="stylesheet" href="assets/style.css"&gt;
&lt;/head&gt;
&lt;body&gt; &lt;div class="phppot-container"&gt; &lt;div class="error"&gt; Sorry. Something went wrong. &lt;a href="index.php"&gt;Try again&lt;/a&gt;. &lt;/div&gt; &lt;/div&gt;
&lt;/body&gt;
&lt;/HTML&gt;
&lt;?php
}
session_write_close();
exit();
</pre>
<p>The following PHP class has functions to prepare database queries. It is to read data, to check user existency, to insert new records.</p>
<p class="code-heading">lib/Member.php</p>
<pre class="prettyprint lang-php">&lt;?php
namespace Phppot; class Member
{ private $db; private $userTbl; function __construct() { require_once __DIR__ . '/DataSource.php'; $this-&gt;db = new DataSource(); } function isExists($twitterOauthId) { $query = "SELECT * FROM tbl_member WHERE oauth_id = ?"; $paramType = "s"; $paramArray = array( $twitterOauthId ); $result = $this-&gt;db-&gt;select($query, $paramType, $paramArray); return $result; } function insertMember($oauthId, $fullName, $screenName, $photoUrl) { $query = "INSERT INTO tbl_member (oauth_id, oauth_provider, full_name, screen_name, photo_url) values (?,?,?,?,?)"; $paramType = "sssss"; $paramArray = array( $oauthId, 'twitter', $fullName, $screenName, $photoUrl ); $this-&gt;db-&gt;insert($query, $paramType, $paramArray); } function getUserById($id) { $query = "SELECT * FROM tbl_member WHERE id = ?"; $paramType = "i"; $paramArray = array( $id ); $result = $this-&gt;db-&gt;select($query, $paramType, $paramArray); return $result; }
}
</pre>
<h2 id="database-script">DataSource class and Database script</h2>
<p>The database related functions are in the DataSource class. It is for creating the database connection and to perform read, write operations.</p>
<p>It uses MySQLi prepared statements to execute database queries. It will help to have a secured code that prevents SQL injection.</p>
<p class="code-heading">lib/DataSource.php</p>
<pre class="prettyprint lang-php">&lt;?php
/** * Copyright © Phppot * * Distributed under 'The MIT License (MIT)' * In essense, you can do commercial use, modify, distribute and private use. * Though not mandatory, you are requested to attribute Phppot URL in your code or website. */
namespace Phppot; /** * Generic datasource class for handling DB operations. * Uses MySqli and PreparedStatements. * * @version 2.6 - recordCount function added */
class DataSource
{ const HOST = 'localhost'; const USERNAME = 'root'; const PASSWORD = 'test'; const DATABASENAME = 'oauth_login'; private $conn; /** * PHP implicitly takes care of cleanup for default connection types. * So no need to worry about closing the connection. * * Singletons not required in PHP as there is no * concept of shared memory. * Every object lives only for a request. * * Keeping things simple and that works! */ function __construct() { $this-&gt;conn = $this-&gt;getConnection(); } /** * If connection object is needed use this method and get access to it. * Otherwise, use the below methods for insert / update / etc. * * @return \mysqli */ public function getConnection() { $conn = new \mysqli(self::HOST, self::USERNAME, self:TongueASSWORD, self:Big GrinATABASENAME); if (mysqli_connect_errno()) { trigger_error("Problem with connecting to database."); } $conn-&gt;set_charset("utf8"); return $conn; } /** * To get database results * * @param string $query * @param string $paramType * @param array $paramArray * @return array */ public function select($query, $paramType = "", $paramArray = array()) { $stmt = $this-&gt;conn-&gt;prepare($query); if (! empty($paramType) &amp;&amp; ! empty($paramArray)) { $this-&gt;bindQueryParams($stmt, $paramType, $paramArray); } $stmt-&gt;execute(); $result = $stmt-&gt;get_result(); if ($result-&gt;num_rows &gt; 0) { while ($row = $result-&gt;fetch_assoc()) { $resultset[] = $row; } } if (! empty($resultset)) { return $resultset; } } /** * To insert * * @param string $query * @param string $paramType * @param array $paramArray * @return int */ public function insert($query, $paramType, $paramArray) { $stmt = $this-&gt;conn-&gt;prepare($query); $this-&gt;bindQueryParams($stmt, $paramType, $paramArray); $stmt-&gt;execute(); $insertId = $stmt-&gt;insert_id; return $insertId; } /** * To execute query * * @param string $query * @param string $paramType * @param array $paramArray */ public function execute($query, $paramType = "", $paramArray = array()) { $stmt = $this-&gt;conn-&gt;prepare($query); if (! empty($paramType) &amp;&amp; ! empty($paramArray)) { $this-&gt;bindQueryParams($stmt, $paramType, $paramArray); } $stmt-&gt;execute(); } /** * 1. * Prepares parameter binding * 2. Bind prameters to the sql statement * * @param string $stmt * @param string $paramType * @param array $paramArray */ public function bindQueryParams($stmt, $paramType, $paramArray = array()) { $paramValueReference[] = &amp;$paramType; for ($i = 0; $i &lt; count($paramArray); $i ++) { $paramValueReference[] = &amp;$paramArray[$i]; } call_user_func_array(array( $stmt, 'bind_param' ), $paramValueReference); } /** * To get database results * * @param string $query * @param string $paramType * @param array $paramArray * @return array */ public function getRecordCount($query, $paramType = "", $paramArray = array()) { $stmt = $this-&gt;conn-&gt;prepare($query); if (! empty($paramType) &amp;&amp; ! empty($paramArray)) { $this-&gt;bindQueryParams($stmt, $paramType, $paramArray); } $stmt-&gt;execute(); $stmt-&gt;store_result(); $recordCount = $stmt-&gt;num_rows; return $recordCount; }
}</pre>
<p>The below section shows the tbl_member database table script. Import this script before executing this example.</p>
<p class="code-heading">sql/structure.sql</p>
<pre class="prettyprint lang-php">--
-- Database: `oauth_login`
-- -- -------------------------------------------------------- --
-- Table structure for table `tbl_member`
-- CREATE TABLE `tbl_member` ( `id` int(11) NOT NULL, `oauth_id` varchar(255) NOT NULL, `oauth_provider` varchar(255) NOT NULL, `full_name` varchar(255) NOT NULL, `screen_name` varchar(255) NOT NULL, `photo_url` varchar(255) NOT NULL, `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- Indexes for dumped tables
-- --
-- Indexes for table `tbl_member`
--
ALTER TABLE `tbl_member` ADD PRIMARY KEY (`id`); --
-- AUTO_INCREMENT for dumped tables
-- --
-- AUTO_INCREMENT for table `tbl_member`
--
ALTER TABLE `tbl_member` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
</pre>
<h2 id="login-with-twitter-php-example-output">Login with Twitter example output</h2>
<p>After completing the application config, the home page will display the “Sign in with Twitter” button as below.</p>
<p><img loading="lazy" class="alignnone size-full wp-image-12250" src="https://phppot.com/wp-content/uploads/2020/09/sign-in-with-twitter-gray.png" alt="Sign In with Twitter Gray" width="158" height="28" srcset="https://phppot.com/wp-content/uploads/2020/09/sign-in-with-twitter-gray.png 158w, https://phppot.com/wp-content/uploads/20...150x28.png 150w" sizes="(max-width: 158px) 100vw, 158px"></p>
<p>Before login, the home page will display the “Sign in with Twitter” button as below. I used the login button downloaded from the official Twitter documentation.</p>
<p><img loading="lazy" class="alignnone size-full wp-image-12251" src="https://phppot.com/wp-content/uploads/2020/09/user-dashboard-twitter-login.jpg" alt="User Dashboard Twitter Login" width="350" height="160" srcset="https://phppot.com/wp-content/uploads/2020/09/user-dashboard-twitter-login.jpg 350w, https://phppot.com/wp-content/uploads/20...00x137.jpg 300w" sizes="(max-width: 350px) 100vw, 350px"></p>
<p><a class="download" href="https://phppot.com/downloads/twitter-oauth.zip">Download</a></p>
<p> <!-- #comments --> </p>
<div class="related-articles">
<h2>Popular Articles</h2>
</p></div>
<p> <a href="https://phppot.com/php/login-with-twitter-using-oauth1-0a-protocol-via-api-in-php/#top" class="top">↑ Back to Top</a> </p>
</div>


https://www.sickgaming.net/blog/2020/12/...pi-in-php/
Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)

Forum software by © MyBB Theme © iAndrew 2016