Hi, I have a PHP-MySQL application which uses datatable. The datatable gets populated using select query from mysql table. I want to make the rows editable now in a way that when i double click on the row, a form should be opened and should allow me to edit the cells. When I click ok button, the data should be updated in mysql tables. Is this possible to achieve. Can someone please guide me??
Currently, this is how my datatable looks - (datatablecolumns is defined in previous statement)
$('#dataTableProjects').dataTable({
"aaSorting": [ [0,'asc'] ],
"aoColumns" : dataTableColumns,
"oLanguage": {
"sLengthMenu": 'Show <select>'+
'<option value="10">10<\/option>'+
'<option value="25">25<\/option>'+
'<option value="50">50<\/option>'+
'<option value="100">100<\/option>'+
'<option value="-1">All<\/option>'+
'<\/select> records'
},
"iDisplayLength": -1,
});
});