php - 检查 MySQL 查询是否具有布尔值并显示 ✓ 或 ✖

Question

我是 mySQL 的新手，我正在从数据库中获取几个数据并将其扔到这样的表上：

// Create connection
$connection = new mysqli( $servername, $username, $password, $dbname );

//test if connection failed
if ( mysqli_connect_errno() ) {
  die( "Error: "
    . mysqli_connect_error()
    . " (" . mysqli_connect_errno()
    . ")" );
}

//get results from database
$result = mysqli_query( $connection, "SELECT * FROM SentEmails" );
$all_property = array(); //declare an array for saving property

//showing property
echo '<table class="data-table">
        <tr class="data-heading">'; //initialize table tag
while ( $property = mysqli_fetch_field( $result ) ) {
  echo '<td>' . $property->name . '/td>'; //get field name for header
  array_push( $all_property, $property->name ); //save those to array
}
echo '</tr>'; //end tr tag
    
    
//showing all data
while ( $row = mysqli_fetch_array( $result ) ) {
  echo "<tr>";
  foreach ( $all_property as $item ) {
    echo '<td>' . $row[ $item ] . '</td>'; //get items using property value
  }
  echo '</tr>';
}
echo "</table>";

但是，有些列是布尔值。我想显示“✓”或“✖”；在相应的列中，而不是“1”或“0”。这是否可能，无需分解 SELECT 或通过几个步骤安装表？表准备好后也许是一个javascript函数？谢谢你。

标签： phphtml-table