Dashboard - SejiStore Admin

query("SELECT SUM(total_amount) FROM orders"); $earnings = $stmt->fetchColumn(); $total_earnings = $earnings ? number_format($earnings, 2) : "0.00"; } catch(Exception $e) { $total_earnings = "0.00"; } // 2. Counts $total_orders = $pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn(); $total_products = $pdo->query("SELECT COUNT(*) FROM products")->fetchColumn(); $total_users = $pdo->query("SELECT COUNT(*) FROM users WHERE role != 'admin'")->fetchColumn(); // 3. Recent Orders $stmt_orders = $pdo->query("SELECT * FROM orders ORDER BY id DESC LIMIT 5"); $recent_orders = $stmt_orders->fetchAll(PDO::FETCH_ASSOC); ?> Dashboard - SejiStore Admin

Dashboard Overview

Total Earnings

₹

Total Sales

Active Products

Total Customers

Recent Transactions

View All

0): ?>

Order ID	Customer	Amount	Date	Status
#		₹
No recent orders found.