advanced search optimalisation

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]

search files:

/[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

Compétences : MySQL, OSCommerce, PHP

en voir plus : what is pto, what does php developer do, usd 231, move inc, get html code from url, download mysql developer, advanced search results, add inc, oscommerce advanced search query, what is a skype id, max p, XTcommerce, what is milestone, what is milestone ?, cat products, mysql code search, mysql select filter, project 4500, php search filtering, mysql search table, project milestone setting, skype send via php, forbidden, advanced filter, search categories

Concernant l'employeur :
( 30 commentaires ) Enschede, Netherlands

Nº du projet : #2357730

Décerné à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(37 Commentaires)

5 freelance font une offre moyenne de $280 pour ce travail


Check PMB [login to view URL] did 320+ successful projects here.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(165 Commentaires)

Hi, I have been building and running osCommerce sites for years, so I can get this done for you. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(17 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(9 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(8 Commentaires)