Skip to main content

Server side datatable using codeigniter 3

By The Developer Club

 


What is server side datatables?

Server side datatables are used to show large data sets. Advantage of server side datatables.

  • Data processing will be server side.
  • Show large data sets.
  • Server-side rendering is better for SEO than client-side rendering, as it can speed up the loading time of your page, improving user experience and helping your site rank higher in Google search results.
  • Using server-side rendering here has the benefit of keeping the information on the server-side and not delivering it to the client, even if you pull from relational databases or NoSQL stores.

HTML Code

<div class="tab-pane fade show active" id="tab10">

        <section class="main--content" style="padding:0px;" >

                <div class="panel">

                    <div class="records--list">

                        <table id="recordsListView" style="width:100%">

                            <thead>

                                <tr>

                                    <th>Id</th>

                                    <th>First Name</th>

                                    <th>Last Name</th>

                                    <th>Email</th>

                                    <th>Mobile</th>

                                    <th>Created Date</th>

                                    <th>Status</th>

                                    <th class="not-sortable">Actions</th>

                                </tr>

                            </thead>

                        </table>

                    </div>

                    </div>

            </section>

        </div>

Controller 

public function getIncomingCase(){

        $data = array();

        // Fetch member's records

        $jobData = $this->user_model->getRows($_POST);

 

        $i = $_POST['start'];

        foreach($jobData as $jobValue){

            $i++;

            $case_status = null;

            if($jobValue->status == 0){

                $case_status = '<span class="label label-warning">Action not initiated</span>';

            }

            $action = '<div class="dropleft">

                            <a href="#" class="btn-link" data-toggle="dropdown"><i class="fa fa-ellipsis-v"></i></a>

                            <div class="dropdown-menu">

                                <a href="'.base_url().'job/viewcase/'.$jobValue->id.'" class="dropdown-item">View</a>

                                <a href="#" class="dropdown-item">Reject</a>

                                <a href="#" class="dropdown-item">Archive</a>

                            </div>

                        </div>';

            $job = unserialize($jobValue->jobdata);

           

            $created = date( 'l Y/m/d H:i', strtotime($jobValue->createdAt));

            $data[] = array($jobValue->aid,

                $jobValue->salutation." ".$jobValue->firstname." ".$jobValue->lastname,

                $jobValue->mobile,

                $jobValue->natureofjob."<br>". $job['language_from'],

                "Null",

                $created,

                $case_status,

                $action);

        }

        $output = array(   

            "draw" => $_POST['draw'],

            "recordsTotal" => $this->user_model->countAll(),

            "recordsFiltered" => $this->user_model->countFiltered($_POST),

            "data" => $data,

        );

        echo json_encode($output);

    }


Model 


public function getRows($postData){

          $this->_get_datatables_query($postData);

          if($postData['length'] != -1){

            $this->db->limit($postData['length'], $postData['start']);

          }

          $query = $this->db->get();

          return $query->result();

      }

     

      /*

       * Count all records

       */

      public function countAll(){

        $this->db->from('job');

        return $this->db->count_all_results();

      }

     

      /*

       * Count records based on the filter params

       * @param $_POST filter data based on the posted parameters

       */

      public function countFiltered($postData){

        $this->_get_datatables_query($postData);

        $query = $this->db->get();

        return $query->num_rows();

      }

     

      /*

       * Perform the SQL queries needed for an server-side processing requested

       * @param $_POST filter data based on the posted parameters

       */

      private function _get_datatables_query($postData){

        $userid = $this->session->userdata('id');

        $this->column_search = array('CJ.id','CU.salutation','CU.firstname','CU.lastname','CU.mobile','CJ.aid','CJ.natureofjob','CJ.jobdata','CJ.docs','CJ.status','CJ.createdAt');

       

$this->db->select("CJ.id,CU.salutation,CU.firstname,CU.lastname,CU.mobile,CJ.aid,CJ.natureofjob,CJ.jobdata,CJ.docs,CJ.status,CJ.createdAt");

        // Set default order

        $this->order = array('CJ.id' => 'asc');

 

        $this->db->from('job as CJ');

        $this->db->join('job_assign as CJA','CJA.aid  = CJ.aid','LEFT');

        $this->db->join('users as CU','CU.id  = CJA.uid_to','LEFT');

        $this->db->where("CJ.userId", $userid);

       

        $i = 0;

          // loop searchable columns

        foreach($this->column_search as $item){

              // if datatable send POST for search

          if(isset($postData['search']['value'])){

                  // first loop

            if($i===0){

                      // open bracket

              $this->db->group_start();

              $this->db->like($item, $postData['search']['value']);

            }else{

              $this->db->or_like($item, $postData['search']['value']);

            }

 

                  // last loop

            if(count($this->column_search) - 1 == $i){

                      // close bracket

              $this->db->group_end();

            }

          }

          $i++;

        }

 

        if(isset($postData['order'])){

          $this->db->order_by($this->column_order[$postData['order']['0']['column']], $postData['order']['0']['dir']);

        }else if(isset($this->order)){

          $order = $this->order;

          $this->db->order_by(key($order), $order[key($order)]);

        }

      }


Comments

Post a Comment

Popular posts from this blog

MVC (Model View Controller) : Codeigniter Club

By The Developer Club
MVC will divide an application into three functional parts: Models  — deals with your database, carries out computations, and more. In short, it is where your business logic is located. Views  — forms the presentation layer of the application, where the data from your  models  are embedded. Controllers  — used to connect  models  and  views . A controller will route user requests to the appropriate  model.  After that, once the model has done its job, the controller loads the relevant  view. This architectural pattern also gives developers the flexibility to reuse code for multiple views. For example, you can apply the same navigation bar on every webpage of your application. Moreover, as both  views  and  models  are entirely separate, the front-end developers can work in parallel with the back-end team to speed up the development process. Note that CodeIgniter also subscribes to  Object-Oriented Programmin...
Post a Comment
Read more

How to secure codeigniter website?

By The Developer Club
CSRF Protection (Cross-Site Request Forgery) CSRF process of an attacker tricking their victim into unknowingly submitting a request. CodeIgniter provides CSRF protection out of the box, which will get automatically triggered for every non-GET HTTP request, but also needs you to create your submit forms in a certain way. URI Security CodeIgniter contain following character in URI ·          Alpha-numeric text (Latin characters only) ·          Tilde: ~ ·          Per cent sign: % ·          Period: . ·          Colon: : ·          Underscore: _ ·          Dash: - ·          Space Password Handling ·        ...
Post a Comment
Read more

Codeigniter installation & setup: Codeigniter Club

By The Developer Club
                    Windows Environment   Install XAMPP or WAMP   Download and Unzip the package from Codeigniter.com   Extract all the documents in the server space (htdocs or www directory) Linux Environment  Download and Unzip the package from Codeigniter.com  Place the extracted folder in /var/www (in WAMP) or xampp/htdocs (XAMPP) Base URL   Go to application/config/config.php  Define base URL as $config['base_url'] = 'http://localhost/path/to/folder'; How to remove index.php from URL? go to root  create htaccess file  Add below code inside it  RewriteEngine on RewriteCond $1 !^(index\.php|assets|image|resources|robots\.txt) RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ index.php/$1 [L,QSA] Note: .htaccess code varies depending on the hosting server. Some hosting servers (e.g.: Godaddy) need to use an extr...
Post a Comment
Read more