We use a search box with 3 search filters + keywords. The search box puts the search options to the file /advanced_search_result.php. This file shows the results. The total code need a make-over.
Goal for this project is:
move all search filters + options to [login to view URL] if else present
all the search actions are done with [login to view URL]
Make the search query quicker and with a lot less of code.
filter options for searching;
/templates/xxx/source/boxes/[login to view URL]
/templates/xxx/boxes/[login to view URL]
search files:
/[login to view URL]
/inc/[login to view URL]
/includes/modules/[login to view URL]
) amount of keywords searching is set to a maximum see table configuration (now max = 3)
) filter input keywords on [a-Z0-9]/i (left spaces)
) filter db select [a-Z0-9]/i (left spaces); very important, there are many keywords like Güde (guede,gude) - 410-P(410P,410/P,410_P) visitors can type complete different then what is stored in the db.
) if there is no filter option selected or option = 0 then remove the empty filters from the url; like "&manufacturers_id=&cat=&sorting_id="
) if url has this options "&pfrom=0&pto=4500" then remove this options also from url, because that is the default setting when filtering on price
) add extra search select box option "check_global", default = 0, if 1 then search through all categories
) $_GET['sorting_id'] does not work correct, test every id to see what happens
) if no results than the class fuzzy_search has to start and show possible products. with a max. of 15 products.
test with "sjpo"
) use the [login to view URL] only for getting the parameters for searching. the results are shown with /advanced_search_result.php. this also means that all the search codes in [login to view URL] can be wiped.
) in [login to view URL] there is also $_GET['sorting_id'] - $_GET['filter_id'] - $_GET['manufacturers_id'] and more. these also have to
) no error codes in the url. now so now and then I see $errorno - $error
) fine-tune $breadcrumb in [login to view URL] and wipe all not used or 0 parameters, like &categories_id=, &manufacturers_id=, etc.
If you have excellent skills in MYSQL + PHP + Oscommerce and able to get this project done this comming week, then please do a bid.
A good developer should take maximal 12-15 hours for this project. Keep this in mind when bidding.
Copyrights are with us.