En cours

Improve Advanced search for oscommerce

This project requires a programmer to improve the OSCommerce advanced search - It needs to be able to search by alphabetical order, title and manufacturer

examples:

search in title : List results from title start with 'A' where keyword are 'monitor' AND category ='electronics' AND format ='---'

search in manufacturer : list results from manufacturers start with 'A' where keyword are 'son' AND category ='electronics' AND format ='---'

This project is to improve this sql:

select distinct p.products_image, p.products_quantity, p.products_model, m.manufacturers_name, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF([url removed, login to view], s.specials_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view], s.specials_new_products_price, p.products_price) as final_price from products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id left join manufacturers m on p.manufacturers_id=m.manufacturers_id left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%son%' or p.products_model like '%son%' or m.manufacturers_name like '%son%' or p2pef.products_extra_fields_value like '%son%') ) and ((p2pef.products_extra_fields_value like '%todos%' AND p2pef.products_extra_fields_id = 2) ) order by pd.products_name

and the form and [url removed, login to view] file

Compétences : MySQL, OSCommerce, PHP

Voir plus : oscommerce advanced search alphabetical, to advanced, search for manufacturers, m.c.m. electronics, manufacturer search, manufacturer order, file status 22, electronics programmer, advanced search results, p sql, son, search file, null, manufacturers list, search categories, sql keyword, sql select order, manufacturer list oscommerce, oscommerce list manufacturers, form search, join file, improve php form, oscommerce manufacturers categories, advanced project php, oscommerce order products category

Concernant l'employeur :
( 2 commentaires ) MOLINA DE SEGURA, Spain

N° du projet : #959977

Décerné à :

kev2me

I can help modify your search options.

80 $ USD en 1 jour
(116 Commentaires)
6.4

13 freelance ont fait une offre moyenne de 61 $ pour ce travail

humashahid80

kindly check pmb.

50 $ USD en 1 jour
(55 Commentaires)
6.9
cstl

pls go through pmb

49 $ USD en 2 jours
(18 Commentaires)
6.9
techfortune

Osc Guru at your service. Ready to start now. Awaiting for your selection. Thanks !!

75 $ USD en 2 jours
(94 Commentaires)
6.3
getndone

Please check pm

165 $ USD en 3 jours
(41 Commentaires)
5.5
swamiwebservices

we can do this

60 $ USD en 1 jour
(78 Commentaires)
5.4
binhtq

Hi, I have more than 4 years with Oscommerce. I can do it. Best Regards

80 $ USD en 1 jour
(19 Commentaires)
5.0
istankov85

Hi, falasbu,Please see PM. Regards, Ivan Stankov

30 $ USD en 1 jour
(37 Commentaires)
5.0
resourcesnode

Fast change, great project for me.

50 $ USD en 1 jour
(12 Commentaires)
4.0
maturesteps

please check pmb..

35 $ USD en 1 jour
(2 Commentaires)
3.8
developerhari

Hello , please check PMB , thanks

40 $ USD en 2 jours
(10 Commentaires)
3.2
Almadad

Please See PM...

50 $ USD en 1 jour
(4 Commentaires)
2.1
xahoor

Hi, Please check your PMB.

30 $ USD en 1 jour
(0 Commentaires)
0.0