Ignited-DataTables-MySQL-Helper

[eluser]heenji[/eluser]
Thank you,this library help me lots.but i make some change in my app:

Code:

$result = $query->result();
//add here

$aColumns=array();
$temp=array();
foreach($query->result_array() as $aRow){
$row = array();
if(!count($aColumns)>0){
  $aColumns=array_keys($aRow);
}
    
for ( $i=0 ; $i<count($aColumns) ; $i++ )
{
  $row[] = $aRow[ $aColumns[$i] ];
}
$temp[]=$row;
}
$result=$temp;
//not change
//.......
//change here
/*return array("sEcho" => $sEcho, "iTotalRecords" => $iTotalRecords[0]->TOTAL, "iTotalDisplayRecords" => $iTotalDisplayRecords[0]->TOTAL, "Result" => $result, "sColumns" => $this->getSColumns($result));*/
return array("sEcho" => $sEcho, "iTotalRecords" => $iTotalRecords[0]->TOTAL, "iTotalDisplayRecords" => $iTotalDisplayRecords[0]->TOTAL, "aaData" => $temp, "sColumns" => $this->getSColumns($result));
//.......
//change here
public function getSColumns($result)
{
$columns = array_keys((array) $result[0]);
$temp = "";
foreach($columns as $column)
  {
   //$temp .= $column . ", ";
   $temp .= $column . ",";
  }
  
  //return  substr($temp, 0, -2);
  return  substr($temp, 0, -1);
}