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
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online