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

Popular posts from this blog

c# - How to get the current UAC mode -

postgresql - Lazarus + Postgres: incomplete startup packet -

javascript - Ajax jqXHR.status==0 fix error -