<?php
//db Connection file
include('includes/config.php');
//code for password recovery
if(isset($_POST['resetpassword']))
{
$lname=$_POST['lname'];
$email=$_POST['emailid'];
$password=md5($_POST['inputpass']);
$updatetTime = date( 'd-m-Y h:i:s A', time () );
//checking email if already exists
   $ret=mysqli_query($con, "call sp_userpwdrecoveryvalidation('$lname','$email')");
    $result=mysqli_num_rows($ret);
    if($result==0){

echo "<script>alert('Last Name or Email id is invalid');</script>";
    }else{
         $ret->close();
         $con->next_result();
     $ret=mysqli_query($con,"call sp_userpasswordrecovery('$lname','$email','$password','$updatetTime')");
    if ($ret) {
  
    echo "<script>alert('Your password successfully reset');</script>";
    echo "<script>window.location.href='login.php'</script>";
  }
}
}




?>
<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>User Management System in PHP Using Stored Procedure</title>

    <!-- Custom fonts for this template-->
    <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link
        href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
        rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="css/sb-admin-2.min.css" rel="stylesheet">
<script type="text/javascript">

function checkpass()
   alert('Test');
{
if(document.passwordreset.inputpass.value!=document.passwordreset.repeatpass.value)
{
alert('New Password and Repeat Password field does not match');
document.passwordreset.repeatpass.focus();
return false;
}
return true;
}   

</script>
</head>

<body class="bg-gradient-primary">

    <div class="container">

        <div class="card o-hidden border-0 shadow-lg my-5">
            <div class="card-body p-0">
                <!-- Nested Row within Card Body -->
                <div class="row">
                    <div class="col-lg-5 d-none d-lg-block bg-register-image"></div>
                    <div class="col-lg-7">
                        <div class="p-5">
                            <div class="text-center">
                                <h5 style="color:blue">User Management System in PHP Using Stored Procedure</h5>
                                <h1 class="h4 text-gray-900 mb-4">Password Recovery</h1>
                            </div>
                            <form class="user" method="post" name="" onsubmit="return checkpass();">
                                <div class="form-group row">
                                    <div class="col-sm-12">
                                        <input type="text" class="form-control form-control-user" id="lname" name="lname" placeholder="Last Name" required="true">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <input type="email" class="form-control form-control-user" id="emailid" placeholder="Email Address" name="emailid" required="true">
                                </div>
                                <div class="form-group row">
                                    <div class="col-sm-6 mb-3 mb-sm-0">
                                        <input type="password" class="form-control form-control-user" id="inputpass" name="inputpass" placeholder="Password" required="true">
                                    </div>
                                    <div class="col-sm-6">
                                        <input type="password" class="form-control form-control-user" id="repeatpass" placeholder="Repeat Password" name="repeatpass" required="true">
                                    </div>
                                </div>
                                <button type="submit" name="resetpassword" class="btn btn-primary btn-user btn-block">
                                   Submit
                                </button>
                           
                            </form>
                            <hr>
                         
                            <div class="text-center">
                                <a class="small" href="login.php">Already have an account? Login!</a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

    </div>

    <!-- Bootstrap core JavaScript-->
    <script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

    <!-- Core plugin JavaScript-->
    <script src="vendor/jquery-easing/jquery.easing.min.js"></script>

    <!-- Custom scripts for all pages-->
    <script src="js/sb-admin-2.min.js"></script>

</body>

</html>