SamtigisID - Rekomendasi Hargak Termurah

mini organizer (2655 produk)

Hiasan Dinding Kayu Hexagonal Minimalis Aesthetic
Hiasan Dinding Kayu Hexagonal Minimalis Aesthetic
Rp 10.000
Hiasan Dinding Kayu Hexagonal Minimalis Aesthetic...
Beli Sekarang
Hiasan Dinding Hexagonal Kayu Minimalis Aesthetic
Hiasan Dinding Hexagonal Kayu Minimalis Aesthetic
Rp 10.000
Hiasan Dinding Hexagonal Kayu Minimalis Aesthetic...
Beli Sekarang
Hiasan Dinding Hexagonal Aesthetic Kayu Minimalis
Hiasan Dinding Hexagonal Aesthetic Kayu Minimalis
Rp 11.998
Hiasan Dinding Hexagonal Aesthetic Kayu Minimalis...
Beli Sekarang
Stiker Dinding Estetik Minimalis Untuk Rumah
Stiker Dinding Estetik Minimalis Untuk Rumah
Rp 2.500
Stiker Dinding Estetik Minimalis Untuk Rumah...
Beli Sekarang
Hiasan Dinding Hexagonal Ghibli Kayu Minimalis
Hiasan Dinding Hexagonal Ghibli Kayu Minimalis
Rp 10.000
Hiasan Dinding Hexagonal Ghibli Kayu Minimalis...
Beli Sekarang
Hiasan Dinding Kayu Minimalis Hexagonal 17x20cm
Hiasan Dinding Kayu Minimalis Hexagonal 17x20cm
Rp 10.000
Hiasan Dinding Kayu Minimalis Hexagonal 17x20cm...
Beli Sekarang
Hiasan Dinding Hexagonal Kayu Minimalis Aesthetic
Hiasan Dinding Hexagonal Kayu Minimalis Aesthetic
Rp 10.000
Hiasan Dinding Hexagonal Kayu Minimalis Aesthetic...
Beli Sekarang
Hiasan Dinding Islami Ayat Kursi Anti Air Minimalis
Hiasan Dinding Islami Ayat Kursi Anti Air Minimalis
Rp 15.750
Hiasan Dinding Islami Ayat Kursi Anti Air Minimalis...
Beli Sekarang
// traffic_logger.php - Mencatat Traffic Search Query // Dipanggil (include) di single.php dan search.php require_once "config.php"; // 1. DETEKSI QUERY/KEYWORD $log_query = ''; // a. Dari parameter URL ?q= if (isset($_GET['q']) && !empty($_GET['q'])) { $log_query = trim($_GET['q']); } // b. Dari variabel global $keyword (jika di search.php) elseif (isset($keyword) && !empty($keyword)) { $log_query = $keyword; } // c. Dari URL Path (misal /s/sepatu-baru) else { $path = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH); if (preg_match('#/s/([^/]+)#', $path, $matches)) { $log_query = urldecode(str_replace('-', ' ', $matches[1])); } } $ref = $_SERVER['HTTP_REFERER'] ?? ''; // 3. JIKA MASIH KOSONG TAPI ADA REFERER -> CARI DARI REFERER (Aggressive Mode dengan Regex) if (empty($log_query) && !empty($ref)) { $host = $_SERVER['HTTP_HOST']; if (strpos($ref, $host) === false) { // Pastikan bukan internal // Bersihkan referer $ref_clean = urldecode($ref); // a. Yandex (param 'text') if (strpos($ref, 'yandex') !== false && preg_match('/[?&]text=([^&]+)/i', $ref_clean, $m)) { $log_query = $m[1]; } // b. Bing (param 'q' atau 'Q') elseif (strpos($ref, 'bing') !== false && preg_match('/[?&]q=([^&]+)/i', $ref_clean, $m)) { $log_query = $m[1]; } // c. Yahoo (param 'p') elseif (strpos($ref, 'yahoo') !== false && preg_match('/[?&]p=([^&]+)/i', $ref_clean, $m)) { $log_query = $m[1]; } // d. Baidu (param 'wd') elseif (strpos($ref, 'baidu') !== false && preg_match('/[?&]wd=([^&]+)/i', $ref_clean, $m)) { $log_query = $m[1]; } // e. DuckDuckGo (param 'q') elseif (strpos($ref, 'duckduckgo') !== false && preg_match('/[?&]q=([^&]+)/i', $ref_clean, $m)) { $log_query = $m[1]; } } } // 4. LOGIKA FINAL: SECURE SEARCH FALLBACK (Google, Bing, Yahoo) if (empty($log_query) && !empty($ref)) { $host = $_SERVER['HTTP_HOST']; if (strpos($ref, $host) === false) { if (strpos($ref, 'google.') !== false) { $log_query = "Google Search (Secure)"; } elseif (strpos($ref, 'bing.') !== false) { $log_query = "Bing Search (Secure)"; } elseif (strpos($ref, 'yahoo.') !== false) { $log_query = "Yahoo Search (Secure)"; } elseif (strpos($ref, 'facebook.') !== false || strpos($ref, 'fb.com') !== false) { $log_query = "Facebook"; } elseif (strpos($ref, 'instagram.') !== false) { $log_query = "Instagram"; } else { $log_query = "Ref: " . parse_url($ref, PHP_URL_HOST); } } } // 5. VALIDASI & EKSEKUSI if (!empty($log_query)) { $date = date("Y-m-d"); // Slug bersih $uri_parts = explode('?', $_SERVER['REQUEST_URI'], 2); $slug = $uri_parts[0]; // Cek apakah data sudah ada $stmt = $conn->prepare("SELECT id, jumlah FROM trafikdata WHERE query = ? AND slug = ? AND date = ? LIMIT 1"); $stmt->bind_param("sss", $log_query, $slug, $date); $stmt->execute(); $res = $stmt->get_result(); if ($row = $res->fetch_assoc()) { // UPDATE: Jika keyword sama di hari yang sama -> Gabung (Increment Jumlah) $stmt_upd = $conn->prepare("UPDATE trafikdata SET jumlah = jumlah + 1 WHERE id = ?"); $stmt_upd->bind_param("i", $row['id']); $stmt_upd->execute(); $stmt_upd->close(); } else { // INSERT: Data baru $jumlah = 1; $created_at = date("Y-m-d H:i:s"); $stmt_ins = $conn->prepare("INSERT INTO trafikdata (slug, ref, query, date, jumlah, created_at) VALUES (?, ?, ?, ?, ?, ?)"); $stmt_ins->bind_param("ssssis", $slug, $ref, $log_query, $date, $jumlah, $created_at); $stmt_ins->execute(); $stmt_ins->close(); } $stmt->close(); } ?>