Datatable object passed as parameters on button click

Question

I want to pass the datatable object as parameters to controller in post method in laravel. I have tried but it does not work, please help. Below are the code I have tried.

Datatable Object

 Array
 (
 [draw] => 1
 [columns] => Array
    (
        [0] => Array
            (
                [data] => id
                [name] => 
                [searchable] => true
                [orderable] => true
                [search] => Array
                    (
                        [value] => 
                        [regex] => false
                    )

            )

        [1] => Array
            (
                [data] => name
                [name] => 
                [searchable] => true
                [orderable] => true
                [search] => Array
                    (
                        [value] => 
                        [regex] => false
                    )

            )
    )

[order] => Array
    (
        [0] => Array
            (
                [column] => 0
                [dir] => asc
            )

    )

[start] => 0
[length] => 10
[search] => Array
    (
        [value] => 
        [regex] => false
    )

[_token] => RwkzmLMcy9VW9bzwPN54zv320YsY7Rwbt7sPZCzm

)

Below are the Jquery datatable list works fine

var oTable = $('#dataTables-baselineComplete').dataTable({                          
          "processing": true,
          "serverSide": true,     
          "ajax": {
            "url": "{!!url('admin/baselinereport')!!}",
            "type": "POST",
            "data":{"_token": "{{ csrf_token() }}"},
          },
          "columns": [
                { "data": "id" },
                { "data": "name" },                 
          ],

        });

I want to pass this datatable object to another route function. Please help

Html Input

<input type="button" name="search" id="search"/>

Jquery

$("#search").click(function(){      
 $.ajax({
    url:'{!!url('admin/sample')!!}',
    method:'POST',
    data:{"_token": "{{ csrf_token() }}","datatable_object": oTable},
    success:function(response){
    }
 });

});

Route

 Route::post('admin/sample','SampleController@sampleFn');

when I click search button - ajax call and post this datatable object as input to that SampleController - sampleFn(). Please help thanks in advance.

Gyrocode.com · Accepted Answer · 2018-01-29 12:28:13Z

2

You can use ajax.params() to get the data submitted by DataTables to the server in the last Ajax request.

Because you have initialized your table with dataTable() instead of DataTable(), you have to call this API method as oTable.api().ajax.params().

For example:

$.ajax({
    url:'{!!url('admin/sample')!!}',
    method:'POST',
    data:{
        "_token": "{{ csrf_token() }}",
        "datatable_object": oTable.api().ajax.params()
    },
    success:function(response){
    }
});

edited Jan 29, 2018 at 12:28

answered Oct 26, 2016 at 12:35

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

2 Comments

bashirudeen ahmad Over a year ago

Yes.. I am got dataTable Object as params..Thank you So much... Gyrocode.

bey23 Over a year ago

Thank you, this is exactly what I was looking for. The last version uses table.ajax.params() without api().

Collectives™ on Stack Overflow

Datatable object passed as parameters on button click