prepare("SELECT COUNT(*) FROM `listings` WHERE $where_sql"); $count_stmt->execute($sql_params); $total_listings = $count_stmt->fetchColumn(); $total_pages = ceil($total_listings / $limit); // Get listings with category and country details $listings_sql = "SELECT l.*, c.name AS category_name, co.name AS country_name, co.code AS country_code FROM `listings` l JOIN `categories` c ON l.category_id = c.id JOIN `countries` co ON l.country_id = co.id WHERE $where_sql ORDER BY (l.pinned_until IS NOT NULL AND l.pinned_until > NOW()) DESC, $order_sql LIMIT $limit OFFSET $offset"; $listings_stmt = $pdo->prepare($listings_sql); $listings_stmt->execute($sql_params); $listings = $listings_stmt->fetchAll(); // Fetch categories and countries for filter dropdowns $all_categories = $pdo->query("SELECT * FROM `categories` ORDER BY `name` ASC")->fetchAll(); $all_countries = $pdo->query("SELECT * FROM `countries` ORDER BY `name` ASC")->fetchAll(); } catch (PDOException $e) { die("Database query error: " . $e->getMessage()); } // AJAX JSON Responder for listings and pagination HTML fragments if ($is_ajax) { header('Content-Type: application/json'); // Render the grid items ob_start(); if (empty($listings)) { ?>

sentiment_dissatisfied

No Groups Found

Try adjusting your filters or search query.

1) { $initials .= mb_strtoupper(mb_substr($words[1], 0, 1)); } $is_pinned = !empty($listing['pinned_until']) && strtotime($listing['pinned_until']) > time(); ?>

star

<?php echo htmlspecialchars($listing['title']); ?>

location_on

favorite

schedule

View Group arrow_forward

1) { ?>

1): ?> arrow_back Prev Page of Next arrow_forward

true, 'html' => $html_content, 'pagination' => $pagination_content ]); exit; } // Set dynamic page title $page_title = "Find WhatsApp & Telegram Invite Links"; require_once 'header.php'; ?>

add_circle Add Group or Channel Link

ads_click

Leaderboard 728 x 90