prepare("SELECT id FROM users WHERE username = ?"); $stmt->execute([$username]); if ($stmt->fetch()) { $error = 'Username already exists'; } else { // Check if email already exists $stmt = $pdo->prepare("SELECT id FROM users WHERE email = ?"); $stmt->execute([$email]); if ($stmt->fetch()) { $error = 'Email already exists'; } else { // Create new user $hashed_password = password_hash($password, PASSWORD_DEFAULT); $stmt = $pdo->prepare("INSERT INTO users (username, email, password, full_name, phone, address, city, province, postal_code) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"); if ($stmt->execute([$username, $email, $hashed_password, $full_name, $phone, $address, $city, $province, $postal_code])) { $success = 'Account created successfully! You can now login.'; } else { $error = 'Error creating account. Please try again.'; } } } } } ?> Register - Baby Buckets & Stands

Create Account

Join Baby Buckets & Stands Family

Username *

Email *

Full Name *

Phone Number

Address

City

Province

Postal Code

Password *

Confirm Password *

Already have an account? Login

← Back to Website