prepare("SELECT id FROM clients WHERE email = ?"); $exists->execute([$email]); if ($exists->fetch()) { $error = 'An account with that email already exists.'; } else { $refClient = null; if ($referral) { $refStmt = $db->prepare("SELECT id FROM clients WHERE referral_code = ?"); $refStmt->execute([$referral]); $refClient = $refStmt->fetchColumn(); } $hash = password_hash($password, PASSWORD_BCRYPT, ['cost' => 12]); $myCode = strtoupper(substr(md5($email . time()), 0, 8)); $stmt = $db->prepare(" INSERT INTO clients (email, password_hash, first_name, last_name, phone, referral_code, referred_by, verified, points) VALUES (?, ?, ?, ?, ?, ?, ?, 1, 50) "); $stmt->execute([$email, $hash, $first, $last, $phone, $myCode, $refClient ?: null]); $newId = $db->lastInsertId(); // Welcome points awardPoints($newId, 50, 'manual', 'Welcome bonus — thanks for joining Royal Luxe!'); // Referral bonus if ($refClient) { awardPoints((int)$refClient, 100, 'earn_referral', "Referral bonus — $first $last joined!"); } loginClient($newId); header('Location: /account/dashboard?welcome=1'); exit; } } } ?> Create Account — Royal Luxe Grooming
Royal Luxe

Create Your Account

Earn points on every visit. Save your pets. Book faster.

🎁 Get 50 points free just for joining — worth $0.50 off your next visit!

Already have an account? Sign in