prepare("SELECT id FROM categories WHERE slug = ?"); $catStmt->execute([$category]); $cat = $catStmt->fetch(); if ($cat) { $where[] = "category_id = ?"; $params[] = $cat['id']; } } if ($search) { $where[] = "(name LIKE ? OR description LIKE ?)"; $params[] = "%$search%"; $params[] = "%$search%"; } $whereClause = $where ? "WHERE " . implode(" AND ", $where) : ""; $countStmt = $pdo->prepare("SELECT COUNT(*) FROM products $whereClause"); $countStmt->execute($params); $totalProducts = $countStmt->fetchColumn(); $totalPages = ceil($totalProducts / $perPage); $offset = ($page - 1) * $perPage; $stmt = $pdo->prepare("SELECT * FROM products $whereClause ORDER BY name LIMIT $perPage OFFSET $offset"); $stmt->execute($params); $products = $stmt->fetchAll(); $stmt = $pdo->query("SELECT * FROM categories"); $categories = $stmt->fetchAll(); ?>

Parts Search Results for "" All Products

products found

No products found. Try a different search.
Top Rated <?= htmlspecialchars($product['name']) ?>

()
$
= 200 ? 'Free Shipping' : 'Free shipping over $200' ?>
Details
1): ?>