PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]); function h($s) { return htmlspecialchars((string)($s ?? ''), ENT_QUOTES|ENT_HTML5, 'UTF-8'); } // Categories in display order $CATS = [ 'vps' => ['VPS', 'πŸ–₯', 'Virtual Private Servers'], 'dedicated' => ['Dedicated', 'πŸ—„', 'Bare-metal & colocation'], 'cdn' => ['CDN', '🌐', 'Content delivery & edge'], 'payment' => ['Payments', 'πŸ’³', 'Cross-border & virtual cards'], 'proxy' => ['Proxies', 'πŸ”Œ', 'Residential / DC / mobile'], 'domain' => ['Domains', '🌍', 'Registrars & TLDs'], 'saas' => ['SaaS', 'βš™', 'Productivity tools'], 'ai' => ['AI Apps', 'πŸ€–', 'LLMs, APIs & agents'], 'edu' => ['Education', 'πŸ“š', 'Courses & MOOCs'], 'dev' => ['Dev Tools', 'πŸ”§', 'APIs, SDKs, DevOps'], 'crypto' => ['Crypto', 'πŸ’°', 'Exchanges, wallets, DeFi'], 'marketing' => ['Marketing & SEO', 'πŸ“ˆ', 'SEO, ads, analytics'], 'design' => ['Design & Creative', '🎨', 'UI/UX & stock assets'], 'security' => ['Security', 'πŸ›‘', 'SSL, IAM, pen-test'], 'biz' => ['Incorp & Compliance', 'πŸ“‹', 'Company formation & tax'], 'comm' => ['Comms & Email', 'βœ‰', 'Email, SMS, OTP'], 'ec' => ['E-commerce', 'πŸ›’', 'Shopify, dropshipping'], ]; // Category counts (live) $cat_counts = []; foreach ($pdo->query("SELECT category, COUNT(*) AS n FROM listings WHERE is_active=1 GROUP BY category")->fetchAll() as $r) { $cat_counts[$r['category']] = (int)$r['n']; } $total_all = array_sum($cat_counts); // Total review count (live) $total_reviews = (int)$pdo->query("SELECT COUNT(*) FROM listings WHERE is_active=1 AND review_cn IS NOT NULL AND review_cn <> ''")->fetchColumn(); // Top-rated providers per category (1-2 per cat, rating_avg DESC, hi review_count tiebreak) $top_rated_sql = " SELECT id, provider, plan_name, category, sub_category, hq_country, price_monthly_usd, rating_avg, review_count, cn_friendly, badge FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY category ORDER BY rating_avg DESC, review_count DESC) AS rn FROM listings WHERE is_active=1 AND rating_avg >= 7 ) t WHERE rn <= 2 ORDER BY rating_avg DESC, review_count DESC LIMIT 24 "; try { $top_rated = $pdo->query($top_rated_sql)->fetchAll(); } catch (Throwable $e) { // MariaDB without window functions: fallback to plain ORDER BY $top_rated = $pdo->query("SELECT id, provider, plan_name, category, sub_category, hq_country, price_monthly_usd, rating_avg, review_count, cn_friendly, badge FROM listings WHERE is_active=1 AND rating_avg >= 8 ORDER BY rating_avg DESC, review_count DESC LIMIT 24")->fetchAll(); } // Most recently added $recent = $pdo->query("SELECT id, provider, plan_name, category, sub_category, rating_avg, price_monthly_usd FROM listings WHERE is_active=1 ORDER BY id DESC LIMIT 12")->fetchAll(); // Dataset last updated (for header chrome) $dataset_updated = $pdo->query("SELECT MAX(updated_at) FROM listings WHERE is_active=1")->fetchColumn(); // SEO $site_title = t('site_title_en'); $site_desc = t('site_desc_en'); $canonical = 'https://tg4g.com/en/'; $zh_alt = 'https://tg4g.com/'; // JSON-LD: WebSite + ItemList (top picks) $site_ld = [ '@context' => 'https://schema.org', '@type' => 'WebSite', 'name' => 'TG4G - Overseas SaaS & Infra Reviews', 'url' => $canonical, 'inLanguage' => 'en', 'description' => $site_desc, 'potentialAction' => [ '@type' => 'SearchAction', 'target' => 'https://tg4g.com/en/listings?q={search_term_string}', 'query-input' => 'required name=search_term_string', ], ]; $itemlist_ld = [ '@context' => 'https://schema.org', '@type' => 'ItemList', 'name' => 'Top-rated overseas providers', 'inLanguage' => 'en', 'itemListElement' => array_map(function ($i, $r) { return [ '@type' => 'ListItem', 'position' => $i + 1, 'url' => 'https://tg4g.com/en/listing/' . (int)$r['id'], 'name' => $r['provider'], ]; }, array_keys($top_rated), $top_rated), ]; ?> <?= h($site_title) ?>
πŸš€ TG4G Overseas SaaS & Infra Reviews
Directory VPS Payments AI Browse all EN δΈ­

Vendors tracked
+
In-depth reviews
17
Categories
β˜…β˜…β˜…
China-access rating
β†’ Top VPS providers Payment & virtual cards

πŸ“‚ ( categories)

Each category has its own filter profile (network type, datacenter, HQ, price, China-friendliness) tuned for that domain.

[$lbl, $ic, $desc]): $cnt = $cat_counts[$k] ?? 0; ?>
entries β†’

What makes TG4G different

⭐ (rating β‰₯ 7.0)

Top-rated overseas providers across all 17 categories, sorted by rating and review count.

β˜…
HQ:
0): ?> $ / mo Pricing varies 0): ?> CN
View details β†’

πŸ†• Recently added

Latest provider entries β€” directory refreshed daily.

Β· /
0): ?>β˜… Β· 0): ?>$/mo