Answers

• kthorngren Posts: 21,242Questions: 26Answers: 4,929

  October 2018

  Its not recommended to use ajax calls with columns.render as this could slow down the table display. Is it possible to get the information needed in the main ajax request as part of each row?

  Kevin
• carl03spinosa Posts: 3Questions: 1Answers: 0

  October 2018

  well as you could see im calling a function from my controller (url: location.origin + "/portal/school_admin/get_book_dlcount/" + temp1 + "/" + temp2) and i need the data that it returns on the last column of the table. to be exact i need the count of arrays that it will return from the controller.

  Inside the controller:

  public function get_book_dlcount() {
  $dlcount = $this->Admin_model->_ebooks_withaccess($this->uri->segment(3), $this->uri->segment(4));
  return $dlcount;
  }

  And inside the model:

  public function _ebooks_withaccess( $book_id, $sc_id ) {
      $this->db->select('tbl_users.id AS user_id, tbl_users_data.fname AS first_name, tbl_users_data.lname AS last_name,
               tbl_users.grade_level as grade_level, tbl_book_access.status as status');
      $this->db->from('tbl_book_access');
      $this->db->join('tbl_users_data', 'tbl_users_data.user_id = tbl_book_access.user_id');
      $this->db->join('tbl_users', 'tbl_users.id = tbl_book_access.user_id');
      $this->db->where('tbl_book_access.book_id', $book_id);
      $this->db->where('tbl_users.sc_id', $sc_id);
  
      $query = $this-> db -> get();
      return ($query -> num_rows() > 0) ? $query -> result() : false;
  }
  

  }
• carl03spinosa Posts: 3Questions: 1Answers: 0

  October 2018

  or better if there's a way for me in the column.render which I can call a controller directly and have it return its data as the column.render value. This is for CODEIGNITER.