prepare($count_sql);
$stmt->execute($params);
$total_users = $stmt->fetchColumn();
$total_pages = ceil($total_users / $limit);
// Get users for the current page
$sql .= " ORDER BY 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();
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
error_log($e->getMessage());
// Handle error, maybe show a message
}
?>
awallwt - Users Management
| ID |
Nickname |
Telegram ID |
Rating |
Verified |
Role |
Registered At |
Actions |
| No users found. |
|
|
|
|
|
|
|
View
Block
|
1): ?>