Member Avatar for hindu times

Hi there,

I'm building an online Store as part of my website. The store will have upwards of 40 pages (including category and product pages).

I want to add a search bar to the Store which will allow customers to search for the product they want.

How would I go about doing this? Just looking for advice really.

The store pages are .php pages, and use CSS and HTML also.

All of the store pages are stored in the Store folder. I would like the search bar to only search the store, and not any other part of my site.

Many thanks.

  • 3 Contributors
  • 5 Replies
  • 180 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by teedoff

Dani AI

Generated

Good options already mentioned in the thread: pointed to a hosted custom-search option and suggested a local indexer (which later confirmed worked). Two practical, durable approaches fit a small PHP-based store kept in a single /store folder: (A) database-driven search (best for structured product data) and (B) file/indexer-driven search (best for PHP pages with minimal or no DB). Each approach can be restricted to the store scope without touching the rest of the site.

For a database-backed catalog: create a products table with columns for name, sku, description, category, tags and add indexes. Start with a simple, safe search form and a prepared-statement query (example shows LIKE for simplicity; switch to full-text MATCH ... AGAINST when performance/relevance becomes important):

<form method="get" action="/store/search.php">
  <input type="search" name="q" placeholder="Search store" />
  <input type="submit" value="Search" />
</form>

<?php
// search.php (sketch)
$q = trim($_GET['q'] ?? '');
if ($q !== '') {
  $pdo = new PDO($dsn, $user, $pass, $opts);
  $stmt = $pdo->prepare(
    "SELECT id,name,description FROM products
     WHERE name LIKE :q OR description LIKE :q
     LIMIT 50"
  );
  $stmt->execute([':q' => "%$q%"]);
  $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
  // escape output for HTML to avoid XSS
}
?>

For static/PHP pages without a catalog backend: use a local indexer/crawler configured to index only the /store folder and the rendered output of PHP pages. That indexed output can be served via a small lookup script (JSON or SQLite). Hosted search providers can also be scoped to a path, but they trade off control and privacy.

Quick checklist: always use prepared statements and escape output (security); paginate and limit results (performance); log top searches to improve categories/tags (relevance); highlight terms in results and show a friendly “no results” help message; choose full-text indexes or an indexer as the catalog grows.

Recommended Answers

All 5 Replies

Member Avatar for teedoff

I dont know PHP, but the basic idea is you need a query to search your database. PHP i know can handle this, but again I couldnt comment on the syntax to use. Coldfusion I know...lol

Member Avatar for teedoff

zoom search works very well. Especially with php. Very easy to use and has a great GUI interface. Its basically an indexing software. It even builds all your php code for you and even your search form!

Member Avatar for hindu times

Awesome. Used Zoom search and works great! Thanks.

Member Avatar for teedoff

Google works well enough, but some site owners dont like that fact that google search takes their visitors away from their site briefly. I have heard that google now has a custom search that doesnt do this, but havent check this myself.

Just remember though, Zoom is free and fully functional, but they limit the free version to 50 pages to index I think. They have paid versions which allow for more pages as well as unlimited number of pages should you need that in the future.

Edited by teedoff because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.