I'll continue with the user registration system, implementing the multi-step form with all the requested features. query("SELECT * FROM countries ORDER BY name")->fetchAll(PDO::FETCH_ASSOC); $accountTypes = $pdo->query("SELECT * FROM account_types ORDER BY name")->fetchAll(PDO::FETCH_ASSOC); $currencies = $pdo->query("SELECT * FROM currencies ORDER BY name")->fetchAll(PDO::FETCH_ASSOC); // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $step = $_POST['step'] ?? 1; // Store form data in session if (!isset($_SESSION['register_data'])) { $_SESSION['register_data'] = []; } $_SESSION['register_data'] = array_merge($_SESSION['register_data'], $_POST); // Validate and process each step switch ($step) { case 1: // Validate personal info $errors = []; if (empty($_POST['full_name'])) { $errors['full_name'] = 'Full name is required'; } if (empty($_POST['email']) || !filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) { $errors['email'] = 'Valid email is required'; } else { // Check if email exists $stmt = $pdo->prepare("SELECT id FROM users WHERE email = ?"); $stmt->execute([$_POST['email']]); if ($stmt->fetch()) { $errors['email'] = 'Email already registered'; } } if (empty($_POST['phone'])) { $errors['phone'] = 'Phone number is required'; } if (empty($_POST['username'])) { $errors['username'] = 'Username is required'; } else { // Check if username exists $stmt = $pdo->prepare("SELECT id FROM users WHERE username = ?"); $stmt->execute([$_POST['username']]); if ($stmt->fetch()) { $errors['username'] = 'Username already taken'; } } if (empty($_POST['password']) || strlen($_POST['password']) < 8) { $errors['password'] = 'Password must be at least 8 characters'; } if (empty($_POST['confirm_password']) || $_POST['password'] !== $_POST['confirm_password']) { $errors['confirm_password'] = 'Passwords do not match'; } if (empty($errors)) { $step = 2; } break; case 2: // Validate account details $errors = []; if (empty($_POST['country_id'])) { $errors['country_id'] = 'Country is required'; } if (empty($_POST['account_type_id'])) { $errors['account_type_id'] = 'Account type is required'; } if (empty($_POST['currency_id'])) { $errors['currency_id'] = 'Currency is required'; } if (empty($errors)) { $step = 3; } break; case 3: // Validate KYC documents $errors = []; if (empty($_POST['ssn'])) { $errors['ssn'] = 'SSN is required'; } if (empty($_POST['id_card_number'])) { $errors['id_card_number'] = 'ID card number is required'; } // Validate file uploads $passportPhoto = validateFileUpload($_FILES['passport_photo']); $idCardPhoto = validateFileUpload($_FILES['id_card_photo']); $addressProof = validateFileUpload($_FILES['address_proof']); if (!$passportPhoto['success']) { $errors['passport_photo'] = $passportPhoto['message']; } if (!$idCardPhoto['success']) { $errors['id_card_photo'] = $idCardPhoto['message']; } if (!$addressProof['success']) { $errors['address_proof'] = $addressProof['message']; } if (empty($errors)) { $step = 4; } break; case 4: // Validate security pin $errors = []; if (empty($_POST['security_pin']) || !preg_match('/^\d{4}$/', $_POST['security_pin'])) { $errors['security_pin'] = '4-digit security pin is required'; } if (empty($errors)) { // Process registration $registerData = $_SESSION['register_data']; // Upload files $passportPhoto = uploadFile($_FILES['passport_photo'], 'kyc/'); $idCardPhoto = uploadFile($_FILES['id_card_photo'], 'kyc/'); $addressProof = uploadFile($_FILES['address_proof'], 'kyc/'); if (!$passportPhoto['success'] || !$idCardPhoto['success'] || !$addressProof['success']) { $errors['file_upload'] = 'Failed to upload one or more files'; $step = 3; break; } // Generate account number and codes $accountNumber = generateAccountNumber($registerData['country_id']); $cotCode = generateSecureCode(6); $imfCode = generateSecureCode(6); $taxCode = generateSecureCode(6); // Create user $stmt = $pdo->prepare("INSERT INTO users ( account_number, username, email, password, full_name, phone, country_id, account_type_id, currency_id, cot_code, imf_code, tax_code, security_pin, ssn, id_card_number, passport_photo, id_card_photo, address_proof, status ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'inactive')"); $hashedPassword = password_hash($registerData['password'], PASSWORD_BCRYPT); $stmt->execute([ $accountNumber, $registerData['username'], $registerData['email'], $hashedPassword, $registerData['full_name'], $registerData['phone'], $registerData['country_id'], $registerData['account_type_id'], $registerData['currency_id'], $cotCode, $imfCode, $taxCode, $registerData['security_pin'], $registerData['ssn'], $registerData['id_card_number'], $passportPhoto['file_name'], $idCardPhoto['file_name'], $addressProof['file_name'] ]); $userId = $pdo->lastInsertId(); // Send welcome email $subject = "Welcome to " . APP_NAME; $message = "

Welcome to " . APP_NAME . "

Thank you for registering with us. Your account details are:

Account Number: $accountNumber

Account Type: " . getAccountTypeName($registerData['account_type_id']) . "

Currency: " . getCurrencyCode($registerData['currency_id']) . "

Your account is currently inactive. Our team will review your application and activate it shortly.

You will receive another email once your account is activated.

"; sendEmail($registerData['email'], $subject, $message); // Clear session data unset($_SESSION['register_data']); // Redirect to success page header("Location: register-success.php"); exit; } break; } } else { // Initialize registration $step = 1; $_SESSION['register_data'] = []; } ?> Register - <?= APP_NAME ?>

Create Your Account

Personal Info

Account Details

KYC Documents

Security

Full Name

Phone Number

Username

Password

Minimum 8 characters

Confirm Password

Registration Successful - <?= APP_NAME ?>

Registration Successful!

Thank you for registering with .

Your account is currently being reviewed by our team. You will receive an email once your account is activated.

Please check your email for your account details and next steps.

Go to Login Page

prepare("SELECT * FROM users WHERE email = ?"); } else { $stmt = $pdo->prepare("SELECT * FROM users WHERE account_number = ?"); } $stmt->execute([$identifier]); $user = $stmt->fetch(PDO::FETCH_ASSOC); if (!$user) { $errors['identifier'] = 'Invalid email or account number'; } elseif (!password_verify($password, $user['password'])) { $errors['password'] = 'Invalid password'; } elseif ($user['status'] !== 'active') { $errors['account'] = 'Your account is not active. Please wait for activation or contact support.'; } else { // Store user in session and redirect to PIN verification $_SESSION['pending_user_id'] = $user['id']; header("Location: login-pin.php"); exit; } } ?> Login - <?= APP_NAME ?>

Login to Your Account

prepare("UPDATE users SET last_login = NOW() WHERE id = ?")->execute([$user['id']]); // Log activity logActivity($user['id'], null, 'login', 'User logged in'); // Redirect to dashboard header("Location: dashboard.php"); exit; } } ?> Security PIN Verification - <?= APP_NAME ?>

Security PIN Verification

Please enter your 4-digit security PIN to continue

prepare(" SELECT SUM(CASE WHEN type_id IN (4) THEN amount ELSE 0 END) - SUM(CASE WHEN type_id IN (1,2,3,5) THEN amount + fee ELSE 0 END) as balance FROM transactions WHERE user_id = ? AND status = 'completed' "); $stmt->execute([$user['id']]); $balanceData = $stmt->fetch(PDO::FETCH_ASSOC); $balance = $balanceData['balance'] ?? 0; // Get recent transactions $stmt = $pdo->prepare(" SELECT t.*, tt.name as type_name, c.code as currency_code FROM transactions t JOIN transaction_types tt ON t.type_id = tt.id JOIN currencies c ON t.currency_id = c.id WHERE t.user_id = ? ORDER BY t.created_at DESC LIMIT 5 "); $stmt->execute([$user['id']]); $transactions = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get virtual cards if any $stmt = $pdo->prepare(" SELECT vc.*, vct.name as card_type, vct.card_network FROM virtual_cards vc JOIN virtual_card_types vct ON vc.card_type_id = vct.id WHERE vc.user_id = ? AND vc.is_active = TRUE "); $stmt->execute([$user['id']]); $virtualCards = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> Dashboard - <?= APP_NAME ?>

Available Balance

Recent Transactions

View All

No recent transactions

Virtual Cards

Manage

No virtual cards

Get a Card

•••• •••• ••••

Expires
/

CVV
•••

Crypto Rates

Bitcoin (BTC)

$42,850.12

Ethereum (ETH)

$2,315.67

BNB (BNB)

$301.45

Solana (SOL)

$102.89

prepare("SELECT name FROM account_types WHERE id = ?"); $stmt->execute([$accountTypeId]); $result = $stmt->fetch(PDO::FETCH_ASSOC); return $result ? $result['name'] : 'Unknown'; } function getCurrencyCode($currencyId) { global $pdo; $stmt = $pdo->prepare("SELECT code FROM currencies WHERE id = ?"); $stmt->execute([$currencyId]); $result = $stmt->fetch(PDO::FETCH_ASSOC); return $result ? $result['code'] : 'USD'; } Would you like me to continue with the admin dashboard and other features like transfers, virtual cards, and loan applications?