get_var($wpdb->prepare(
”
SELECT wp_useraccount.UserPassword
FROM wp_useraccount
INNER JOIN wp_employernew
ON wp_useraccount.EmpID=wp_employernew.EmpID
WHERE wp_employernew.EmailAdd = %s
“,
$input_email
));
if($emp_pass !== null){
$to = $input_email;
$subject = ‘Password Retrieval’;
$message= “Your password is “. $emp_pass;
$header = ‘From: admin@tesda10.org’;
mail( $to, $subject, $message, $header);
//wp_mail( $to, $subject, $message, $header);
echo “Your password has been sent to your e-mail.”;
} else {
echo “The email is not registered. “;
$backLink = “http://localhost/wp-tesdaregion10/forgotPassword”;
$registerLink = “http://localhost/wp-tesdaregion10/employer-registration”;
echo “ Try Again.
“;
echo “ Register“;
}
?>