prepare("SELECT * FROM products WHERE (name LIKE ? OR description LIKE ?) AND is_active = 1"); $searchTerm = "%" . $query . "%"; $stmt->execute([$searchTerm, $searchTerm]); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); // Optional: Log the search keyword for Analytics try { // Create search_logs table if not exists to prevent crash $pdo->query("CREATE TABLE IF NOT EXISTS search_logs (id INT AUTO_INCREMENT PRIMARY KEY, keyword VARCHAR(255), result_count INT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP)"); $logStmt = $pdo->prepare("INSERT INTO search_logs (keyword, result_count) VALUES (?, ?)"); $logStmt->execute([$query, count($results)]); } catch (Exception $e) { /* Silent fail */ } } ?>

Search Results for ""

Found products.

0): ?>

prepare("SELECT MIN(price) as min_price FROM product_variants WHERE product_id = ?"); $pStmt->execute([$product['id']]); $priceData = $pStmt->fetch(); $price = $priceData['min_price'] ? $priceData['min_price'] : 0; // 2. Fix Link Structure $link = "product.php?id=" . $product['id']; ?>

<?php echo htmlspecialchars($product['name']); ?>

Search Results for ""

No products found.