prepare("SELECT COUNT(*) FROM orders WHERE $where"); $count_stmt->execute($params); $total = $count_stmt->fetchColumn(); $total_pages = ceil($total / $per_page); $stmt = $db->prepare("SELECT * FROM orders WHERE $where ORDER BY created_at DESC LIMIT $per_page OFFSET $offset"); $stmt->execute($params); $orders = $stmt->fetchAll(); ?>

All Orders ()

All Pending Processing Shipped Delivered Cancelled

prepare("SELECT COUNT(*) FROM order_items WHERE order_id = ?"); $items->execute([$order['id']]); $item_count = $items->fetchColumn(); ?>

Order #	Customer	Items	Total	Payment	Status	Date	Action
		items

1): ?>