prepare($count_sql);
$stmt->execute($params);
$total_orders = $stmt->fetchColumn();
$total_pages = ceil($total_orders / $limit);
// Get orders for the current page
$sql .= " ORDER BY o.created_at DESC LIMIT :limit OFFSET :offset";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
if (!empty($search)) {
$stmt->bindValue(':search', '%' . $search . '%');
}
$stmt->execute();
$orders = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
error_log($e->getMessage());
}
?>
awallwt - Deals Management
| ID |
Ad ID |
Buyer |
Seller |
Crypto |
Fiat |
Status |
Created At |
Actions |
| No deals found. |
|
|
|
|
|
|
|
|
View
|
1): ?>