Datatable draws multiple same data after each update

Datatable draws multiple same data after each update

ZevarZevar Posts: 5Questions: 2Answers: 0

Hello everyone, I have a little problem, every time I update my datatable with new data (ajax serverside), from second update, it draws multiple times the same data after each update, because of this datatable becomes slower and nothing helps but page reload. Below is my code:

  $(document).on('click','#btnEdit',function(e){
            e.preventDefault();
            var dataTable=$('#example').DataTable();
            $.ajax({
                    url: "ajax/update_main.php",
                    method: "POST",
                    data: $('#update_data').serialize(),
                    success: function(data) {                  
                    $('#myModal').modal('hide');

            // Clear and redraw datatable on the same page      
                    dataTable.clear().draw(false);  
                        
                        
           dataTable.on( 'draw', function () {

                    alert( 'Table redrawn' );

                    } );    
                        
                    }
                    });                   
                    
        }); 

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 20,150Questions: 26Answers: 4,736
    edited September 2022 Answer ✓

    It looks like you have the draw event creating in the click event handler. This will cause the draw to add a new event each time you click. Move it outside the click event handler so it executes once. If this doesn't help then please post a link to your page or a test case showing the issue so we can help debug.
    https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

    Kevin

  • ZevarZevar Posts: 5Questions: 2Answers: 0

    Thank you Kevin, I will try your suggestion and let you know

  • ZevarZevar Posts: 5Questions: 2Answers: 0

    Hello Kevin, I took draw out of click event handler as you suggested and it solved my problem, thank you

Sign In or Register to comment.