How to create a check box controlled inventory part#, descrip and price list.
How to create a check box controlled inventory part#, descrip and price list.
tim1955
Posts: 7Questions: 3Answers: 0
After searching and studying various examples for hours, I still cannot locate what I am looking for.
I want to create a data table that has a checkbox, a part #, descrip and price. The part#, description, and price will come from a MySQL database table. I will be running this from a PHP script.
I want to open the data table in a pop-up or modal from my invoice-creating script. Then I want the user to be able to select one or more parts by checking the box. Then I want to append those records to the invoice.
Are there any examples that you know of that I can study?
I am familiar with DataTables and have used the software to edit single entries from a table. But I have never worked with multiple entries and am not sure DataTables can do what I am requesting.
Thank you very much for reading and for any assistance you can provide.
This question has an accepted answers - jump to answer
Answers
I think this example and the documentation here will be most relevant for you.
Use Select to allow the end user to select rows in your table, then use the API to get the selected rows when they want to submit / save. Make an Ajax call to the server with the ids for those rows that will append them to the invoice.
Allan
Allan,
Thank you for your quick and helpful assistance. The links you provided are excellent.
Best Regards,
Tim
Let me know how you get on with it
.
Allan