[eluser]oeligerole[/eluser]
Hello,
I dont know if this is a codeigniter error but I didnt find a solution for this problem.
the problem is that I have a big mssql query which returns me an array which the controller sends to the view the code for that is:
Code:
function filter()
{
if($_REQUEST['kanr'])
{
$kanr = $this->Join_Model->getKanr($_REQUEST['kanr']);
if($_REQUEST['fa']!="")
{
$abtfc = $this->Join_Model->getABTFC($_REQUEST['fa']);
$arrabtfc = array();
foreach($abtfc as $row)
{
array_push($arrabtfc,$row['ABTFC']);
}
}
$this->pagination->initialize($config);
$config['base_url'] = 'http://intra/scripts/lkfem/index.php?c=anzeige&m=filter&kanr;='.$_REQUEST['kanr'].'&fa;='.$_REQUEST['fa'].'&errc;='.$_REQUEST['errc'].'&kategorie;='.$_REQUEST['kategorie'].'&sortieren;='.$_REQUEST['sortieren'].'&ewh;='.$_REQUEST['ewh'].'&status;='.$_REQUEST['status'].'&wert;='.$_REQUEST['wert'].'&bearbeitet;='.$_REQUEST['bearbeitet'].'';
$config['per_page'] = '20';
$config['page_query_string'] = TRUE;
$config['first_link'] = 'Erste';
$config['last_link'] = 'Letzte';
//echo $this->pagination->create_links();
$messages = $this->Anzeige_Model->getFilterMessages(trim($kanr->KANR),$arrabtfc,$_REQUEST['status'],$_REQUEST['ewh'],$_REQUEST['kategorie'],$_REQUEST['errc'],$_REQUEST['sortieren'],$_REQUEST['wert'],$_REQUEST['bearbeitet'],$config['per_page'],$_REQUEST['per_page']);
$row = $messages->row();
$config['total_rows'] = $row->TotalRows;
$this->pagination->initialize($config);
#echo "test";
$data = array(
'title' => 'Meldungen Filtern',
'content' => 'content/admin_meldungen_content',
'sidebar' => 'navig/admin_filter_kanr',
'messages' => $messages->result_array(),
'totalmessages' => $row->TotalRows,
'subheader' => $this->session->userdata ( 'subheader' ),
'pages' => $this->pagination->create_links(),
'errorcodes' => $this->Anzeige_Model->getErrorCodes($kanr->KANR,$arrabtfc),
'kanrs' => $this->Anzeige_Model->getKanr(),
'werte' => $this->Anzeige_Model->getWerte($kanr->KANR,$arrabtfc),
'fachrichtungen' => $this->Anzeige_Model->getFachrichtung($_REQUEST['kanr']));
$this->load->view($this->session->userdata('template'),$data);
}
}
if I start the page I get an the action is aborted error from the browser. If I put an echo "test" in the code, it works, it takes several seconds for the query but it works.
What can be the problem?