connect_error) { die("

Database connection failed. Please check your db.php file and admin/header.php include path.

"); } // --- DYNAMIC DATA FETCHING FOR ADMIN --- // 1. Fetch Total Users $totalUsers = 0; $result_users = $conn->query("SELECT COUNT(id) as user_count FROM users"); if ($result_users) { $totalUsers = $result_users->fetch_assoc()['user_count']; } // 2. Fetch Total Artists $totalArtists = 0; $result_artists = $conn->query("SELECT COUNT(id) as artist_count FROM users WHERE role = 'artist'"); if ($result_artists) { $totalArtists = $result_artists->fetch_assoc()['artist_count']; } // 3. Fetch Total Paintings $totalPaintings = 0; $result_paintings = $conn->query("SELECT COUNT(id) as painting_count FROM paintings"); if ($result_paintings) { $totalPaintings = $result_paintings->fetch_assoc()['painting_count']; } // 4. Fetch Total Sales Revenue $totalSales = 0; $result_sales = $conn->query("SELECT SUM(total_amount) as total_revenue FROM orders WHERE payment_status = 'completed'"); if ($result_sales) { $totalSalesData = $result_sales->fetch_assoc(); $totalSales = $totalSalesData['total_revenue'] ?? 0; } ?>

Admin Dashboard

Overview of the United Cultural Forum platform.

Total Users

Registered Artists

Total Paintings

Total Revenue

₹

Quick Actions

Manage Users Manage Competitions Manage Articles

Platform Analytics

Graphs and recent activity logs will be displayed here in a future update.