prepare("SELECT pro_id, pro_name FROM tbl_product WHERE pro_name LIKE ? AND pro_category = ? LIMIT 10"); $searchTerm = "%{$q}%"; $stmt->bind_param("ss", $searchTerm, $cat); } else { // No category filter $stmt = $link->prepare("SELECT pro_id, pro_name FROM tbl_product WHERE pro_name LIKE ? LIMIT 10"); $searchTerm = "%{$q}%"; $stmt->bind_param("s", $searchTerm); } $stmt->execute(); $result = $stmt->get_result(); echo "

"; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $pro_id = htmlspecialchars($row['pro_id']); $pro_name = htmlspecialchars($row['pro_name']); echo "
• $pro_name
"; } } else { echo "
• No results found
"; } echo "

"; $stmt->close(); } ?>