Instant Search

[AyoobG]

Instant Search v1.0.0
Just like googles instant search feature I’ve made one for zencart. Instant search is a new search enhancement that shows results as you type.

Tried and tested and works on all major browsers including smart phones.

Here's the download link:
https://www.zen-cart.com/downloads.php?do=file&id=1336

[long_john]

Very nice contribution, thank you!
One question for now: I noticed that the results for products include out of stock or disabled products.
I tried this on 1.39h, thanks again for simple installation and details readme!

[AyoobG]

To ignore disabled or zero stock items replace:

$sqlProduct = "SELECT products_name, products_id
FROM " . TABLE_PRODUCTS_DESCRIPTION . "
WHERE (products_name LIKE :wordSearchPlus:)
OR (LEFT(products_name,LENGTH(:wordSearch:)) SOUNDS LIKE :wordSearch:)
ORDER BY
field(LEFT(products_name,LENGTH(:wordSearch:)), :wordSearch:) DESC,
products_viewed DESC
LIMIT 2";


With this:

$sqlProduct = "SELECT " . TABLE_PRODUCTS_DESCRIPTION . ".products_name, " . TABLE_PRODUCTS_DESCRIPTION . ".products_id, " . TABLE_PRODUCTS . ".products_status
FROM " . TABLE_PRODUCTS_DESCRIPTION . ", " . TABLE_PRODUCTS . "
WHERE " . TABLE_PRODUCTS . ".products_id = " . TABLE_PRODUCTS_DESCRIPTION . ".products_id
AND " . TABLE_PRODUCTS . ".products_status <> 0
AND ((products_name LIKE :wordSearchPlus:) OR (LEFT(" . TABLE_PRODUCTS_DESCRIPTION . ".products_name,LENGTH(:wordSearch:)) SOUNDS LIKE :wordSearch:))
ORDER BY
field(LEFT(" . TABLE_PRODUCTS_DESCRIPTION . ".products_name,LENGTH(:wordSearch:)), :wordSearch:) DESC,
" . TABLE_PRODUCTS_DESCRIPTION . ".products_viewed DESC
LIMIT 2";

[long_john]

That fixed it, thanks!

[torvista]

Great effort, well done!

In case anyone else is fiddling with it like me, to avoid duplicated effort I've already done this:

1) Added support for multiple languages.
2) The created category link did not use the full path: necessary when categories are nested.
3) Added user-defined variables into code to define the number of results returned and switching on/off products and/or categories and category count.
4) Tidied up sql.
4) Changed names of jscript and ccs files and thereby removed the need for jscript .php
5) CSS for IE7: still on this one.

I'm looking at formatting the results more...

regards
Steve

[oregongardener]

Have you submitted your revisions so that they are included with AyoobG add-on download?

I fetched the files as currently posted on Zen Cart's Add-On page, but the readme does not include any of your modifications.

[WWRepair]

Instant Search v1.0.0
Just like googles instant search feature I’ve made one for zencart. Instant search is a new search enhancement that shows results as you type.

Tried and tested and works on all major browsers including smart phones.

Check out the addon section. http://www.zen-cart.com/index.php?ma...oducts_id=2032

WOW! Thank you, I love this module. Very nice

[cFrizzell]

Does this work on ZanCart version 1.5.1?

[giancalr]

Hi all, I was trying to run instant search, adding a query that also appear the image of the product, there is someone who knows how to retrieve from the database query right? Thank You

[jode]

Hi!
Can someone help me?
If there is only one product in the search result i would like to redirect the customer to the product page.
How can i do this?