How to create a editable datatable?

vaishnavkoka

I want to create a datatable which can be edited in real time and the values can be stored in the mysql database.I came across this example, but couldn't find much information regarding my query.Here is the link:
https://editor.datatables.net/examples/inline-editing/submitData.html

MSLtd

It depends what exactly you are looking for.
The data-tables themselves are open-source libraries, and as such are free to use (I believe under the MIT license), however, the editor in the example you have found is not free to use. If you'd like to try the software before committing to buying it, there is a free 15 day trial.

If you are not looking to spend on this software, the easiest option is to create a pop-up modal that allows the user to input the information to send to the database. This would work independently of DataTables and you will need to make you own .AJAX for this.

vaishnavkoka

How do i create pop-up modal?
i am using mysql datatbase.

kthorngren

How do i create pop-up modal?

If you are not familiar with building Javascript apps I would suggest purchasing the solo version of the Editor:
https://editor.datatables.net/purchase/index

The hours of time it will save is worth the small price. When I first started with my Datatables projects I was not familiar with web development and found the small price was well worth the time it would have taken to write something on my own.

Kevin

vaishnavkoka

Actually I cant afford to purchase it thats the reason i am asking you for advice or solution.