query("SELECT COUNT(*) as count FROM orders");
$totalOrders = $stmt->fetch()['count'];
// Total Revenue
$stmt = $pdo->query("SELECT SUM(total_amount) as sum FROM orders");
$totalRevenue = $stmt->fetch()['sum'] ?? 0;
// Total Products
$stmt = $pdo->query("SELECT COUNT(*) as count FROM products");
$totalProducts = $stmt->fetch()['count'];
// Pending Admins
$stmt = $pdo->query("SELECT COUNT(*) as count FROM users WHERE role = 'admin' AND status = 'pending'");
$pendingAdmins = $stmt->fetch()['count'];
// Recent Orders
$stmt = $pdo->query("SELECT o.*, u.username FROM orders o JOIN users u ON o.user_id = u.id ORDER BY o.created_at DESC LIMIT 5");
$recentOrders = $stmt->fetchAll();
} catch (PDOException $e) {
die("Database Query Error: " . $e->getMessage());
}
?>