very small ajax script needed
Budget: $10 – $30 USD
** DO NOT SEND A DUMMY QUOTE. If you change the price quoted after we get in contact, I will cancel**
I have a MySQL table that is comprised of BOOLEAN (aka TINYINT(1)) fields of 0's and 1's.
I have a form on my php site that pulls the column names from the table, along with the row being adjusted.
I need an ajax script that will update the MySQL table dynamically (no reload) when I check/uncheck the checkboxes on the site. If checked, change 1 to 0. If unchecked, change 0 to 1.
Here is an example of the table:
id user animal option1 option2 option3
1 233 dog 0 1 0
2 656 cat 1 1 0
3 899 dog 1 0 1
Here is an example of the form on the site, selecting line 2:
( SELECT * from table where user = 656 and animal = cat )
☑ option 1
☑ option 2
☐ option 3
I need from you:
* correct script
* parameters to place in form tag
* parameters to place in input tag
* correct script for .php file to be called
I have a MySQL table that is comprised of BOOLEAN (aka TINYINT(1)) fields of 0's and 1's.
I have a form on my php site that pulls the column names from the table, along with the row being adjusted.
I need an ajax script that will update the MySQL table dynamically (no reload) when I check/uncheck the checkboxes on the site. If checked, change 1 to 0. If unchecked, change 0 to 1.
Here is an example of the table:
id user animal option1 option2 option3
1 233 dog 0 1 0
2 656 cat 1 1 0
3 899 dog 1 0 1
Here is an example of the form on the site, selecting line 2:
( SELECT * from table where user = 656 and animal = cat )
☑ option 1
☑ option 2
☐ option 3
I need from you:
* correct script
* parameters to place in form tag
* parameters to place in input tag
* correct script for .php file to be called