edit and delete button Add in server side data table in php ,ajax

Question

I put edit a button but how can I pass id of each row. Its server side data table but I don't know how get id for edit and button

 <script type="text/javascript" language="javascript" >
        $(document).ready(function() {
            var dataTable = $('#employee-grid').DataTable( {
                "processing": true,
                "serverSide": true,
                "ajax":{
                    url :"packing-grid-data.php", // json datasource
                    type: "post",  // method  , by default get
                    error: function(){  // error handling
                        $(".employee-grid-error").html("");
                        $("#employee-grid").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
                        $("#employee-grid_processing").css("display","none");
                    },

                },

                "columnDefs": [
                {

                    "data": null,
                    "defaultContent": "<a href='view_product.php?id=' name='edit' class='btn   btn-primary'> VIEW </a>",

                    "targets": -1
                    }
                ]

            });
        });


    </script>

Jaimin Rlogical · Accepted Answer · 2019-04-17 09:12:06Z

2

There are two ways you can do this:

You can prepare the Edit and Delete button html in the PHP code and pass it in ajax response
Using datatable jquery createdRow callback.Check below code. In the code data[1] means id value from database.

var dataTable = $('#employee-grid').DataTable( { "processing": true, "serverSide": true, "ajax":{ url :"packing-grid-data.php", type: "post", error: function(){ $(".employee-grid-error").html(""); $("#employee-grid").append('No data found in the server'); $("#employee-grid_processing").css("display","none"); }, }, "columnDefs": [ { "data": null, "targets": -1 } ], createdRow : function( row, data, dataIndex ) { $( row ).find('td:eq(-1)').html(' VIEW '); } });

edited Apr 17, 2019 at 9:12

answered Apr 12, 2019 at 8:50

Jaimin Rlogical

2661 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Jaimin Rlogical Over a year ago

great. if you need any other help let me know. thanks

Jaimin Rlogical Over a year ago

If my answer has solved your issue, vote me or give me your review

ankita Over a year ago

where's the option ??

Jaimin Rlogical Over a year ago

Please check my above screenshot and give your favour

ankita Over a year ago

yaa i show that and i do that bt " You can't vote for your own post "i show that message

|

Collectives™ on Stack Overflow

edit and delete button Add in server side data table in php ,ajax

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related