Hi, I am new to Codeigniter, I am using ignited datatable library any one help me how to use it

smarshad86

Hi,

This is my view part
$(document).ready(function() {
$('#table').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "<?php echo base_url();?>admin/getdatabyajax",
"sServerMethod": "POST"
} );
} );

And this one is Controller
public function getdatabyajax(){
$this->load->library('Datatables');
$this->datatables->select(" co.name as country, st.name as state, ci.name as city");
$this->datatables->from(" states st, cities ci, countries co");
$this->datatables->where(" ci.state_id = st.id");
$this->datatables->where(" st.country_id = co.id");
echo $this->datatables->generate();
//$this->datatables->generate();
}

In view table is generated but no data is seen and sorting and pagination also not working
When i give direct path to controller its give json and it is correct I was checked it.