get_row($wpdb->prepare(

SELECT *
FROM wp_useraccount
INNER JOIN wp_employernew
ON wp_useraccount.empID=wp_employernew.empID
WHERE UserID = %s
“,
$thisUser
));
?>
LMI ID No.: ” . $employer->EmpID. “
“;
echo “Employer’s Name: ” . $employer->Name . “
“;
echo “U—–e: ” . $employer->UserName. “
“;
echo “P——d: ” . $employer->UserPassword. “
“;
echo “Email: ” . $employer->EmailAdd. “
“;
echo “Location: ” . $employer->Location . “
“;
echo “POEA No: ” . $employer->POEANo. “
“;
echo “Company: ” . $employer->Company . “
“;
echo “Company Address: ” . $employer->CompanyAdd . “
“;
echo “Contact No: ” . $employer->ContactNo . “
“;
}

if(isset($_POST[‘viewuser’])){

$to = “admin@tesda10.org”; //$email
$subject = “New Employer Registration”;
$message= “Dear Valued Client;\n\nGreetings!\n\nYou have successfully registered to our LMI System. You can now log in to http://localhost/wp-tesdaregion10/employerlogin using the following username and password:\n\n”

.”Username: ” . $employer->UserName . “\n”
.”Password: ” . $employer->UserPassword . “\n\n\n”

.”Thank you.\n\n”
.”TESDA-Region 10 Office \nChaviz-Jupiter St., Macasandig, Cagayan de Oro”;
$header = “From: TESDA – Region 10”;

mail( $to, $subject, $message, $header);
//wp_mail( $to, $subject, $message, $header);
}else{
echo “Drafting e-mail failed!”;
}

?>