Thread

$this->datatables->select("ID_E, NAME, SNAME, BIRTHDATE")
                    ->add_column('OPTIONS', '$1','get_buttons(ID_E)')
                    ->from('EMPLOYEES')->where('BIRTHDATE between "01/01/1985" and "31/12/1998"');
echo $this->datatables->generate();

$this->datatables->select("ID_E, NAME, SNAME, BIRTHDATE")
                    ->add_column('OPTIONS', '$1','get_buttons(ID_E)')
                    ->from('EMPLOYEES')->where('BIRTHDATE between to_date("01/01/1985","dd/mm/yyyy") and to_date("31/12/1998","dd/mm/yyyy")');
echo $this->datatables->generate();

public function tableload(){
  
  $this->load->database();
  $this->load->library('Datatables');
  $this->datatables->select('INVENTORY_PRODUCTS.ID, INVENTORY_PRODUCTS.PRODUCTNAME, INVENTORY_PRODUCTS.MODELNUMBER, MANUFACTURER.COMPANYNAME');
  $this->datatables->from('INVENTORY_PRODUCTS');
  $this->datatables->join('MANUFACTURER', 'MANUFACTURER.ID ON INVENTORY_PRODUCTS.MANUFACTURERID', 'LEFT');
  //$this->datatables->select('COMPANYNAME');
  $this->datatables->add_column('edit', '<a href="http://view_inventory/inventory_info/$1">view</a>', 'ID');
  
  echo $this->datatables->generate();
  
 }

$(document).ready(function() {
                  $('#inventory').dataTable( { 
                       "sPaginationType": "bs_normal",
                       "bProcessing": true,
                       "bServerSide": true,
                       "sAjaxSource": "<?php echo base_url('inventory/tableload')?>",
                       "sServerMethod": "POST",
                       "aoColumnDefs": { "bVisible": false, "aTargets": [0]}
                   } );
               } );

private function get_total_results($filtering = FALSE)
    {
        if ($filtering)
            $this->get_filtering();

        foreach ($this->joins as $val)
            $this->ci->db->join($val[0], $val[1], $val[2]);

        foreach ($this->where as $val)
            $this->ci->db->where($val[0], $val[1], $val[2]);

        foreach ($this->or_where as $val)
            $this->ci->db->or_where($val[0], $val[1], $val[2]);

        foreach ($this->group_by as $val)
            $this->ci->db->group_by($val);

        foreach ($this->like as $val)
            $this->ci->db->like($val[0], $val[1], $val[2]);

        if (strlen($this->distinct) > 0)
        {
            $this->ci->db->distinct($this->distinct);
            $this->ci->db->select($this->columns);
        }
        // These two lines are the key difference
        $this->ci->db->from($this->table);
        return $this->ci->db->count_all_results();
    }

->edit_column('releve_statut', '$1', $this->label_this("releve_statut"))

public function label_this($str) {
        /**/
          if($str == "Réalisé"){
          $r =  'AAA';
          } else if ($str == "En cours"){
          $r = 'BBB';
          } else {
          $r = 'Error';
          }
          /* */
        return $r;
    }

'fnServerData': function (sSource, aoData, fnCallback) {
                // ajax post csrf send. 
                 var csrf = {"name": "<?php echo $this->security->get_csrf_token_name(); ?>", "value":$.cookie('<?php echo $this->config->item("csrf_cookie_name"); ?>')};
                 aoData.push(csrf);
        
                $.ajax
                ({
                    'dataType': 'json',
                    'type': 'POST',
                    'url': sSource,
                    'data': aoData,
                    'success': fnCallback
                });
            }

DataTables warning (table id = 'my_id'): Requested unknown parameter '0' from the data source for row 0

function customer_data() {


  $this->datatables->select("full_name, email");
  $this->datatables->from($this->table_name);
  return $this->datatables->generate('json', 'ISO-8859-1');
 }

$(document).ready(function() {
    $('#my_id').dataTable( {
        "bProcessing": true,
        "bServerSide": true,
        "sAjaxSource": "http://localhost/customer/get_customers",
        'sAjaxDataProp': 'data',
        'fnServerData': function(sSource, aoData, fnCallback){
            $.ajax({
                'dataType': 'json',
                'type'    : 'POST',
                'url'     : sSource,
                'data'    : aoData,
                'success' : function(res){
                 console.log〈res.data〉;
                 fnCallback(res);
                }
            });
        }
    });
});

<table id="my_id">
         <thead>
            <tr>
             
                <th>full_name</th>
                <th>email</th>
                
            </tr>
        </thead>

         
        </table>

$this->datatables->select('id, name, enabled)->from('table');
$this->datatables->edit_column('enabled', ('$2' == 1) ? 'image-enabled' :  'image-disabled' , 'id, enabled');
echo $this->datatables->generate();

$this->datatables->select('branches.id,branch_name,branch_address,latitude,longitude,district,phone,branch_email')
            ->unset_column('branches.id')
   ->from('branches')
            ->join('branch_services', 'branches.id = branch_services.bid', 'LEFT')
            ->join('services_avialable', 'services_avialable.id = branch_services.sid', 'LEFT')
            ->select('GROUP_CONCAT(services_avialable.service) as services')
            ->group_by('branches.id')

->select('GROUP_CONCAT(services_avialable.service) as services', FALSE)

$this->datatables->select('FormID, FormName, FormPath, FormCIPath')
         ->unset_column('FormID')
         ->from('sys_forms');
     echo $this->datatables->generate();