prepare($count_sql); foreach ($params as $key => $val) { $count_stmt->bindValue($key, $val); } $count_stmt->execute(); $total_rows = $count_stmt->fetchColumn(); $total_pages = ceil($total_rows / $limit); // Fetch orders $sql = "SELECT * FROM orders $where_clause ORDER BY created_at DESC LIMIT :limit OFFSET :offset"; $stmt = $pdo->prepare($sql); foreach ($params as $key => $val) { $stmt->bindValue($key, $val); } $stmt->bindValue(':limit', $limit, PDO::PARAM_INT); $stmt->bindValue(':offset', $offset, PDO::PARAM_INT); $stmt->execute(); $orders = $stmt->fetchAll(); } catch (PDOException $e) { die("Database query error: " . $e->getMessage()); } include '../includes/admin_header.php'; ?>
Reset
All Orders Pending Confirmed Processing Completed Cancelled
Order No Customer Details Specs & Size Date & Time Quick Status Update Actions
No matching orders found.
Ph:
Email:
Curtain:
Fabric:
Size: "W × "H (Qty: )
1): ?>
Showing to of orders