Email Verification
Questions?
Please don't hesitate to contact us if you have any queries
business@sabullion.co.za
+27 21 447 3240
query("SELECT userId FROM applogin WHERE email = " . $SA->qs($email) . " ");
$pdo->execute();
$results = $pdo->fetch();
if($results === false) {
$alertType = "No Account";
echo "
"
;
}else{
// Check if USER is already Verified // Check if user exists
$pdo = $SA->query("SELECT userId FROM applogin WHERE email = " . $SA->qs($email) . " AND verified = 0");
$pdo->execute();
$verifiedResult = $pdo->fetch();
if($verifiedResult === false) {
$alertType = 'Already Activated';
echo "
";
}else{
// DOUBLE CHECK THE CODE SENT TO MAKE SURE IT'S NOT AN OLD ONE
$pdo = $SA->query("SELECT email FROM appverify WHERE email = " . $SA->qs($email) . " AND token = " . $SA->qs($code) . " ");
$pdo->execute();
$verifiedCodeResult = $pdo->fetch();
if($verifiedCodeResult === false) {
$alertType = 'Invalid Code';
echo "
Sorry ! Your code does not match, please check your email
";
}else{
// START THE ACCOUNT ACTIVATION
$pdo = $SA->prepare("UPDATE applogin SET verified = :verified WHERE email = :email");
$pdo->execute(array(':verified' => 1, ':email' => $email));
$affected_rows = $pdo->rowCount();
if($affected_rows >= 1) {
$alertType = 'Welcome';
echo "
Welcome to SA Bullion, your account is now activated
Please fill in your login details below
to become a Client
";
// REMOVE DATA FROM APPVERIFY
$pdo = $SA->prepare("DELETE FROM appverify WHERE email = :email");
$pdo->execute(array(':email' => $email));
// REMOVE DATA FROM APPVERIFY
// $pdo = $SA->prepare("DELETE FROM temp_login WHERE email = :email");
// $pdo->execute(array(':email' => $email));
}else{
$alertType = 'DB';
echo "
:( something went wrong, please try again later
";
}
}
}
}
}else{
$alertType = "No Account";
echo "
"
;
}
?>