query($sql); $totalInvoices = 0; if ($result && $result->num_rows > 0) { $row = $result->fetch_assoc(); $totalInvoices = $row['total']; } // Get total amount of all invoices $sql = "SELECT SUM(total_amount) as total_sum FROM invoices"; $result = $conn->query($sql); $totalAmount = 0; if ($result && $result->num_rows > 0) { $row = $result->fetch_assoc(); $totalAmount = $row['total_sum']; } // Get recent invoices $sql = "SELECT id, invoice_no, invoice_date, consignee_name, total_amount FROM invoices ORDER BY created_at DESC LIMIT 10"; $result = $conn->query($sql); require_once('includes/header.php'); ?>

Total Invoices

Total Amount

₹

Recent Invoices

Create New Invoice

num_rows > 0): ?> fetch_assoc()): ?>

Invoice No.	Date	Consignee	Amount	Actions
			₹	View

No invoices found. Create your first invoice.