Jual Handmade rattan di Riau | SamtigisID

SamtigisID - Rekomendasi Hargak Termurah

Handmade rattan di Riau (127 produk)

Tempat Pencil Meja Belajar Aesthetic Handmade

Tempat Pencil Meja Belajar Aesthetic Handmade

Rp 34.500

Tempat Pencil Meja Belajar Aesthetic Handmade...

Cincin Perak Custom Handmade Zircon Microsetting

Cincin Perak Custom Handmade Zircon Microsetting Riau

Rp 750.000

Cincin Perak Custom Handmade Zircon Microsetting...

Sendal Terompah Habib Salaf Putih Handmade Nyaman

Sendal Terompah Habib Salaf Putih Handmade Nyaman Riau

Rp 145.000

Sendal Terompah Habib Salaf Putih Handmade Nyaman...

Sandal Birken Unisex Putih Premium Stylish || Sandal Selop Unisex Putih Handmade Fashionable

Sandal Birken Unisex Putih Premium Stylish || Sandal Selop Unisex Putih Handmade Fashionable Riau

Rp 959.000

Sandal Birken Unisex Putih Premium Stylish || Sandal Selop Unisex Putih Handmade Fashionable...

Sandal Kulit Wanita Selop Tan Krem Hitam Raden || Sandal Kulit Wanita Selop Handmade Magetan

Sandal Kulit Wanita Selop Tan Krem Hitam Raden || Sandal Kulit Wanita Selop Handmade Magetan Riau

Rp 73.000

Sandal Kulit Wanita Selop Tan Krem Hitam Raden || Sandal Kulit Wanita Selop Handmade Magetan...

Sandal Kulit Wanita Handmade Magetan Anti Slip

Sandal Kulit Wanita Handmade Magetan Anti Slip Riau

Rp 77.000

Sandal Kulit Wanita Handmade Magetan Anti Slip...

Sandal Kulit Wanita Handmade Magetan Anti Slip

Sandal Kulit Wanita Handmade Magetan Anti Slip

Rp 77.000

Sandal Kulit Wanita Handmade Magetan Anti Slip...

‹ 1 2 3 4 5 ›

// 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(); } ?>