在表中显示check或x布尔值

Question

我在mysql数据库中有一个atable，我正在把它取到一个html 中

    print "<table>n"; 
    $result = $con->query($query); //return only the first row (we only need field names)
    $row = $result->fetch(PDO::FETCH_ASSOC); 
    print "<tr>n"; 
    foreach ($row as $field => $value){ 
         print "<th>$field</th>n";
    } // end foreach 
    print "</tr>n";  //second query gets the data 
    $data = $con->query($query); 
    $data->setFetchMode(PDO::FETCH_ASSOC); 
    foreach($data as $row){ 
         print "  <tr>n"; 
         foreach ($row as $name=>$value){ 
               print "<td>$value</td>n";
         } // end field loop 
         print "</tr>n"; } // end record loop 
         print "</table>n"; 
    } 
    catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage(); 
    } // end try

我有两列有一个布尔值，我希望如果列6='0'，那么显示x颜色：红色；否则显示✔颜色：绿色；

最终代码

foreach ($row as $name=>$value){
 if (($name == "paid" || $name == "added") && $value == "0"){
           print "<td><span style='color: red;'>X</span></td>n";
       }
       elseif (($name == "paid" || $name == "added") && $value == "1"){
           print "<td><span style='color: lime;'>&#10004;</span></td>n";
       }
   else { 
       print "<td>$value</td>n";
   }
 } // end field loop

Answer 1

尝试：

     foreach ($row as $name=>$value){
       if ($name == "Column 6"){
           if ($value == "0") {
               print "<td><span style='color: red;">X</span></td>n";
           }
           else {
               print "<td>&#10004;</td>n";
           }
       }
       else { 
           print "<td>$value</td>n";
       }
     } // end field loop 

除非你想使用一些复杂的css，否则没有很好的方法来给复选框着色。然而，您可以尝试使用CSS之前和之后的复选框，如下所示：CSS''；背景颜色"；属性不适用于<div>