Implement Search Functionality

## Database Schema & Indexing For your e-commerce search, create a full-text search index: ```sql CREATE INDEX idx_products_search ON products USING gin(to_tsvector('english', name || ' ' || description)); CREATE INDEX idx_products_category ON products(category_id); ``` ## Backend API (Node.js/Express) ```javascript app.get('/api/search', async (req, res) => { const { q, category, minPrice, maxPrice, page = 1 } = req.query; let query = ` SELECT p.*, ts_rank(to_tsvector('english', p.name || ' ' || p.description), plainto_tsquery($1)) as rank FROM products p WHERE 1=1 `; const params = []; if (q) { query += ` AND to_tsvector('english', p.name || ' ' || p.description) @@ plainto_tsquery($${params.length + 1})`; params.push(q); } // Add price and category filters... query += ' ORDER BY rank DESC, created_at DESC LIMIT 20 OFFSET $' + (params.length + 1); params.push((page - 1) * 20); const results = await db.query(query, params); res.json({ products: results.rows, total: results.rowCount }); }); ``` ## Frontend React Component ```jsx const SearchBar = () => { const [query, setQuery] = useState(''); const [suggestions, setSuggestions] = useState([]); const debouncedSearch = useCallback( debounce(async (searchTerm) => { if (searchTerm.length > 2) { const response = await fetch(`/api/search/suggestions?q=${searchTerm}`); setSuggestions(await response.json()); } }, 300), [] ); return ( <div className="search-container"> <input type="text" value={query} onChange={(e) => { setQuery(e.target.value); debouncedSearch(e.target.value); }} placeholder="Search products..." /> {suggestions.length > 0 && ( <SuggestionsList suggestions={suggestions} onSelect={setQuery} /> )} </div> ); }; ```