codeigniter datatable send variable to datatable query

Question

i used library datatable and codeigniter

i have a variable in view

$afd = "1"

and in this view i have a javascript

<script type="text/javascript" charset="utf-8">

$(document).ready(function() {
$('#datatables').dataTable( {
"bJQueryUI":true,

"bProcessing": true,

"bServerSide": true,

"sPaginationType":"full_numbers",

"sAjaxSource": "<?=base_url()?>index.php/report/report/ajax_view_panen/",

"aaSorting": [[ 0, "asc" ]]

});

});  </script>

to call datatables in controller codeigniter . the function controller is "ajax_view_panen"

this is my controller

function ajax_view_panen()
{
$this->load->library('Datatables');
$this->datatables->from('panen');
$this->datatables->select('id,jml_panen,hariff_blok_id,hariff_afdeling_id,tgl_panen,bulan');
$this->datatables->where('id', $afd);
echo $this->datatables->generate();
}

the question is how to send variable $afd to my controller. so the variable is inside query $this->datatables->where('id', $afd); so the datatables show id = 1

sory for my bad english.

BR

Alex

Serg · Accepted Answer · 2012-11-07 13:49:05Z

1

the simpliest way is to send over CI function parameter

function ajax_view_panen($afd)
{
  ...
  $this->datatables->where('id', $afd);
  echo $this->datatables->generate();
}

so you need to pass this variable into your view and call correct url:

<script type="text/javascript" charset="utf-8">
...
"sAjaxSource": "<?=base_url()?>index.php/report/report/ajax_view_panen/<?=$afd?>",
...
</script>

Note you might need to sanitize your input to be secured.

Something like $afd = intval($afd) if thats a numeric parameter.

answered Nov 7, 2012 at 13:49

Serg

6063 silver badges10 bronze badges

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

1 Comment

Puja Surya Over a year ago

you save my time. thanks it works. my fault is in javascript "sAjaxSource": "<?=base_url()?>index.php/report/report/ajax_view_panen/"+afd", and i use in javascript var afd = <?php Print($afd); ?> to get a variable. the datatable not show. by the way thanks for your answer.

crafter · Accepted Answer · 2012-11-07 14:02:17Z

1

Serg is correct You can add the value to the GET variable list.

Otherwise if want to add to the post:

$(document).ready(function() {
$('#datatables').dataTable( {
"bJQueryUI":true,
"bProcessing": true,
"bServerSide": true,
"sPaginationType":"full_numbers",
"sAjaxSource": "<?=base_url()?>index.php/report/report/ajax_view_panen/",
"aaSorting": [[ 0, "asc" ]],
"fnServerParams": function ( aoData ) {
        aoData.push( { "afd": "<? php echo $afd; ?>"} );
 }

});

});

answered Nov 7, 2012 at 14:02

crafter

6,2971 gold badge39 silver badges47 bronze badges

Collectives™ on Stack Overflow

codeigniter datatable send variable to datatable query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related