The Switch might have only got Disaster Report 4: Summer Memories in April, but series’ developer Granzella has seemingly already begun work on the fifth game.

In a 2020 retrospective article on its official website, the end of a section about the fourth game discusses the fifth title. It’s mentioned how “planning and partial prototyping” for Disaster Report 5 has already started and to “look forward” to more news in the future. Here is the message in full:

Rumors of a “5“

There might be some of you saying “All you have to say are advertisements?,” so I will share a bit about our next title.

According to information I acquired from sources I am unable to disclose, planning and partial prototyping for Disaster Report 5 seems to have already begun.

As for whether or not “Stiver Island” (Capital Island) is involved in the story this time… I’ll leave it at that for now as I’d rather not lose my job.

Please look forward to more news in the future!

As noted by Gematsu, it’s not the first time Granzella has necessarily teased the fifth game, but it’s the most official so far.

Disaster Report 4: Summer Memories has a lot of references to a fifth entry – including the ability to change the title screen to read “Disaster Report 5?” – so it’s no surprise to hear a fifth game is on the way.

If you’re interested in getting to know more about this series before the next game is officially announced, be sure to check out the fourth entry, available now on the Switch. You can also read our review.

Python’s built-in getattr(object, string) function returns the value of the object‘s attribute with name string. If this doesn’t exist, it returns the value provided as an optional third default argument. If that doesn’t exist either, it raises an AttributeError. An example is getattr(porsche, 'speed') which is equivalent to porsche.speed.

Usage

Learn by example! Here’s an example on how to use the getattr() built-in function.

# Define class with one attribute

class Car: def __init__(self, brand, speed): self.brand = brand self.speed = speed # Create object

porsche = Car('porsche', 100)

tesla = Car('tesla', 110) # Two alternatives to get instance attributes:

print(getattr(porsche, 'brand') + " " + str(getattr(porsche, 'speed')))

print(tesla.brand + " " + str(tesla.speed)) # Get an attribute that doesn't exist with default argument:

print(getattr(porsche, 'color', 'red'))

The output of this code snippet is:

porsche 100

tesla 110

red

Syntax getattr()

The getattr() object has the following syntax:

Syntax: 

getattr(object, attribute[, default]) # Get object's attribute value or default if non-existent

Video getattr()

Return value from getattr()

The getattr(object, attribute, default) method returns one of the following:

• the value of the object‘s attribute
• default, if the attribute doesn’t exist
• AttributeError if neither the attribute exists, nor default is provided.

Interactive Shell Exercise: Understanding getattr()

Consider the following interactive code:

Exercise: Fix the error in the code!

But before we move on, I’m excited to present you my brand-new Python book Python One-Liners (Amazon Link).

If you like one-liners, you’ll LOVE the book. It’ll teach you everything there is to know about a single line of Python code. But it’s also an introduction to computer science, data science, machine learning, and algorithms. The universe in a single line of Python!

The book is released in 2020 with the world-class programming book publisher NoStarch Press (San Francisco).

Link: https://nostarch.com/pythononeliners

Why Using getattr() Instead of Dot to Get an Attribute?

You’ve seen two alternatives to get an attribute:

• getattr(object, attribute_str)
• object.attribute

Why using the getattr() function over the more concise dot syntax?

There are two main reasons:

• getattr() provides a default value in case the attribute doesn’t exist whereas the dot syntax throws an error.
• getattr() allows to dynamically access the attribute with the string instead of the name. For example, you may obtain the string as a user input, in which case, you cannot use the dot syntax object.attribute because attribute is a string, not a name.

Related Functions

• The setattr() function returns the value of an attribute.
• The hasattr() function checks if an attribute exists.
• The delattr() function deletes an existing attribute.

Summary

Python’s built-in getattr(object, string) function returns the value of the object‘s attribute with name string.

# Define class with one attribute

class Car: def __init__(self, brand, speed): self.brand = brand self.speed = speed porsche = Car('porsche', 100)

print(getattr(porsche, 'brand') + " " + str(getattr(porsche, 'speed')))

# porsche 100

If this doesn’t exist, it returns the value provided as an optional third default argument.

print(getattr(porsche, 'color', 'red'))

# red

If that doesn’t exist either, it raises an AttributeError.

print(getattr(porsche, 'color')) '''

Traceback (most recent call last): File "C:\Users\xcent\Desktop\Finxter\Blog\HowToConvertBooleanToStringPython\code.py", line 12, in <module> print(getattr(porsche, 'color'))

AttributeError: 'Car' object has no attribute 'color' '''

An example is getattr(porsche, 'speed') which is equivalent to porsche.speed.

print(getattr(porsche, 'speed'))

print(porsche.speed)

# Both print attribute value: 100

I hope you enjoyed the article! To improve your Python education, you may want to join the popular free Finxter Email Academy:

Do you want to boost your Python skills in a fun and easy-to-consume way? Consider the following resources and become a master coder!

Where to Go From Here?

Enough theory, let’s get some practice!

To become successful in coding, you need to get out there and solve real problems for real people. That’s how you can become a six-figure earner easily. And that’s how you polish the skills you really need in practice. After all, what’s the use of learning theory that nobody ever needs?

Practice projects is how you sharpen your saw in coding!

Do you want to become a code master by focusing on practical code projects that actually earn you money and solve problems for people?

Then become a Python freelance developer! It’s the best way of approaching the task of improving your Python skills—even if you are a complete beginner.

Join my free webinar “How to Build Your High-Income Skill Python” and watch how I grew my coding business online and how you can, too—from the comfort of your own home.

Join the free webinar now!

The post Python getattr() first appeared on Finxter.

Last modified on December 27th, 2020.

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.

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.

Application with the OAuth login feature has many advantages.

• Simplifies the login process.
• Reduces friction by minimising user’s effort with a single click.
• Saves developers’ effort from building a custom login.
• Assures secure authentication flow.

We have already seen how to integrate Facebook OAuth login into an application. Let us see how to Login with Twitter using OAuth authentication.

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.

Twitter uses various authentication methods. Those are, OAuth 1.0a, OAuth 2.0 Bearer token, Basic authentication. I used OAuth 1.0a authentication to validate login with Twitter API requests.

During the login flow, Twitter prompts to enter user credentials to login. Then, it will ask to authorize the App for the first time.

“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.

In this article, we will see how to integrate “Login with Twitter” by completing each of the below steps.

• How to get and configure the API keys.
• How to perform the 3-step authentication flow.
• Create requests and handle responses during the authentication flow.
• Store the authenticated user data into the Database.

What is inside?

1. Twitter OAuth login flow
2. How to integrate Twitter OAuth login?
3. Generating Twitter app keys
4. About this example
5. Twitter OAuth PHP service
6. PHP code to handle logged-in user data
7. Database script
8. Login with Twitter PHP example output

Twitter OAuth login flow

The Twitter login authentication flow includes three steps.

1. Get a Request token and a secret-key.
2. Redirect to Twitter to login and approve access rights to the Twitter app.
3. Get an Access token and the secret-key to access the user account via API.

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.

The following diagram shows the “Login with Twitter” flow. It indicates the steps, request parameters and API response data.

Click to see a larger image.

How to integrate Twitter OAuth login?

Twitter gives a Login with Twitter or Sign in with Twitter button control to put into an application. It makes users sign in to the application with a couple of clicks.

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.

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.

Instead of using custom handlers, we can use built-in Twitter client libraries.

With the access_token, API will allow access to hit the endpoints. But, it depends on the App permissions set in the developer console.

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.

Generating Twitter API keys

The process of generating Twitter API keys is straight-forward. Once we have seen the steps to get keys for Google OAuth login integration.

Login to the Twitter developer portal and follow the below steps.

1. Login to Twitter and go to its developer console.
2. Create a Twitter developer App. (project-specific app or standalone app).
3. Go to app settings to edit permissions and authentication settings.
4. Go to the “keys and tokens” tab to copy the consumer key and the secret key.
5. Save the keys in a secured place and configure them into the application.

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.

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.

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.

Common/config.php

<?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';

}

About this example

There are various ways to implement Twitter OAuth login 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.

This example shows a simple code for “Login with Twitter” integration. It uses no external libraries to achieve this.

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.

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.

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.

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.

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.

Twitter OAuth PHP service

This PHP service class request Twitter API for the access key and token. It follows the three steps to obtain the access token.

We have seen such similar steps to get the access token in the LinkedIn OAuth login example code earlier.

The following three methods perform the three steps.

Step 1: getRequestToken() – sends the oauth_callback with the authentication header. It requests request_token and the secrete key from the Twitter API.

Step 2: getOAuthVerifier() – 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 oauth_callback with the oauth_verifier in the querystring.

Step 3: getAccessToken() – 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.

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.

lib/TwitterOAuthLogin.php

<?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->consumerKey = Config::TW_CONSUMER_KEY; $this->consumerSecret = Config::TW_CONSUMER_SECRET; } public function getOauthVerifier() { $requestResponse = $this->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' => Config::TW_CALLBACK_URL, "oauth_consumer_key" => $this->consumerKey, "oauth_nonce" => $this->getToken(42), "oauth_signature_method" => $this->signatureMethod, "oauth_timestamp" => time(), "oauth_version" => $this->oauthVersion ); $params['oauth_signature'] = $this->createSignature('POST', $url, $params); $oauthHeader = $this->generateOauthHeader($params); $response = $this->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' => $oauthVerifier ); $params = array( "oauth_consumer_key" => $this->consumerKey, "oauth_nonce" => $this->getToken(42), "oauth_signature_method" => $this->signatureMethod, "oauth_timestamp" => time(), "oauth_token" => $oauthToken, "oauth_version" => $this->oauthVersion ); $params['oauth_signature'] = $this->createSignature('POST', $url, $params, $oauthTokenSecret); $oauthHeader = $this->generateOauthHeader($params); $response = $this->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->getAccessToken($oauthVerifier, $oauthToken, $oauthTokenSecret); $url = 'https://api.twitter.com/1.1/account/verify_credentials.json'; $params = array( "oauth_consumer_key" => $this->consumerKey, "oauth_nonce" => $this->getToken(42), "oauth_signature_method" => $this->signatureMethod, "oauth_timestamp" => time(), "oauth_token" => $accessTokenResponse["access_token"], "oauth_version" => $this->oauthVersion ); $params['oauth_signature'] = $this->createSignature('GET', $url, $params, $accessTokenResponse["access_token_secret"]); $oauthHeader = $this->generateOauthHeader($params); $response = $this->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 => $headers, CURLOPT_HEADER => false, CURLOPT_URL => $url, CURLOPT_RETURNTRANSFER => true, CURLOPT_SSL_VERIFYPEER => 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->http_status = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); return $response; } public function generateOauthHeader($params) { foreach ($params as $k => $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 . "&" . rawurlencode($url) . "&" . $strParams; $fp = fopen("eg.log", "a"); fwrite($fp, "Baaaase: " . $baseString . "\n"); $signKey = $this->generateSignatureKey($tokenSecret); $oauthSignature = base64_encode(hash_hmac('sha1', $baseString, $signKey, true)); return $oauthSignature; } public function generateSignatureKey($tokenSecret) { $signKey = rawurlencode($this->consumerSecret) . "&"; 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 < $length; $i ++) { $token .= $codeAlphabet[$this->cryptoRandSecure(0, $max)]; } return $token; } public function cryptoRandSecure($min, $max) { $range = $max - $min; if ($range < 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 << $bits) - 1; // set all lower bits to 1 do { $rnd = hexdec(bin2hex(openssl_random_pseudo_bytes($bytes))); $rnd = $rnd & $filter; // discard irrelevant bits } while ($rnd >= $range); return $min + $rnd; }

}

Initiate login flow with “Sign in with Twitter” control

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.

The following code shows the index.php 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.

It invokes the TwitterOAuthService to initiate the login flow. This initiation will happen when the user tries to log in.

index.php

<?php

namespace Phppot; if (isset($_GET["action"]) && $_GET["action"] == "login") { require_once __DIR__ . '/lib/TwitterOauthService.php'; $twitterOauthService = new TwitterOauthService(); $redirectUrl = $twitterOauthService->getOauthVerifier(); header("Location: " . $redirectUrl); exit();

} session_start();

if ($_SESSION["id"]) { $memberId = $_SESSION["id"];

}

session_write_close(); ?>

<html>

<head>

<title>Home</title>

<link rel="stylesheet" href="assets/style.css">

</head>

<body> <div class="phppot-container">

<?php

if (empty($memberId)) { ?> <a href="?action=login"> <img class="twitter-btn" src="sign-in-with-twitter.png"></a>

<?php

} else { require_once './lib/Member.php'; $member = new Member(); $userData = $member->getUserById($memberId); ?>

<div class="welcome-messge-container"> <img src="<?php echo $userData[0]["photo_url"]; ?>" class="profile-photo" /> <div>Welcome <?php echo $userData[0]["screen_name"]; ?></div> </div>

<?php

}

?>

</div>

</body>

</html>

PHP code to handle logged-in user data

After completing the 3-steps, the TwitterOauthService will return the user access token. Then it invokes GET oauth/verify_credentials endpoint to read the user daya.

It will return the logged-in user data as a JSON response. The application callback endpoint receives this data.

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.

sign-in-with-twitter.php

<?php

namespace Phppot; require_once './lib/TwitterOauthService.php';

$TwitterOauthService = new TwitterOauthService(); session_start();

$oauthTokenSecret = $_SESSION["oauth_token_secret"]; if (! empty($_GET["oauth_verifier"]) && ! empty($_GET["oauth_token"])) { $userData = $TwitterOauthService->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->isExists($oauthId); if (empty($isMemberExists)) { $memberId = $member->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 { ?>

<HTML>

<head>

<title>Signin with Twitter</title>

<link rel="stylesheet" href="assets/style.css">

</head>

<body> <div class="phppot-container"> <div class="error"> Sorry. Something went wrong. <a href="index.php">Try again</a>. </div> </div>

</body>

</HTML>

<?php

}

session_write_close();

exit();

The following PHP class has functions to prepare database queries. It is to read data, to check user existency, to insert new records.

lib/Member.php

<?php

namespace Phppot; class Member

{ private $db; private $userTbl; function __construct() { require_once __DIR__ . '/DataSource.php'; $this->db = new DataSource(); } function isExists($twitterOauthId) { $query = "SELECT * FROM tbl_member WHERE oauth_id = ?"; $paramType = "s"; $paramArray = array( $twitterOauthId ); $result = $this->db->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->db->insert($query, $paramType, $paramArray); } function getUserById($id) { $query = "SELECT * FROM tbl_member WHERE id = ?"; $paramType = "i"; $paramArray = array( $id ); $result = $this->db->select($query, $paramType, $paramArray); return $result; }

}

DataSource class and Database script

The database related functions are in the DataSource class. It is for creating the database connection and to perform read, write operations.

It uses MySQLi prepared statements to execute database queries. It will help to have a secured code that prevents SQL injection.

lib/DataSource.php

<?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->conn = $this->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::PASSWORD, self::DATABASENAME); if (mysqli_connect_errno()) { trigger_error("Problem with connecting to database."); } $conn->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->conn->prepare($query); if (! empty($paramType) && ! empty($paramArray)) { $this->bindQueryParams($stmt, $paramType, $paramArray); } $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { while ($row = $result->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->conn->prepare($query); $this->bindQueryParams($stmt, $paramType, $paramArray); $stmt->execute(); $insertId = $stmt->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->conn->prepare($query); if (! empty($paramType) && ! empty($paramArray)) { $this->bindQueryParams($stmt, $paramType, $paramArray); } $stmt->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[] = &$paramType; for ($i = 0; $i < count($paramArray); $i ++) { $paramValueReference[] = &$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->conn->prepare($query); if (! empty($paramType) && ! empty($paramArray)) { $this->bindQueryParams($stmt, $paramType, $paramArray); } $stmt->execute(); $stmt->store_result(); $recordCount = $stmt->num_rows; return $recordCount; }

}

The below section shows the tbl_member database table script. Import this script before executing this example.

sql/structure.sql

--

-- 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;

Login with Twitter example output

After completing the application config, the home page will display the “Sign in with Twitter” button as below.

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.

Download

↑ Back to Top

Before selling, gifting, or recycling a Mac, you’ll want to take a number of steps to properly prepare it. Here’s how.

Step one: Back up your Mac

Make sure to back up your Mac before proceeding.

Sign out of your services

Signing out of your services and your Apple ID, is also a good idea.

A couple of additional steps

Apple also recommends that users reset the NVRAM on their devices.

Finally, erase and reinstall macOS.

Once you’re finished with the necessary steps, you can reinstall a fresh copy of macOS.

It’s GOTY time, people! Yes, as 2020 draws to a close, the internet is flooded with customary lists touting the best whatever of the year (with Hades rightfully being at the top of most of them). We’ve had our say — and so have you — but today we’re going to have some fun with the Nintendo Life Alternative Game Awards 2020.

As you’ll see from the categories below, this is where we let loose a little festive cheer and highlight things that cropped up throughout the year that we believe deserve recognition for some reason, usually because they raised a smile (or an eyebrow). We had fun with these light-hearted gongs last year, and we’re all in need of some holiday levity.

So, join us for a look at Nintendo Life’s 2020 ‘alternative’ GOTYs. We begin with the most unnecessarily unweildy title…

Most Long-Winded Switch Game Title 2020

Winner: Shiren the Wanderer: The Tower of Fortune and the Dice of Fate

Spike Chunsoft US

Runners-up: Is It Wrong to Try to Pick Up Girls in a Dungeon? Familia Myth Infinite Combate; Dr Kawashima’s Brain Training for Nintendo Switch

Finding the right name for your game can be tough (as we found out when we spoke to various developers earlier in the year on just that subject) but brevity is usually a virtue. At least, brevity is a virtue to us writers, but then we have to type out the full titles more than most.

The title which struck us as particularly cumbersome this year is Spike Chunsoft’s Switch release of previously Japan-only DS title “Noun the Noun: The Noun of Noun and the Noun of Noun”. Nothing against this roguelike dungeon crawler — it’s always nice to see Japanese-exclusives come to the West — but the noun soup of Shiren the Wanderer: Etc., Etc wound us up for some reason. As Indiana Jones taught us, four nouns is your absolute limit, preferably with an adjective thrown in for some spice.

Incidentally, blandest title of the year goes to Immortals Fenyx Rising. Ergh.

Best ‘Game That Doesn’t Fit Neatly On Any Of Our Genre Lists’ Award 2020

Winner: Part Time UFO

HAL Laboratory

Runner-up: Hypnospace Outlaw

We do our best to keep our Switch Essentials genre lists fresh, and we continually add and cull entries as new worthy titles are released. Sometimes, though, a game comes along that doesn’t easily sit on any particular list and we’re left in a quandary as to how to highlight it as a solid gold good’un.

HAL Laboratory’s Part Time UFO is a wonderfully quirky example. As per our tagline for the review, it’s a game about picking things up. It’s cute and physics-based. It’s split into stages and has puzzle-y elements. It’s a bit like World of Goo, sort of. It’s a… well, it’s a game — a good one!

Just go download it already.

Best Switch Icon 2020

Winner: A Short Hike

Nintendo Life

Runners-up: Florence; I Am Dead; Control Ultimate Edition – Cloud Version

We’ve seen some lovely Switch icons appear on our console menus this year. The wonderful (and ever-changing) world of Switch game icons is a topic we’ve examined before, and Switch Icon Showdown is a site devoted to nothing but ranking the best and worst examples. For the most part, developers have arguably got better at assembling a pleasing little icon that sits nicely on the Switch menu screen; A Short Hike was perhaps the loveliest we saw all year.

It’s all a matter of opinion, of course. Some people may have adored the original Carrion icon. Each to their own.

Best ‘End-Of-Year Arrival That Dropped Too Late To Make Our GOTY List’ 2020

Winner: Dicey Dungeons

Distractionware Limited

Runners-up: DOOM Eternal; Among Us; Puyo Puyo Tetris 2

December is a busy month for anyone who likes video games, and if you’re writing about them, you’ve got one eye on your GOTY shortlist (and backlog), and the other on pre-holiday end-of-year prep. It’s likely that most of the team won’t have had the opportunity to give late-releasing games a fair shake — if they’ve had time or access to play them at all — so there’ll inevitably be some real gems that fall through the cracks when it comes to voting. This is usually followed by a pang of regret after the holidays that we can’t go back and massage our picks to acknowledge a late-comer or two.

Roguelike deckbuilder Dicey Dungeons is one such game; the couple of us who have managed to squeeze in time with it over the past week or so have loved every single minute. Cracking music, addictive battling with a great art style and sense of humour; if you’re looking for something to while away the hours this Christmas while the rest of the family are watching Home Alone 3 or some such rubbish, this one’s an absolute winner.

The ink has dried on Tencent’s acquisition of Leyou Technologies, meaning the Chinese video game and technology giant now owns Splash Damage, Digital Extremes, and a handful of other developers acquired by Leyou over the years.

Earlier in the year, news broke that Tencent was looking to acquire Leyou. The deal, a $1.5 billion acquisition, was officially confirmed by Tencent shareholders today and studios involved in the deal like Splash Damage have weighed in on their own sites.

“We’ve always been dedicated to creating team-based games that spark friendships and build passionate communities, and we strive to work with partners who believe in that mission,” reads a statement from Splash Damage CEO Richard Jolly.

“In our many discussions with Tencent, it became clear that they not only believe in that mission but will do everything they can to enable and empower us to realise it. This is going to be a bold new phase for our studio, with an amazing line-up of ambitious games that deliver on what Splash Damage is all about. We couldn’t be more excited.”

On the Digital Extremes side of things, the Warframe developer says in its own statement that the deal won’t impact development of the game and that it expects to retain creative independence under Tencent as it had under Leyou.

This deal extends Tencent’s massive reach in the game industry. In addition to these new acquisitions, Tencent owns studios like Riot Games, Funcom, and Shark Mob on top of investments in Supercell, Epic Games, Frontier Developments, Activision Blizzard, Ubisoft, and many more.