getMessage();
}
$res = $db->query("SELECT * FROM contact WHERE otp = '" . strtoupper($_POST['otp']) . "' AND date_time_attended IS NULL");
if ($res = $res->fetchAll()) {
if ($res) {
$db->query("UPDATE contact SET date_time_attended = NOW() WHERE otp = '{$_POST['otp']}'");
$name = openssl_decrypt($res[0][1], 'aes-256-cbc', $encryptionKey);
$email = openssl_decrypt($res[0][4], 'aes-256-cbc', $encryptionKey);
$htmlString = '
THANK YOU,' . $name . ' for attending to our event!
CONTACT US:
Lowveld Nuts (Pty) Ltd.
Lowveld Nuts (Pty) Ltd, White River, Brondal, 1240
info@lowveldnuts.co.za
013 762 3103/4
064 743 0348
We look forward to see you there!
Hosted and Developed by Elegant Work Group (Pty) Ltd.
';
if ($email_class->send_mail([$email], [$name], $htmlString, "LOWVELD NUTS (Pty) Ltd")) {
echo "success";
} else {
echo "failed to send email";
}
}
} else {
echo "OTP NOT FOUND OR ALREADY IN ATTENDANCE";
}