u_email_verification.php


<html>
  <head>
    <title>Verification</title>
    <link rel="stylesheet"  href="css/u_email_verification.css">
  </head>
    <body>
        <div class="main_uv">
            <div class="form_uv">
              <form method="POST">
                <div class="uv_h2">
                  <h2>User Email Verification</h2></div>
                  <input type="hidden" name="email" value="<?php echo $_GET['email']; ?>" required>
                  <input type="text" name="verification_code" class="form_ip_uv" placeholder="Enter verification code" required /><br><br>
                  <button type="submit" name="verify_email" class="registerbtn_uv">Verify Email</button>
             </form>
         </div>
      </div>
    </body>
</html>
<?php

    if (isset($_POST["verify_email"]))
    {
        $email = $_POST["email"];
        $verification_code = $_POST["verification_code"];

        // connect with database
        $conn = mysqli_connect("localhost", "root", "", "swapshop_next");

        // mark email as verified
        $sql = "UPDATE user_data SET email_verified_at = NOW() WHERE email = '$email' AND verification_code = '$verification_code'";
        $result  = mysqli_query($conn, $sql);

        if (mysqli_affected_rows($conn) == 0)
        {
            die("Incorrect Verification code <br> Try to add correct code.");
        }

        echo '<script type="text/javascript"> alert("Registered succesfully!")</script>';
        Header('Location:login_page.php');
        exit();
    }

?>