我有一个从mysqli表中获取数据的表，我有一个列作为'status'，其中有两个值 ACTIVE 以及 DEACTIVE . 我需要在不同的bg颜色/字体颜色中停用，在不同的颜色中处于活动状态，如何通过if else语句实现这一点。至少td换了也没问题。

<?php
// Include config file
require_once 'config.php';

// Attempt select query execution
$sql = "SELECT * FROM retail";
if($result = mysqli_query($link, $sql)){
    if(mysqli_num_rows($result) > 0){

        echo "<table class='table js-dynamitable table-bordered table-striped table-condensed'>";
            echo "<thead>";
                echo "<tr>";
                    echo "<th>#</th>";
                    echo "<th>operator_name</th>";
                    echo "<th>zone</th>";
                    echo "<th>nas_ip</th>";
                    echo "<th>switch_name</th>";
                    echo "<th>switch_ip</th>";
                    echo "<th>switch_port</th>";
                    echo "<th>connected_port</th>";
                    echo "<th>vlan</th>";
                echo "</tr>";
            echo "</thead>";
            echo "<tbody>";
            while($row = mysqli_fetch_array($result)){
                echo "<tr>";

                    echo "<td>" . $row['id'] . "</td>";
                    echo "<td>" . $row['operator_name'] . "</td>";
                    echo "<td>" . $row['zone'] . "</td>";
                    echo "<td>" . $row['nas_ip'] . "</td>";
                    echo "<td>" . $row['switch_name'] . "</td>";
                    echo "<td>" . $row['switch_ip'] . "</td>";
                    echo "<td>" . $row['switch_port'] . "</td>";
                    echo "<td>" . $row['connected_port'] . "</td>";
                    echo "<td>" . $row['status'] . "</td>";

                    echo "<td>";

                        echo "<a href='readr.php?id=". $row['id'] ."'  title='View Record' data-toggle='tooltip'><span class='glyphicon glyphicon-eye-open'></span></a>";
                        echo "<a href='updater.php?id=". $row['id'] ."'  title='Update Record' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
                        echo "<a href='deleter.php?id=". $row['id'] ."' data-toggle='modal' data-target='#exampleModalLong'  title='Delete Record' data-toggle='tooltip'><span class='glyphicon glyphicon-trash'></span></a>";

                    echo "</td>";
                echo "</tr>";
            }
            echo "</tbody>";                            
        echo "</table>";
        // Free result set
        mysqli_free_result($result);
    } else{
        echo "<p class='lead'><em>No records were found.</em></p>";
    }
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

// Close connection
mysqli_close($link);
?>

我也在使用这个脚本，这是正确的头格式

var $table = $('table');
    $table.bootstrapTable({

      search: true,
      pagination: true,

      buttonsClass: 'primary',

      minimumCountColumns: 2,
      columns: [{
          field: 'id',
          title: 'ID',
          sortable: true,
        }, {
          field: 'operator_name',
          title: 'OPERATOR NAME',
          sortable: true,
        }, {
          field: 'zone',
          title: 'zone',
          sortable: true,
        },
        {
          field: 'nas_ip',
          title: 'nas_ip',
          sortable: true,
        },
        {
          field: 'switch_name',
          title: 'SWITCH NAME',
          sortable: true,
        },
        {
          field: 'switch_ip',
          title: 'SWITCH IP',
          sortable: true,
        },
        {
          field: 'switch_port',
          title: 'SWITCH PORT ',
          sortable: true,
        },
        {
          field: 'connected_port',
          title: 'connected_port',
          sortable: true,
        },
        {
          field: 'vlan',
          title: 'VLAN',
          sortable: true,
        },

        {
          field: 'operation',
          title: 'Action',
        },
      ],

    });