verify.php

<?php
include_once ('config/createConnection.php');

if (isset($_GET['verify']) && $_GET['verify'] == 1 && isset($_GET['email']) && isset($_GET['vc']))
{
$email = $_GET['email'];
$vc = $_GET['vc'];
try
{
    //veryfying the user in the database
    // $conn = new PDO($db_dsn, $db_username, $db_password);
    // $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT * FROM user WHERE email = :email");
    $stmt->execute(array(':email' => $email));
    //getting the row
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
    if (count($result))
    {
        foreach($result as $row)
        {
            if ($row['vc'] == $vc)
            {
                try
                {
                    $stmt = $conn->prepare('UPDATE user SET verified = :verified WHERE email = :email');
                    $stmt->execute(array(':verified' => '1', ':email' => $email));
                    
                    echo ("<script>alert('Account is now active!')</script>");
                }
                catch(PDOException $e)
                {
                    header("Location: index.php?con=error");
                    exit();
                }
            }
            else
            {
                header("Location: index.php?code=-1");
                exit();
            }
        }
    }
    else
    {
        header("Location: index.php?code=-1");
        exit();
    }
}
catch(PDOException $e)
{
    header("Location: index.php?con=error");
    exit();
}
}
// Initialize the session
session_start();
 
// Check if the user is already logged in, if yes then redirect him to welcome page
if(isset($_SESSION["loggedin"]) && $_SESSION["loggedin"] === true){
    header("location: index.php");
    exit;
}
 
// Include config file
require_once "./config/createConnection.php";
 
// Define variables and initialize with empty values
$username = $password = "";
$username_err = $password_err = "";
 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
 
    // Check if username is empty
    if(empty(trim($_POST["username"]))){
        $username_err = "Please enter username.";
    } else{
        $username = trim($_POST["username"]);
    }
    
    // Check if password is empty
    if(empty(trim($_POST["password"]))){
        $password_err = "Please enter your password.";
    } else{
        $password = trim($_POST["password"]);
    }
    //$password_err = $password;
    // Validate credentials
    if(empty($username_err) && empty($password_err)){
        // Prepare a select statement
        $sql = "SELECT userid, username, email, fullname, surname, verified, vc, notifications, password FROM user WHERE username = :username";
        
        if($stmt = $conn->prepare($sql)){
            // Bind variables to the prepared statement as parameters
            $stmt->bindParam(":username", $param_username, PDO::PARAM_STR);
            
            // Set parameters
            $param_username = trim($_POST["username"]);
            
            // Attempt to execute the prepared statement
            if($stmt->execute()){
                // Check if username exists, if yes then verify password
                if($stmt->rowCount() == 1){
                    if($row = $stmt->fetch()){
                        $id = $row["userid"];
                        $username = $row["username"];
                        $user_email = $row["email"];
                        $firstname = $row["fullname"];
                        $lastname = $row["surname"];
                        $is_verified = $row["verified"];
                        $notifications = $row["notifications"];
                        $vc = $row["vc"];
                        $hashed_password = $row["password"];
                        if(password_verify($password, $hashed_password)){
                            // Password is correct, so start a new session
                            session_start();
                            $password_err = "DAMN";
                            // Store data in session variables
                            $_SESSION["loggedin"] = true;
                            $_SESSION["id"] = $id;
                            $_SESSION["username"] = $username;
                            $_SESSION["email"] = $user_email;
                            $_SESSION["verified"] = $is_verified;
                            $_SESSION["notifications"] = $notifications;
                            $_SESSION["vc"] = $vc;
                            $_SESSION["firstname"] = $firstname;
                            $_SESSION["surname"] = $lastname;
                            // Redirect user to welcome page
                            header("location: index.php");
                        } else{
                            // Display an error message if password is not valid
                            $password_err = "The password you entered was not valid.";
                        
                        }
                    }
                } else{
                    // Display an error message if username doesn't exist
                    $username_err = "No account found with that username.";
                }
            } else{
                echo "Oops! Something went wrong. Please try again later.";
            }
        }
        
        // Close statement
        unset($stmt);
    }
    
    // Close connection
    unset($pdo);
}

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Login</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
    <style type="text/css">
        body{ font: 14px sans-serif; }
        .wrapper{ margin: auto; width: 350px; padding: 20px; }
    </style>
</head>
<body>
    <div>
        <?php include('header.php') ?>
    </div>
    <div class="wrapper">
        <h2>Login</h2>
        
        <p>Your Account is <strong>Verified</strong> Please fill in your credentials to login.</p>
        <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
            <div class="form-group <?php echo (!empty($username_err)) ? 'has-error' : ''; ?>">
                <label>Username</label>
                <input type="text" name="username" class="form-control" value="<?php echo $username; ?>">
                <span class="help-block"><?php echo $username_err; ?></span>
            </div>    
            <div class="form-group <?php echo (!empty($password_err)) ? 'has-error' : ''; ?>">
                <label>Password</label>
                <input type="password" name="password" class="form-control">
                <span class="help-block"><?php echo $password_err; ?></span>
            </div>
            <div class="form-group">
                <input type="submit" class="btn btn-primary" value="Login">
            </div>
            <p>Don't have an account? <a href="register.php">Sign up now</a>.</p>
            <p>Forgot Password? <a href="reset-password.php" class="btn btn-warning">Reset Your Password</a>.</p>
        </form>
    </div>
    <?php include ('footer.php') ?>
    
</body>
</html>