How to post the parameter in ajax call of jquery datatable

Question

As of now I am passing parameter along with URL in ajax call of data table.

But I want to pass it as POST method, please anyone one help me regarding parameter passing in post method, here's my trial code:

// Sending through GET
var $table = $('#example').dataTable( 
    "processing": true,
    "serverSide": true,
    "bDestroy": true,
    "bJQueryUI": true,
    "ajax": 'getResult.php?formName=afscpMcn&action=search&mcn_no='+mcnNum+'&cust_nm='+cust_num+'&emp_id='+emp+''
});

did you see this page? datatables.net/examples/server_side/post.html — pecci
– pecci, Commented Aug 26, 2014 at 12:25
I want to pass the parameter like form name ,action and other parameters.. In that manual they have mention only column data — chaya
– chaya, Commented Aug 26, 2014 at 12:28

Kevin · Accepted Answer · 2016-10-05 22:34:14Z

56

Just pass it like a normal jQuery ajax in POST fashion.

The structure should look like this:

ajax: { type: 'POST', url: <path>, data: { your desired data } }

Example:

var $table = $('#example').dataTable( 
    "processing": true,
    "serverSide": true,
    "bDestroy": true,
    "bJQueryUI": true,
    "ajax": {
        'type': 'POST',
        'url': 'getResult.php',
        'data': {
           formName: 'afscpMcn',
           action: 'search',
           // etc..
        },
    }
});

In PHP, just access the POST indices as usual (just the straightforward approach):

getResult.php

$form_name = $_POST['formName'];
// the rest of your values ...

DataTables manual entry

edited Oct 5, 2016 at 22:34

answered Aug 26, 2014 at 12:38

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

2 Comments

Sophie Over a year ago

Hey Kevin, I am having trouble when the json return 0 results, imagine if the table has no entries... so when it returns a blank JSON I am getting error from datatable.. it is a default alert informing the JSON is in wrong format.. Do you know how can I deal with it?

Kevin Over a year ago

@Sophie it's important that whatever you have in your response is still a valid structure that's acceptable to the format datatables need when you return it to client side. datatables.net/examples/server_side/simple.html even if it's zero rows.

bharat · Accepted Answer · 2019-05-19 15:27:34Z

10

You can try this way:

$('#example').dataTable( {
  "ajax": {
    "url": "data.json",
    "data": function ( d ) {
        d.extra_search = $('#extra').val();
    }
  }
});

https://datatables.net/reference/option/ajax.data

answered May 19, 2019 at 15:27

bharat

1,7821 gold badge25 silver badges33 bronze badges

Comments

Abdullah Sheikh · Accepted Answer · 2017-03-13 18:35:02Z

$("#tbl").dataTable({
            oLanguage: {
                sProcessing: '<div id="loader"></div>'
            },
            bProcessing: true,
            "bServerSide": true,
            "iDisplayLength": pageSize,
            "sAjaxSource": " /PurchaseOrder/AddVendorItems", // url getData.php etc
            "fnServerData": function ( sSource, aoData, fnCallback, oSettings ) {
                aoData.push({ "name": "where", "value": ID +" AND ISNULL(IsFinal,0) = "+ ($("#chkFinal").bootstrapSwitch('state') == true ? 1 : 0) });
                aoData.push({"name": "PackIDFK", "value": $("#PackIDFK").val()}) //pushing custom parameters
                oSettings.jqXHR = $.ajax( {
                    "dataType": 'json',
                    "type": "POST",
                    "url": sSource,
                    "data": aoData,
                    "success": fnCallback
                } );
            } });

This is real time example.The aoData contains all the parameters which is required on server side and you can also push your own custom parameters

Collectives™ on Stack Overflow

How to post the parameter in ajax call of jquery datatable

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related