数据表编辑器未发送ID

Datatables editor not sending ID

本文关键字:ID 编辑器 数据表      更新时间:2023-09-26

我需要在mysql中更新数据,我使用数据表内联编辑扩展。我需要解决的问题是,如何发送行id,字段名和单元格值。这是它发送的数据;我:

 data[undefined][player_nickname]:Leon

但是我需要:

data[1][player_nickname]:Rafantunessdds
这是我的js代码:
editor = new $.fn.dataTable.Editor({
        table: "#dtables",
        ajax: {
            edit: {
                type: 'GET',
                url: '<?php echo site_url(); ?>players/saveUserData'
            },
        },
        fields: [{
                label: "Nickname:",
                name: "player_nickname"
            }, {
                label: "Email:",
                name: "player_email"
            }, {
                label: "Password:",
                name: "player_password"
            },
            {
                label: "Is Admin:",
                name: "is_admin"
            },
            {
                label: "Is Moderator:",
                name: "is_moderator"
            },
            {
                label: "is Manager:",
                name: "is_manager"
            },
            {
                label: "is Premiun:",
                name: "player_premium"
            },
            {
                label: "Is banned:",
                name: "player_banned"
            },
        ]
    });
editor = new $.fn.dataTable.Editor({
        ajax: "players/saveuserdata.php",
        table: ".dtables",
        fields: [{
                label: "Nickname:",
                name: "player_nickname"
            }, {
                label: "Email:",
                name: "player_email"
            }, {
                label: "Password:",
                name: "player_password"
            },
            {
                label: "Is Admin:",
                name: "is_admin"
            },
            {
                label: "Is Moderator:",
                name: "is_moderator"
            },
            {
                label: "is Manager:",
                name: "is_manager"
            },
            {
                label: "is Premiun:",
                name: "player_premium"
            },
            {
                label: "Is banned:",
                name: "player_banned"
            },
        ]
    });
    $('.dtables').on('click', 'tbody td:not(:first-child)', function (e) {
        editor.inline(this);
    });
    $('.dtables').DataTable({
        data: <?php echo($players) ?>,
        columns: [
            {data: 'player_id'},
            {data: 'player_nickname'},
            {data: 'player_email'},
            {data: 'player_password'},
            {data: 'is_admin'},
            {data: 'is_moderator'},
            {data: 'is_manager'},
            {data: 'player_premium'},
            {data: 'player_banned'}
        ]
    });

如何发送行id ?

使用idSrc JSON属性rom来读取/写入行ID属性。

idSrc: "player_id"