query("SELECT COUNT(*) FROM `campaigns` WHERE `status` = 'active'")->fetchColumn(); $total_raised = $pdo->query("SELECT SUM(`collected_amount`) FROM `campaigns`")->fetchColumn() ?: 0; $count_users = $pdo->query("SELECT COUNT(*) FROM `users`")->fetchColumn(); // Fetch featured/recent campaigns $featured_stmt = $pdo->query("SELECT c.*, u.company_name, u.first_name, u.last_name FROM `campaigns` c JOIN `users` u ON c.creator_id = u.id WHERE c.status = 'active' OR c.featured = 1 ORDER BY c.featured DESC, c.created_at DESC LIMIT 3"); $featured = $featured_stmt->fetchAll(); // Fetch successful campaigns $success_stmt = $pdo->query("SELECT c.*, u.company_name, u.first_name, u.last_name FROM `campaigns` c JOIN `users` u ON c.creator_id = u.id WHERE c.status = 'successful' ORDER BY c.end_date DESC LIMIT 3"); $successful_camps = $success_stmt->fetchAll(); // Fetch recent blog posts $blog_stmt = $pdo->query("SELECT p.*, u.username, u.first_name, u.last_name FROM `posts` p JOIN `users` u ON p.author_id = u.id ORDER BY p.created_at DESC LIMIT 3"); $recent_posts = $blog_stmt->fetchAll(); // Fetch FAQs $faq_stmt = $pdo->query("SELECT * FROM `faqs` ORDER BY `sort_order` ASC LIMIT 5"); $homepage_faqs = $faq_stmt->fetchAll(); // Fetch Page Sections configuration for dynamic homepage rendering $sections_stmt = $pdo->prepare("SELECT * FROM `page_sections` WHERE `page_name` = 'home' AND `is_active` = 1 ORDER BY `sort_order` ASC"); $sections_stmt->execute(); $homepage_sections = $sections_stmt->fetchAll(); require_once __DIR__ . '/includes/head.php'; require_once __DIR__ . '/includes/header.php'; ?>

طرح‌های فعال طرح

حامیان و شرکا کاربر

سرمایه جمع شده ریال

کشف طرح‌های سرمایه‌گذاری ثبت کمپین جدید