1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / earnlouq / buildersmine.com /
Filename : confirm-email.php
back
<?php
session_start();
include('../config/bconfig.php');
include('includes/settings.php');

error_reporting(E_ALL);
ini_set('display_errors', 1);

$uemail=$_GET['email'];
$sql = "SELECT * FROM `users` WHERE `email`='$uemail' ";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);
$uid = $row['id'];
$fname=$row['first_name'];
$lname=$row['last_name'];
$email=$row['email'];
$username=$row['username'];

$status=$row['status'];
$verification_code=$row['code'];


$status = $_GET['stats']; // Status code
$vcode = $status - 433456644;

//If the stats value passed from the previous page isn't set redirect back to home
if (!isset($status)) {
    echo "<script>window.location.href='forgot-password.php';</script>";
}

if (isset($_POST['submit'])) {
    $code = $_POST['code'];

    if ($code != $verification_code) {
        $msg = "Invalid Verification Code: $code";
        $type = "danger";
    } elseif (strlen($code) !== 6) {
        $msg = "Verification Code must be 6 digits";
        $type = "danger";
    } else {
        // Prepare the SQL statement
        $updateQuery = "UPDATE `users` SET `code` = '' WHERE `id` = ?";
        
        if ($stmt = mysqli_prepare($con, $updateQuery)) {
            // Bind the parameters
            mysqli_stmt_bind_param($stmt, "i", $uid);
            
            // Execute the statement
            if (mysqli_stmt_execute($stmt)) {
                $msg = "Email Verification Successful. Redirecting you...";
                $type = "success";

                session_start();
                // Store relevant user information in session variables
                $_SESSION['uid'] = $uid;
                $_SESSION['uemail'] = $uemail;

                ?>
                <script>
                setTimeout(function () {
                window.location ='reset-password.php';
                }, 3000);
                </script>
                <?php
            } else {
                $msg = "Error: Could not update the database.";
                $type = "danger";
            }
            
            // Close the statement
            mysqli_stmt_close($stmt);
        } else {
            $msg = "Error: Could not prepare the statement.";
            $type = "danger";
        }
    }
}

?>

<!-- meta tags and other links -->
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Builders Mine - Email Verification</title>
  <link rel="icon" type="image/png" href="assets/images/favicon.jpg" sizes="16x16">
  <!-- bootstrap 4  -->
  <link rel="stylesheet" href="assets/css/vendor/bootstrap.min.css">
  <!-- fontawesome 5  -->
  <link rel="stylesheet" href="assets/css/all.min.css">
  <!-- line-awesome webfont -->
  <link rel="stylesheet" href="assets/css/line-awesome.min.css">
  <link rel="stylesheet" href="assets/css/vendor/animate.min.css">
  <!-- slick slider css -->
  <link rel="stylesheet" href="assets/css/vendor/slick.css">
  <link rel="stylesheet" href="assets/css/vendor/dots.css">
  <!-- dashdoard main css -->
  <link rel="stylesheet" href="assets/css/main.css">

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
  <body>
    <div class="preloader">
      <div class="preloader-container">
        <span class="animated-preloader"></span>
      </div>
    </div>
  
    <!-- scroll-to-top start -->
    <div class="scroll-to-top">
      <span class="scroll-icon">
        <i class="fa fa-rocket" aria-hidden="true"></i>
      </span>
    </div>
    <!-- scroll-to-top end -->

  <div class="full-wh">
    <!-- STAR ANIMATION -->
    <div class="bg-animation">
      <div id='stars'></div>
      <div id='stars2'></div>
      <div id='stars3'></div>
      <div id='stars4'></div>
    </div><!-- / STAR ANIMATION -->
  </div>
  <div class="page-wrapper">



  <style>
.error{
  background: red !important;
    color:white;
}
.success{
  background: green !important;
    color:white;
}
.message{
  text-align:center;
  padding:5px;
}

.alert {
    transform: translateX(0px);
}

.alert {
    background: none; 
    display:block; 
    position:fixed; 
    top:0px !important; 
    right:0px; 
    text-align:center; 
    padding:10px 0px; 
    width:100%;
    z-index:99999;
    padding:10px;
    
}

.alert-danger{
    background: red;
    color:white;
}

.alert-success{
    background: rgb(125, 199, 14);
    color:white;
}


.close{
    color:white !important;
    font-size:20px !important;
    background: #262837;
    border:0px;
    border-radius:5px;
}

  </style>
<!-- account section start -->
<div class="account-section bg_img" data-background="assets/images/bg/bg-5.jpg">
  <div class="container">
    <div class="row justify-content-center">
      <div class="col-xl-5 col-lg-7">
      <div class="account-card">
              <div class="account-card__header bg_img overlay--one" data-background="assets/images/bg/bg-6.jpg">
                <h2 class="section-title">Email<span class="base--color">Verification</span></h2>
                <p>Please enter the 6-digits OTP that was sent to your email</p>
              </div>
          <div class="account-card__body">
            <h3 class="text-center">Email Verification</h3>
            <form class="mt-4" action="" method="post">
           

                <?php if(isset($msg)) { ?>
                    <div class="alert alert-<?php echo $type?>">
                    <span class=""><?php echo $msg; ?></span>
                    </div>
            <?php }?>
              <div class="form-group">
                <label>OTP</label>
                <input type="number" name="code" class="form-control" placeholder="">
              </div>
              <div class="form-row">
                
              </div>
              <div class="mt-3">
                <button class="cmn-btn" name="submit" type="submit">Verify Email</button>
              </div>
             
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
<!-- account section end -->

<!-- jQuery library -->
<script src="assets/js/vendor/jquery-3.5.1.min.js"></script>
  <!-- bootstrap js -->
  <script src="assets/js/vendor/bootstrap.bundle.min.js"></script>
  <!-- slick slider js -->
  <script src="assets/js/vendor/slick.min.js"></script>
  <script src="assets/js/vendor/wow.min.js"></script>
  <script src="assets/js/contact.js"></script>
  <!-- dashboard custom js -->
  <script src="assets/js/app.js"></script>
  </body>
</html>