php - Issue in displaying large no of records on view file in codeigniter without using pagination -
i'm fetching list of users mysql db table & displaying on view file of codeigniter application, i'm not using pagination, want show records on same page . partial data displaying on page, have 3000 records 1000 1500 records gets shown on page. after script dies down, tried changing max_execution_time
max_input_time memory_limit
no help.
public function usersce14($sort = null, $column = null) { if (!empty($sort)) { switch ($column) { case 'id': $sortcolumn = '`id`'; break; case 'username': $sortcolumn = '`username`'; break; case 'firstname': $sortcolumn = '`first_name`'; break; case 'lastname': $sortcolumn = '`last_name`'; break; case 'email': $sortcolumn = '`email`'; break; case 'country': $sortcolumn = '`country`'; break; case 'registered': $sortcolumn = "`core_entities`.`created`"; break; case 'lastlogin': $sortcolumn = '`last_login`'; break; case 'suspended': $sortcolumn = '`suspended`'; break; case 'active': $sortcolumn = '`is_active`'; break; } $data['sort'] = $sort == 'desc' ? 'asc' : 'desc'; $sortcolumn = $sortcolumn . " " . $sort; } else { $data['sort'] = 'desc'; $sortcolumn = "`core_entities`.`created` desc"; } if (!$this->biipmi_auth->is_logged_in()) { redirect(site_url('admin/login')); return; } if (!$this->biipmi_auth->is_admin()) { redirect(site_url()); return; } $this->load->model('biipmi_entity/biipmi_person_model'); $data['users'] = $this->biipmi_person_model->get_persons(null, null, $sortcolumn, null, null, array("email", "country", "last_login"), 'reference', array("2")); $data['page_title'] = 'biipmi admin - ce14 users'; $data['main_content'] = 'admin/users/persons_ce14'; $this->load->view('admin/includes/template', $data); }
Comments
Post a Comment