PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]); // ============ Category profiles (English labels via t()) ============ $PROFILES = [ 'vps' => [ 'label' => 'VPS', 'icon' => '🖥', 'desc' => t('cat_desc.vps'), 'filters' => ['search','network','location','config','price','rating','cn','refund','pay'], 'cols' => ['fav','provider','network','cpu','ram','disk','bw','location','price','rating','cn','pay','source','updated','cta'], 'sort' => 'price_monthly_usd', 'quick_subs' => ['KVM','OpenVZ','LXC','Web Hosting','VPS','Cloud VPS','Shared Hosting','Dedicated Servers','Proxy Hosting','Domain Registration'], ], 'dedicated' => [ 'label' => 'Dedicated', 'icon' => '🗄', 'desc' => t('cat_desc.dedicated'), 'filters' => ['search','location','config','price','rating','pay'], 'cols' => ['fav','provider','cpu','ram','disk','bw','location','price','rating','pay','source','updated','cta'], 'sort' => 'price_monthly_usd', 'quick_subs' => ['Intel','AMD','GPU','Storage','High-bandwidth','Colocation'], ], 'cdn' => [ 'label' => 'CDN', 'icon' => '🌐', 'desc' => t('cat_desc.cdn'), 'filters' => ['search','price','rating','pay'], 'cols' => ['fav','provider','location','price','rating','pay','source','updated','cta'], 'sort' => 'price_monthly_usd', 'quick_subs' => ['CDN','Content Delivery','DDoS Protection','Edge Compute','Static Acceleration','Video CDN'], ], 'payment' => [ 'label' => 'Payments', 'icon' => '💳', 'desc' => t('cat_desc.payment'), 'filters' => ['search','sub','hq','rating'], 'cols' => ['fav','provider','sub','hq','price','rating','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Payment Processor','Payment Gateway','Virtual Card','Crypto Payments','Retail Banking','Neobank','Insurance','Wealth Management'], ], 'proxy' => [ 'label' => 'Proxies', 'icon' => '🔌', 'desc' => t('cat_desc.proxy'), 'filters' => ['search','sub','hq','price','rating'], 'cols' => ['fav','provider','sub','hq','price','rating','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Residential Proxy','Datacenter Proxy','Mobile Proxy','Rotating Proxy','VPN','SOCKS5'], ], 'domain' => [ 'label' => 'Domains', 'icon' => '🌍', 'desc' => t('cat_desc.domain'), 'filters' => ['search','price','rating','pay'], 'cols' => ['fav','provider','price','rating','pay','source','updated','cta'], 'sort' => 'price_yearly_usd', 'quick_subs' => ['Domain Registration','Domain Registrar','Auction','Parking','Transfer-in','TLD','SSL Certificate'], ], 'saas' => [ 'label' => 'SaaS', 'icon' => '⚙', 'desc' => t('cat_desc.saas'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['CRM','Project Management','Email Marketing','Customer Support','HR','Accounting','Collaboration','Documents','Video Conferencing','Property Mgmt','Event Mgmt','Web Hosting','Digital Agency','Web Dev'], ], 'ai' => [ 'label' => 'AI Apps', 'icon' => '🤖', 'desc' => t('cat_desc.ai'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['LLM','API','AI Chat','AI Writing','AI Image','AI Voice','AI Video','ML','Automation','Agent'], ], 'edu' => [ 'label' => 'Education', 'icon' => '📚', 'desc' => t('cat_desc.edu'), 'filters' => ['search','sub','hq','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Programming','Design','Business','Language','Exam Prep','Online Courses','MOOC','Tutoring','Academic','Early Education'], ], 'dev' => [ 'label' => 'Dev Tools', 'icon' => '🔧', 'desc' => t('cat_desc.dev'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Frontend','Backend','Mobile App','DevOps','API','SDK','Database','Testing','Monitoring','Version Control','Low-code','WordPress','AI Coding','Web Dev'], ], 'crypto' => [ 'label' => 'Crypto', 'icon' => '💰', 'desc' => t('cat_desc.crypto'), 'filters' => ['search','sub','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Exchange','Wallet','Lending','Staking','NFT','Analytics','Explorer','Meme','Airdrop','DeFi','Derivatives'], ], 'marketing' => [ 'label' => 'Marketing & SEO', 'icon' => '📈', 'desc' => t('cat_desc.marketing'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['SEO','Digital Marketing','Performance Marketing','Content Marketing','Email Marketing','Social Media','Affiliate','Cashback','Ads','Influencer'], ], 'design' => [ 'label' => 'Design & Creative', 'icon' => '🎨', 'desc' => t('cat_desc.design'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['UI Design','UX Design','Logo','Graphic Design','Video Editing','Photo Editing','3D','Fonts','Illustration','Stock Assets','Prototyping'], ], 'security' => [ 'label' => 'Security', 'icon' => '🛡', 'desc' => t('cat_desc.security'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['SSL','Firewall','Password Mgr','2FA','Antivirus','Pen Testing','IAM','DDoS','Audit'], ], 'biz' => [ 'label' => 'Incorp & Compliance', 'icon' => '📋', 'desc' => t('cat_desc.biz'), 'filters' => ['search','sub','hq','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Company Registration','Business License','Virtual Address','Registered Agent','Offshore','Compliance','Accounting','Tax Filing','Legal'], ], 'comm' => [ 'label' => 'Comms & Email', 'icon' => '✉', 'desc' => t('cat_desc.comm'), 'filters' => ['search','sub','price','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Email','SMS','OTP','VoIP','IM','Video Conferencing','Newsletter','Support'], ], 'ec' => [ 'label' => 'E-commerce', 'icon' => '🛒', 'desc' => t('cat_desc.ec'), 'filters' => ['search','sub','rating','cn'], 'cols' => ['fav','provider','sub','hq','price','rating','cn','source','updated','cta'], 'sort' => 'rating_avg', 'quick_subs' => ['Shopify','Standalone Store','Cross-border','Dropshipping','Apparel','Beauty','Electronics','Home Goods','Auto Parts','Pets','Food Delivery','Restaurants','Jewelry','Furniture'], ], ]; // ============ Params (mirror of Chinese version) ============ $cat = $_GET['cat'] ?? 'vps'; if (!isset($PROFILES[$cat])) $cat = 'vps'; $profile = $PROFILES[$cat]; $sub = $_GET['sub'] ?? ''; $nets = (array)($_GET['net'] ?? []); $countries = (array)($_GET['country'] ?? []); $hqs = (array)($_GET['hq'] ?? []); $pays = (array)($_GET['pay'] ?? []); $disktype = $_GET['disk_type'] ?? ''; $cpu_min = isset($_GET['cpu']) ? (int)$_GET['cpu'] : 0; $ram_min = isset($_GET['ram']) ? (float)$_GET['ram'] : 0; $disk_min = isset($_GET['disk']) ? (int)$_GET['disk'] : 0; $bw_min = isset($_GET['bw']) ? (float)$_GET['bw'] : 0; $price_min = isset($_GET['p_min']) ? (float)$_GET['p_min'] : 0; $price_max = isset($_GET['p_max']) ? (float)$_GET['p_max'] : 0; $rating_min = isset($_GET['rating']) ? (float)$_GET['rating'] : 0; $refund_min = isset($_GET['refund']) ? (int)$_GET['refund'] : 0; $cn_min = isset($_GET['cn']) ? (int)$_GET['cn'] : 0; $q = trim((string)($_GET['q'] ?? '')); $sort = $_GET['sort'] ?? $profile['sort']; $dir = ($_GET['dir'] ?? 'asc') === 'desc' ? 'desc' : 'asc'; $page = max(1, (int)($_GET['page'] ?? 1)); $per = min(500, max(10, (int)($_GET['per'] ?? 50))); $export = $_GET['export'] ?? ''; $sort_white = ['price_monthly_usd','price_yearly_usd','provider','cpu_cores','ram_gb','disk_gb','bandwidth_tb','rating_avg','review_count','refund_days','plan_name','network','location_country','cn_friendly','updated_at','id']; if (!in_array($sort, $sort_white, true)) $sort = $profile['sort']; // ============ WHERE ============ $where = ['is_active = 1', 'category = :cat']; $params = [':cat' => $cat]; if ($sub !== '') { $where[] = 'sub_category LIKE :sub'; $params[':sub'] = '%' . $sub . '%'; } foreach (['net'=>['network',$nets,'LIKE'], 'country'=>['location_country',$countries,'='], 'hq'=>['hq_country',$hqs,'='], 'pay'=>['payment_methods',$pays,'LIKE']] as $pfx => [$col,$vals,$op]) { if (!$vals) continue; $ph = []; foreach ($vals as $i => $v) { $key = ":{$pfx}{$i}"; if ($op === 'LIKE') { $ph[] = "$col LIKE $key"; $params[$key] = '%'.$v.'%'; } else { $ph[] = "$col = $key"; $params[$key] = $v; } } $where[] = '(' . implode(' OR ', $ph) . ')'; } if ($disktype !== '') { $where[] = 'disk_type = :dt'; $params[':dt'] = $disktype; } if ($cpu_min > 0) { $where[] = 'cpu_cores >= :cpum'; $params[':cpum'] = $cpu_min; } if ($ram_min > 0) { $where[] = 'ram_gb >= :ramm'; $params[':ramm'] = $ram_min; } if ($disk_min > 0) { $where[] = 'disk_gb >= :diskm'; $params[':diskm'] = $disk_min; } if ($bw_min > 0) { $where[] = 'bandwidth_tb >= :bwm';$params[':bwm'] = $bw_min; } if ($price_min > 0) { $where[] = 'price_monthly_usd >= :pmin'; $params[':pmin'] = $price_min; } if ($price_max > 0) { $where[] = 'price_monthly_usd > 0 AND price_monthly_usd <= :pmax'; $params[':pmax'] = $price_max; } if ($rating_min > 0){ $where[] = 'rating_avg >= :ratm'; $params[':ratm'] = $rating_min; } if ($refund_min > 0){ $where[] = 'refund_days >= :rfdm'; $params[':rfdm'] = $refund_min; } if ($cn_min > 0) { $where[] = 'cn_friendly >= :cnm'; $params[':cnm'] = $cn_min; } if ($q !== '') { $where[] = '(provider LIKE :q OR plan_name LIKE :q OR notes LIKE :q)'; $params[':q'] = '%'.$q.'%'; } $where_sql = implode(' AND ', $where); // Counts $st = $pdo->prepare("SELECT COUNT(*) AS n FROM listings WHERE $where_sql"); $st->execute($params); $total = (int)$st->fetch()['n']; $pages = max(1, (int)ceil($total / $per)); if ($page > $pages) $page = $pages; $offset = ($page - 1) * $per; $st = $pdo->prepare("SELECT * FROM listings WHERE $where_sql ORDER BY ($sort = 0) ASC, $sort $dir, id ASC LIMIT $per OFFSET $offset"); $st->execute($params); $rows = $st->fetchAll(); // ============ CSV export ============ if ($export === 'csv') { $st2 = $pdo->prepare("SELECT * FROM listings WHERE $where_sql ORDER BY ($sort = 0) ASC, $sort $dir, id ASC"); $st2->execute($params); $all = $st2->fetchAll(); header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename="tg4g_en_' . $cat . '_' . date('Ymd_His') . '.csv"'); echo "\xEF\xBB\xBF"; $out = fopen('php://output', 'w'); $hdr_cols = ['id','category','sub_category','provider','hq_country','plan_name','network','cpu_cores','cpu_model','ram_gb','disk_gb','disk_type','bandwidth_tb','port_mbps','location_country','location_city','price_display','price_monthly_usd','price_yearly_usd','payment_methods','refund_days','virt_type','os_supported','rating_avg','review_count','cn_friendly','data_source','badge','notes','affiliate_url','official_url','updated_at']; fputcsv($out, $hdr_cols); foreach ($all as $r) { $line = []; foreach ($hdr_cols as $col) $line[] = $r[$col] ?? ''; fputcsv($out, $line); } fclose($out); exit; } // ============ Metadata for facets ============ function dcol($pdo, $col, $cat) { $st = $pdo->prepare("SELECT DISTINCT $col AS v FROM listings WHERE is_active=1 AND category=:c AND $col IS NOT NULL AND $col<>'' ORDER BY $col"); $st->execute([':c' => $cat]); return array_column($st->fetchAll(), 'v'); } $all_nets = dcol($pdo, 'network', $cat); $all_loc_countries = dcol($pdo, 'location_country', $cat); $all_hq_countries = dcol($pdo, 'hq_country', $cat); $all_disktypes = dcol($pdo, 'disk_type', $cat); $all_subs = dcol($pdo, 'sub_category', $cat); $cat_counts_st = $pdo->query("SELECT category, COUNT(*) AS n FROM listings WHERE is_active=1 GROUP BY category"); $cat_counts = []; foreach ($cat_counts_st->fetchAll() as $r) $cat_counts[$r['category']] = (int)$r['n']; $last_st = $pdo->query("SELECT MAX(updated_at) AS latest FROM listings WHERE is_active=1"); $dataset_updated = $last_st->fetch()['latest'] ?? ''; $sub_counts = []; $sc_st = $pdo->prepare("SELECT sub_category AS s, COUNT(*) AS n FROM listings WHERE is_active=1 AND category=:c GROUP BY sub_category"); $sc_st->execute([':c' => $cat]); foreach ($sc_st->fetchAll() as $r) $sub_counts[$r['s']] = (int)$r['n']; // ============ Helpers ============ function h($s) { return htmlspecialchars((string)($s ?? ''), ENT_QUOTES|ENT_HTML5, 'UTF-8'); } function build_url($overrides = []) { $qs = array_merge($_GET, $overrides); foreach ($overrides as $k => $v) if ($v === '' || $v === null || $v === []) unset($qs[$k]); return '/en/listings?' . http_build_query($qs); } function sl($field, $label, $cs, $cd) { $nd = ($cs === $field && $cd === 'asc') ? 'desc' : 'asc'; $arr = ($cs === $field) ? ($cd === 'asc' ? ' ▲' : ' ▼') : ''; return '' . h($label) . $arr . ''; } function fmt_price($r) { if ($r['price_monthly_usd'] > 0) return '$' . number_format((float)$r['price_monthly_usd'], 2); if ($r['price_display']) return h($r['price_display']); return '-'; } function cn_stars($n) { $n = (int)$n; if ($n <= 0) return '-'; return str_repeat('★', $n) . str_repeat('☆', max(0, 3 - $n)); } $net_class = function($n) { if (str_contains($n ?: '', 'CN2 GIA')) return 'n-cn2gia'; if (str_contains($n ?: '', 'CN2')) return 'n-cn2gt'; if (str_contains($n ?: '', 'BGP')) return 'n-bgp'; if (str_contains($n ?: '', 'Anycast')) return 'n-anycast'; return 'n-other'; }; // Build hreflang pairs for current URL (en here, zh-CN sibling) $qs_no_path = $_GET; $zh_url = 'https://tg4g.com/listings?' . http_build_query($qs_no_path); $en_url = 'https://tg4g.com/en/listings?' . http_build_query($qs_no_path); ?> <?= h($profile['label']) ?> Directory - <?= number_format($total) ?> filterable entries | TG4G
🚀 TG4G $pcv): $active = $cat === $pck; $cnt = $cat_counts[$pck] ?? 0; ?>
EN 中
:

()

: $n): if(!$s) continue; ?> ✕ Clear []
📌 :
⬇
- Pay 'Alipay','usdt'=>'USDT','paypal'=>'PayPal','cc'=>'Card','wire'=>'Wire','btc'=>'BTC'] as $pk => $pl): ?>
· / ·
'', 'provider' => '', 'sub' => '', 'hq' => '', 'network' => '', 'cpu' => '', 'ram' => '', 'disk' => '', 'bw' => '', 'location' => '', 'price' => '', 'rating' => '', 'cn' => '', 'refund' => '', 'pay' => '', 'virt' => '', 'os' => '', 'source' => '', 'updated' => '', 'cta' => '', ]; foreach ($profile['cols'] as $c) echo $col_headers[$c] ?? ''; ?>
' . h(t('商家/套餐')) . '' . h(t('类型')) . '' . h(t('总部')) . '' . h(t('网络')) . '' . sl('cpu_cores','CPU',$sort,$dir) . '' . sl('ram_gb','RAM',$sort,$dir) . '' . sl('disk_gb','Disk',$sort,$dir) . '' . sl('bandwidth_tb','BW',$sort,$dir) . '' . sl('location_country','DC',$sort,$dir) . '' . sl('price_monthly_usd','Monthly',$sort,$dir) . '' . sl('rating_avg','Rating',$sort,$dir) . '' . sl('cn_friendly','CN',$sort,$dir) . '' . sl('refund_days','Refund',$sort,$dir) . 'PayVirtOSSrc' . sl('updated_at','Updated',$sort,$dir) . 'Buy
· HQ
0):?> C
0): echo ''.((float)$r['ram_gb']>=1 ? (int)$r['ram_gb'].'G' : (int)($r['ram_gb']*1024).'M').''; else: echo '-'; endif;?> 0):?> =1000 ? round($r['disk_gb']/1000,1).'T' : (int)$r['disk_gb'].'G' ?>
0 && $r['bandwidth_tb']<9000):?> =1 ? (int)$r['bandwidth_tb'].'T' : (int)($r['bandwidth_tb']*1000).'G' ?> =9000): echo '∞'; else: echo '-'; endif;?> 0):?>
=1000 ? round($r['port_mbps']/1000).'G' : $r['port_mbps'].'M' ?>
0):?>$/yr 0?number_format((float)$r['rating_avg'],1):'-' ?>0):?>
 0) echo (int)$r['refund_days'].'d'; elseif(in_array($r['category'],['vps','dedicated'],true)) echo ''.h(t('不退')).''; else echo '-'; ?> BuyContact
No matching entries. Clear filters and retry
1):?>
: tg4g@duck.com · 中文版