All fields are required."; } elseif($password != $confirm_password) { $message = "

Passwords do not match.

"; } else { $checkUsers = $pdo->query("SELECT COUNT(*) FROM users"); $totalUsers = $checkUsers->fetchColumn(); // Check Invitation Code if($totalUsers == 0) { // First user can register without invitation code } else { $checkReferral = $pdo->prepare("SELECT id FROM users WHERE referral_code=?"); $checkReferral->execute([$invitation_code]); if($checkReferral->rowCount() < 1) { $message = "

Invalid Invitation Code.

"; } } { // Check Email $checkEmail = $pdo->prepare("SELECT id FROM users WHERE email=?"); $checkEmail->execute([$email]); if($checkEmail->rowCount() > 0) { $message = "

Email already exists.

"; } else { // Check Phone $checkPhone = $pdo->prepare("SELECT id FROM users WHERE phone=?"); $checkPhone->execute([$phone]); if($checkPhone->rowCount() > 0) { $message = "

Phone number already exists.

"; } else { $referral_code = generateReferralCode($pdo); $hashedPassword = password_hash($password, PASSWORD_DEFAULT); $hashedPin = password_hash($pin, PASSWORD_DEFAULT); $insert = $pdo->prepare(" INSERT INTO users( referral_code, referred_by, full_name, email, phone, password, transaction_pin, level ) VALUES(?,?,?,?,?,?,?,?) "); $insert->execute([ $referral_code, $invitation_code, $full_name, $email, $phone, $hashedPassword, $hashedPin, 'Intern' ]); $message = "

Registration Successful.

Login Now

"; } } } } } ?> Sub Partner Registration

Sub Partner

Partnership & Referral Platform