Filter MySQL results Based on Checkboxes
Budget: $10 – $30 USD
I need someone's help in tweaking my script.
Should be very simple for someone with knowledge of PHP, MySQL, and Ajax.
The form is simple. It is composed only of checkboxes. Each checkbox has a value that will be searched in the MySQL database using the LIKE command.
It's essentially filtering fetched results based on checkboxes.
Based on what the user checks, I want the script to run a MySQL query using the:
"SELECT * FROM table WHERE name LIKE %input% OR"
The user can select multiple checkboxes.
The reason I do not want to do this manually for every checkbox is because there will be multiple additions of checkboxes in the future, and the script needs to accommodate for this.
Finally, would like to use Ajax to display the fetched results below the form, at the bottom of the page, in real time. It will obviously refresh and change based on the selection of checkboxes.
You will not have access to any database, I just need help altering the script.
Hoping this takes less than a day.
Should be very simple for someone with knowledge of PHP, MySQL, and Ajax.
The form is simple. It is composed only of checkboxes. Each checkbox has a value that will be searched in the MySQL database using the LIKE command.
It's essentially filtering fetched results based on checkboxes.
Based on what the user checks, I want the script to run a MySQL query using the:
"SELECT * FROM table WHERE name LIKE %input% OR"
The user can select multiple checkboxes.
The reason I do not want to do this manually for every checkbox is because there will be multiple additions of checkboxes in the future, and the script needs to accommodate for this.
Finally, would like to use Ajax to display the fetched results below the form, at the bottom of the page, in real time. It will obviously refresh and change based on the selection of checkboxes.
You will not have access to any database, I just need help altering the script.
Hoping this takes less than a day.