在数据表服务器端脚本中使用 LEFT JOIN

Question

亲爱的大家，我将从数据库中获取一些数据。 并加入两个表。代码如下：

SELECT DATE(A.Inspection_datetime) AS Date, 
  A.Model, 
  COUNT(A.Serial_number) AS Qty, 
  B.Name 
FROM inspection_report AS A 
LEFT JOIN Employee AS B ON A.NIK = B.NIK 
 GROUP BY A.Model, A.Serial_number

我想使用 jQuery 显示此数据 dataTable.我尝试修改dataTable的服务器端脚本。我在这部分进行了更改：

$sWhere = " WHERE Inspection_datetime LIKE '%".mysql_real_escape_string( $_POST['sSearch'] )."%' 
  OR Model LIKE '%".mysql_real_escape_string( $_POST['sSearch'] )."%' 
  OR Serial_number LIKE '%".mysql_real_escape_string( $_POST['sSearch'] )."%' 
  OR NIK LIKE '%".mysql_real_escape_string( $_POST['sSearch'] )."%' ";

$sQuery = "SELECT id, 
  DATE(A.Inspection_datetime) AS Date, 
  A.Model, 
  COUNT(A.Serial_number) AS Qty, 
  B.Name 
  FROM inspection_report AS A 
  LEFT JOIN Employee AS B ON A.NIK = B.NIK .$sWhere.$sOrder.$sLimit";

$sOutput .= "[";
  $sOutput .= '"'.addslashes($aRow['id']).'",';
  $sOutput .= '"'.addslashes($aRow['Date']).'",';
  $sOutput .= '"'.addslashes($aRow['Model']).'",';
  $sOutput .= '"'.addslashes($aRow['Qty']).'",';
  $sOutput .= '"'.addslashes($aRow['Name']).'"';
  $sOutput .= "],";

我想要像我的mysql代码一样的结果，但这使得：

{"sEcho":1,"iTotalRecords":2,"iTotalDisplayRecords":2, "aaData":[["42","","bar","","Steve"]]}

Answer 1

我做了什么？我很粗心。这些都需要更换。

$sOutput .= "[";
                $sOutput .= '"'.addslashes($aRow['id']).'",';
                $sOutput .= '"'.addslashes($aRow['Date').'",';
                $sOutput .= '"'.addslashes($aRow['Model']).'",';
                $sOutput .= '"'.addslashes($aRow['Qty']).'",';
                $sOutput .= '"'.addslashes($aRow['Name']).'"';
                $sOutput .= "],";