Ignited DataTables

[eluser]ZaLiTHkA[/eluser]
[quote author="virtualgadjo" date="1343833378"]Hi,

have a look at my post just abose

this function is in the query generate function of the library...
if you don't want any limit to your query just transform it into this

Code:

protected function get_paging()
{
$iStart = $this->ci->input->post('iDisplayStart');
$iLength = $this->ci->input->post('iDisplayLength');
if ( $iLength != '-1' && $iLength != '' )
{
  $this->ci->db->limit($iLength, ($iStart)? $iStart : 0);
}
}

and i guess you won't have anymore limitation even for your first query
now, i don't really understand why you use ajax to load the whole data as in this case it would be more suitable to use datatables native progressive enhancement, that to say, load the whole stuff with ci and then apply datatables to the loaded table

but well, nevermind, this should work

have swing[/quote]

Thanks virtualgadjo, this is actually for a work project, and I'm currently at home (it's 11:30PM here at the moment)... But I'll try that in the morning when I get back to work and see what happens.

I'm pretty new to PHP, so I still tend to get confused by things that seem simple and logical to your everyday PHP devs... I'm sure I'll get there one day though.