Find Jobs
Hire Freelancers

Advance Search and Filter Function

$30-250 USD

Terminado
Publicado hace casi 13 años

$30-250 USD

Pagado a la entrega
Hi, I have the need to build an advance filter/search function. It needs to be in PHP and pull data from a MySQL table. The table structure is: id | subject_id | medium_id | size_id | price_id 1 1 2 3 4 2 1 2 3 5 3 1 3 4 2 and so forth There is a main menu which has multiple categories and dropdowns to multiple subcategories (see attachment-01) A user can select any subcategory to begin their search. Once they select a subcategory, they are taken to a results page which has a left hand menu showing the subcategories grouped by their category (see attachment-02). The results page will obviously show only results based on whatever subcategory the user selected (if subject show all results where subject = selected subcategory). I need the mysql query built to select the records however, the problem here is, a user, once they are on the results page, can select multiple subcategories in the same category group for ALL categories so they query will need to be able to: SELECT * FROM tbl_name WHERE subject_id = 1 AND medium_id = 1 AND size_id = 2 AND price_id = 3 OR subject_id = 1 AND medium_id = 2 AND size_id = 2 AND price_id = 3 OR subject_id = 1 AND medium_id = 1 AND size_id = 1 AND price_id = 2 OR subject_id = 1 AND medium_id = 3 AND size_id = 1 AND price_id = 1 See my delema? All of this need to be done in a way that if the user hits refresh, the query stays in tack. I was thinking of dumping all the results to the page and then show/hide using jQuery depending on whatever the user selects. The left menu are href links so these can load a new page with the appended parameters to the current query string. Basically I need an eBay style filter system. The code written will need to be easily extended as there are many more categories and many many more subcategories. Confidentiality reasons I cant give too much away but would really appreciate help with this issue.
ID del proyecto: 1112793

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 13 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
lets do it now.....thanks
$100 USD en 2 días
4,7 (126 comentarios)
6,7
6,7
5 freelancers están ofertando un promedio de $58 USD por este trabajo
Avatar del usuario
Please check PMB
$50 USD en 3 días
5,0 (107 comentarios)
5,5
5,5
Avatar del usuario
Hey, Greetings from AukInternational. ****Please check your Inbox****
$50 USD en 1 día
5,0 (34 comentarios)
5,2
5,2
Avatar del usuario
Pls check pmb
$60 USD en 1 día
5,0 (3 comentarios)
3,1
3,1
Avatar del usuario
Hi, I can ready to realise your project.
$30 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
4,6
16
Forma de pago verificada
Miembro desde mar 23, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.