Ajax dropdown lists (select) as colums
Ajax dropdown lists (select) as colums
Hi, I would like to use the DataTables plugin for the application i'm developping.
Instead of having colums with just text in them, I want to have a chain of 6 dropdown lists (all linked togheter) with AJAX and MYSQL.
When I chose an option in the first column, the values of the 2nd dropdown list load. When I choose the value of the value of the second select, the values of the 3rd dropdown list load and so on. (the values will comme from mysql as it is in constant change).
Once all dropdowns selected, I want to press submit/update button to update/insert database table with these new changes.
Is there a way to do this with the Datatables plugin? Anyone has ever done something comparable to that?
Starting to get familiar with jquery/ajax...
Thanks in advance for any help.
Instead of having colums with just text in them, I want to have a chain of 6 dropdown lists (all linked togheter) with AJAX and MYSQL.
When I chose an option in the first column, the values of the 2nd dropdown list load. When I choose the value of the value of the second select, the values of the 3rd dropdown list load and so on. (the values will comme from mysql as it is in constant change).
Once all dropdowns selected, I want to press submit/update button to update/insert database table with these new changes.
Is there a way to do this with the Datatables plugin? Anyone has ever done something comparable to that?
Starting to get familiar with jquery/ajax...
Thanks in advance for any help.
This discussion has been closed.
Replies
it can be done, but again it's not a datatables function.
compose your own AJAX queries and a back-end script/service to reply with the values for your drop down lists. when you change one drop-down, run a query for the next drop-down.