The STEEM WATCHER Detectives Reporting Portal (SW Portal) -- Development on Signup/Login/Forget form -- 29/12/2022

bountyking5 (79)Steem Devin Steem Dev • 2 years ago

SW Portal.jpg

Hello everyone!

How are you all? I hope my friends will be happy and well. by the grace of God, I am also well. Today I am here with new development of SW portal. In the last post SW portal, I've discussed my working on data fetching from database and some key points about reports.

Today I am going to sharing my development that I have achieved in this week. as you all know, for every project security is the main goal to achieve. Two different tasks have been completed successfully. security is the third main risk to protect the SW portal. there are different types of roles that I have decided to implement. the reports will show in the portal without any check. Sw portal will work on the base of steemit mechanism. no need to login just for reports watching. but if you are the general users and want to report any steemit post then you will need to create an account.

For all detectives, it is mandatory to sign up your account to add your caught reports of different steemit users. General users will create their account with limited access. they cannot edit and delete reports from database. Just detective can do all the functionality like report adds, report edit, report delete and report export etc. all these above security rights will apply on the base of login and sign-up form. Two different tables will user in database for storing the general users and detective's credentials.

First of all, i will share the interface of login form. then we will discuss about its mechanism.

HTML, CSS and bootstrap is used to create this login interface. Account will login on the base of username and password. Logo of Steem Watcher will display on the top of login farm. Before login your account, add report's function will not show as you can see in the below screenshot.

but after login, add report function will enable, and you can add your reports etc. screenshot is attached below, youe can see.

For first time, you need to create your account using the Signup form. the look of Signup form is shared below. Gmail, username, password, confirm password text field is mandatory to create your account.

if any user loss their login credentials, then he/she can reset their password with using the mentioned below form. you can see in the below shared screen.

PHP Code that will verify your login credentials.

<?php
include_once('connection.php');
session_start();
if (isset($_REQUEST['password']) and $_REQUEST['password'] != '') {
    extract($_REQUEST);
    $sql = "SELECT * FROM `users` WHERE `username` = '$userName' OR `email` = '$userName'";
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) === 1) {
        $row = mysqli_fetch_assoc($result);
        if ($row['username'] == $userName && $row['password'] == $password) {
            echo "Logged in!";
            // $_SESSION['username'] = $row['userName'];
            $_SESSION['id'] = $row['id'];
            header("Location: dashboad.php");
            exit();
        } 
else
 {
echo '<div class="col-sm-3 mt-4 mb-0 mx-auto alert alert-danger alert-dismissible fade show" role="alert">Incorrect Password!.
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
</div>';
            // exit();
        }
} 
else 
{
echo '<div class="col-sm-3 mt-5 mb-0 mx-auto alert alert-danger alert-dismissible fade show" role="alert">Incorrect Username or Email!. 
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
 </div>';
    }
}

?>

BoC- line.png