目前我正在项目服务器端的DataTables中使用。Codeigniter作为框架，SOAP作为web服务。
当我尝试运行客户端时，弹出了一个警告：
无法解析来自服务器的JSON数据
我通过点击这个链接制作了我的数据表。
这是我的服务器代码：
$CI =& get_instance();
$CI->load->database();
$aColumns = array('time', 'ip_address', 'player_item','comp_item','result');
// DB table to use
$sTable = 'rps';
//
$iDisplayStart = $CI->input->get_post('iDisplayStart', true);
$iDisplayLength = $CI->input->get_post('iDisplayLength', true);
$iSortCol_0 = $CI->input->get_post('iSortCol_0', true);
$iSortingCols = $CI->input->get_post('iSortingCols', true);
$sSearch = $CI->input->get_post('sSearch', true);
$sEcho = $CI->input->get_post('sEcho', true);
// Paging
if(isset($iDisplayStart) && $iDisplayLength != '-1')
{
$CI->db->limit($CI->db->escape_str($iDisplayLength), $CI->db->escape_str($iDisplayStart));
}
// Ordering
if(isset($iSortCol_0))
{
for($i=0; $i<intval($iSortingCols); $i++)
{
$iSortCol = $CI->input->get_post('iSortCol_'.$i, true);
$bSortable = $CI->input->get_post('bSortable_'.intval($iSortCol), true);
$sSortDir = $CI->input->get_post('sSortDir_'.$i, true);
if($bSortable == 'true')
{
$CI->db->order_by($aColumns[intval($CI->db->escape_str($iSortCol))], $CI->db->escape_str($sSortDir));
}
}
}
/*
* Filtering
* NOTE this does not match the built-in DataTables filtering which does it
* word by word on any field. It's possible to do here, but concerned about efficiency
* on very large tables, and MySQL's regex functionality is very limited
*/
if(isset($sSearch) && !empty($sSearch))
{
for($i=0; $i<count($aColumns); $i++)
{
$bSearchable = $CI->input->get_post('bSearchable_'.$i, true);
// Individual column filtering
if(isset($bSearchable) && $bSearchable == 'true')
{
$CI->db->or_like($aColumns[$i], $CI->db->escape_like_str($sSearch));
}
}
}
// Select Data
$CI->db->select('SQL_CALC_FOUND_ROWS '.str_replace(' , ', ' ', implode(', ', $aColumns)), false);
$rResult = $CI->db->get($sTable);
// Data set length after filtering
$CI->db->select('FOUND_ROWS() AS found_rows');
$iFilteredTotal = $CI->db->get()->row()->found_rows;
// Total data set length
$iTotal = $CI->db->count_all($sTable);
// Output
$output = array(
'sEcho' => intval($sEcho),
'iTotalRecords' => $iTotal,
'iTotalDisplayRecords' => $iFilteredTotal,
'aaData' => array()
);
foreach($rResult->result_array() as $aRow)
{
$row = array();
foreach($aColumns as $col)
{
$row[] = $aRow[$col];
}
$output['aaData'] = $row;
}
return json_encode($output);
这就是结果：
JSON:{"sEcho":0,"iTotalRecords":22,"iTotalDisplayRecords":"22","aaData":[]}
在循环$rResult->result_array()中，您总是创建新的数组，并且最近的$row数组将被新的$aRow数组替换。因此，将初始化放在outside循环语句中。
$row = array();
$i = 0;
foreach($rResult->result_array() as $aRow){
foreach($aColumns as $col){
$row[$i][$col] = $aRow[$col];
}
$i++;
}
$output['aaData'] = $row;