php - 数据表ajax根据php中的条件更改行的颜色

Question

大家好，我有一个从 ajax 加载的数据表。
我需要根据某些情况更改行颜色。
像这样的脚本

 $(document).ready(function() {
        var dataTable =  $('#example').DataTable( {
            processing: true,
            serverSide: true,
            ajax: "ajax.php" // json datasource

        } );
  } );

像这样的 HTML

<table id="example" >
<thead>
<tr>
 <th>#</th>
 <th>ID</th>
 <th>Name</th>
 <th>Status</th>
</tr>
</thead>

</table>

在 ajax.php 中

while( $row=mysqli_fetch_array($query) ) {  // preparing an array
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["id"];
$nestedData[] = $row["name"];
$nestedData[] = $row["status"];
$data[] = $nestedData;
$i++;
}

$json_data = array(
"draw"            => intval( $requestData['draw'] ),   // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal"    => intval( $totalData ),  // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data"            => $data   // total data array
);

echo json_encode($json_data);  // send data as json format

它有效，但我需要的是根据状态更改行颜色。
如果状态==1则黄色，如果状态==2则红色，如果状态==3则蓝色。我如何添加这种格式的表格行颜色。

Answer 1

您需要按如下方式使用“fnRowCallback”:

$(document).ready(function() {
    var dataTable =  $('#example').DataTable({
        processing: true,
        serverSide: true,
        ajax: "ajax.php",
        "fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
            if ( aData[3] == "1" )
            {
            $('td', nRow).css('background-color', 'Yellow');
            }
            else if ( aData[3] == "2" )
            {
            $('td', nRow).css('background-color', 'Red');
            }
            else if ( aData[3] == "3" )
            {
            $('td', nRow).css('background-color', 'Blue');
            }
        }
    });
});