prepare($sql); $stmt->execute($params); $invoices = $stmt->fetchAll(); } catch (PDOException $e) { die("Database error: " . $e->getMessage()); } ?>
| Invoice ID | Order ID | Invoice Date | Due Date | Total Amount | Paid Amount | Balance | Age of Invoice | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| $ | $ | $ | diff($invoice_date)->days; echo $age . ' days'; ?> | View Details |