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 [url removed, login to view] if else present
all the search actions are done with [url removed, login to view]
Make the search query quicker and with a lot less of code.
filter options for searching;
/templates/xxx/source/boxes/[url removed, login to view]
/templates/xxx/boxes/[url removed, login to view]
/[url removed, login to view]
/inc/[url removed, login to view]
/includes/modules/[url removed, login to view]
) 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 [url removed, login to view] 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 [url removed, login to view] can be wiped.
) in [url removed, login to view] 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 [url removed, login to view] and wipe all not used or 0 parameters, like &categories_id=, &manufacturers_id=, etc.
If you have excellent skills in MYSQL + PHP + Oscommerce (it is xtcommerce code, but nearly the same as Osc, only php code + html are separated) and able to get this project done this coming week, then please do a bid.
A good developer should take maximal 12-15 hours for this project. Keep this in mind when bidding.
There are some import issues to mention when we agree with you:
1) copyrights are owned by us
2) project milestone of 80 USD by starting
3) rest payment after finishing project
4) project duration 3 days after Won bid is set
5) communication via mail/skype
6) developing on our server
7) it is forbidden to download other files then the files I will send
Dear Sir, as you can see in our review we have lot of experience in oscommerce. We have done lot of tasks on oscommerce advanced search. We are interested and ready to start straight away. Please let us know if you nee Plus
5 freelance font une offre moyenne de $280 pour ce travail
Hi, I have been building and running osCommerce sites for years, so I can get this done for you. Thanks
Hello, After having look at your requirement, I would like to offer you our quality services which will be your ultimate goal and requirement to have. With the market presence of 5+ years, we have worked on 1500+ Plus
Hi, I am interesting and I am here to give you HIGH quality and perfect result then any other.... I have 5 years experience in web programming and design ... Here is our last week work... [login to view URL] w Plus