My Steemit Friends Update: 7-Day Top Author By Article Pending Payout Ranking integrated into website.

• My Steemit Friends Tool website.
  
• Github repository.
• Merged Pull Request.
• Additional commit

New Features

• What feature(s) did you add?

The 7-Day Top Author By Article Pending Payout Ranking integrated into the My Steemit Friends website. You can find a link to the ranking table from the navigation bar of the main page of the My Steemit Friends website here: http://mysteemitfriends.online.

After you click into the link in the drop down, you will see the 7-Day Top Author By Article Pending Payout ranking table. You can also access this page directly here if you wish: http://mysteemitfriends.online/pending_payout.php

You can type your name into the search box to see your ranking, and then click the link to be directed to the page with your name highlighted in the ranking tables.

From the main My Steemit Friends page, you can also type in your username here and see the ranking directly, without going into the ranking table.

Click on the blue link at the bottom to see your name in ranking table page.

• How did you implement it/them?

-pending_payout.php: A list of Steemit Users ranked by the 7 day article pending payout value. SQL is used to retrieve the ranking data, and PHP is used to dispaly them. PHP sanitizing function is used on the page number input from the user and prepared SQL statements are used to prevent SQL injection. PHP statements are used to check for highlights and assist with appending dates.

-get_pendpay_rank.php: This PHP file is accessed by using AJAX when users click on Search Ranking button in either the ranking table page or the main My Steemit Friend page. PHP used is used to append dates to the SQL, which is then used to order the users and retrieve the ranking of a particular user. Finally PHP and HTML is used to create the link to the correct page on the ranking table, and an IF statement is used to prevent an error where a user does not have any pending payout. PHP Sanitizing function is used on the username input and then prepared SQL statement is used to prevent SQL injection.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---