删除记录/数据后如何重新加载dataTable? [英] How to reload dataTable after deleting records/data?

问题描述

我已经生成了记录，并且每一行都有删除按钮，当我单击删除按钮时，它将从数据库中删除记录.同样，删除后它将重新加载dataTable.为此有帮助吗?

I have generated records and each row has delete button, And when I click delete button it will delete the records from the db. Also, after delete it will reload dataTable. Any Help for this?

数据表:

var table = $('#table').DataTable({

    "processing": true,

     //some settings?
});

jQuery:

$(document).on('click', '[id^="delete-product-"]', function() {

    var id = this.id.split('-').pop();

    $.ajax({
        type: 'post',
        url: 'my_controller/delete_product',
        dataType: 'json',
        data: {id: id},
        success: function(callback)
        {
            //What should I code here, that can't reload entire page, only the table 
            //after deleting records
        },
        error: function(status)
        {
            console.log(status);
        }
    });
});

任何帮助将不胜感激.预先谢谢你

Any help would be appreciated. Thank you in Advance

推荐答案

您不必重新加载整个表数据，只需删除已删除的行.

You don't have to reload whole table data, just remove the deleted row.

$(document).on('click', '[id^="delete-product-"]', function() {
    var $button = $(this);
    var id = this.id.split('-').pop();
    var table = $('#table_id_selector').DataTable(); // replace with your table id 
    selector
    $.ajax({
        type: 'post',
        url: 'my_controller/delete_product',
        dataType: 'json',
        data: {id: id},
        success: function(callback)
        {
            table.row( $button.parents('tr') ).remove().draw();
        },
        error: function(status)
        {
            console.log(status);
        }
    });
});

这篇关于删除记录/数据后如何重新加载dataTable?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！