DataTables logo DataTables

via Ad Packs
Datatable editable
  • 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,
    });
    });

    Thanks!!
  • 1 Comment sorted by
  • Please help!!

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Support

Get useful and friendly help straight from the source.

In this Discussion