Filtering MySQL database query using html form (checkboxes, drop down lists, text fields)

This project received 10 bids from talented freelancers with an average bid price of $45 USD.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Total Bids
Project Description

I can successfully fetch all records from the database, but now I need to filter the results, using an html form with check boxes, drop down lists, and text fields. If the user leaves any of the input fields blank, I obviously don't want the results to be filtered by that particular input field. I also need the form to be sticky, and remember the checkboxes, selections, and text input fields, after the form has been submitted. I already have the form built, I just need the PHP and mysql query to make it work correctly. I want to show the first 25 results and have the rest of the results paginated. I also need to be able to sort each individual column by clicking on the column title. Please read all the comments in the attached file, I commented on every form element, and on the mysql query.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online