prepare("SELECT id FROM users WHERE email = ?"); $stmt->execute([$email]); if ($stmt->fetch()) $errors[] = 'Email already registered.'; } // Create user if (empty($errors)) { try { $hash = password_hash($password, PASSWORD_DEFAULT); $status = ($user_type === 'brand') ? 'pending' : 'active'; $db = db(); $stmt = $db->prepare("INSERT INTO users (email, password_hash, display_name, user_type, status, created_at) VALUES (?, ?, ?, ?, ?, NOW())"); $stmt->execute([$email, $hash, $display_name, $user_type, $status]); $user_id = (int)$db->lastInsertId(); if ($user_type === 'creator') { $stmt = $db->prepare("INSERT INTO creator_profiles (user_id, platform, platform_url, onboarding_step) VALUES (?, ?, ?, 'collective_setup')"); $stmt->execute([$user_id, $creator_platform, $creator_platform_url]); } elseif ($user_type === 'brand') { $stmt = $db->prepare("INSERT INTO brand_profiles (user_id, company_name, approval_status) VALUES (?, ?, 'pending')"); $stmt->execute([$user_id, $company_name]); } elseif ($user_type === 'fan') { $interests = isset($_POST['interests']) ? json_encode($_POST['interests']) : '[]'; $stmt = $db->prepare("INSERT INTO fan_profiles (user_id, interests, onboarding_complete) VALUES (?, ?, 0)"); $stmt->execute([$user_id, $interests]); } $_SESSION['user_id'] = $user_id; $_SESSION['user_type'] = $user_type; header('Location: /dashboard/index.php'); exit; } catch (PDOException $e) { $errors[] = 'Database error: ' . $e->getMessage(); } } } } require_once __DIR__ . '/includes/header.php'; ?>

Join the SubscribeNetwork

Choose the account type that fits you.

', array_map('htmlspecialchars', $errors)) ?>
Already have an account? Sign in