使用PHP选择和显示MYSQL列名

$query = "SELECT * FROM table_name";
$result = mysqli_query($connection, $query);

while ($field = mysqli_fetch_field_direct($result)) {
    echo $field->name;
}

echo "<table>";
echo "<tr>";
while ($field = mysqli_fetch_field_direct($result)) {
    echo "<th>" . $field->name . "</th>";
}
echo "</tr>";
// 显示数据行
while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>";
    foreach ($row as $value) {
        echo "<td>" . $value . "</td>";
    }
    echo "</tr>";
}
echo "</table>";