以电子表格形式使用 PHP 打印 MySQL 结果 - Print MySQL results with PHP in spreadsheet form?

Print MySQL results with PHP in spreadsheet form?

这里的代码只是像 HTML 一样打印它，我想知道是否有办法格式化为 HTML 表，例如顶部带有列名的格式

print "Skill ||| Pay Rate";
while($row = mysqli_fetch_array($result, MYSQLI_BOTH))
  {
    print "'n";
    print "$row[skill_Description], $row[skill_PayRate] ";
  }

我正在研究jquery，但我真的很陌生

你的意思是这样吗？

print "<table class='table'>'n't<tr>'n";    
for ($i = 0; $i < mysqli_num_fields ($res); $i++)
{       
    print "'t't<th>".mysqli_fetch_field_direct ($res, $i)->name."</th>'n";      
}       
print "'t</tr>'n";
while (($row = mysqli_fetch_assoc ($res)))
{
    print "'t<tr>'n";
    foreach ($row as $val)
    {
        print "'t't<td>".$val."</td>'n";
    }
    print "'t</tr>'n";
}   
print "</table>";