PHP实现MySQL导出数据到EXCEL表格（小白）

运行结果如下（因数据库中只有一个记录）：

此处只有单纯的实现导出功能，很多设置还在摸索中

 

<?php
    $filename = "456";
    $sql = "SELECT * FROM tb_level";
        
    include('../COMM/conn.php');
    
    $result = mysqli_query( $con, $sql );
    
    if(! $result )
    {
        die('错误信息: ' . mysqli_error($con));
    }

    ob_end_clean();
    header('Content-type:application/vnd.ms-excel');
    header('Content-Disposition:attachment;filename='.$filename.'.xls');
    $THead = array('用户名');
    
    echo '<table>';
    echo '<tr>';
    foreach ( $THead as $h )
    {
        echo '<th>' . $h . '</th>';
    }
    echo '</tr>';
    
    while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
    {
        echo "<tr>".
            "<td> {$row['user_name']}</td> ".
            "</tr>";
    }
    echo '</table>';
?>