使用PHP以电子表格形式打印MySQL结果？

Question

M code here just prints it like HTML, and I was wondering if there is a way to format into a HTML table like format with column names at the top

print "Skill ||| Pay Rate";
while($row = mysqli_fetch_array($result, MYSQLI_BOTH))
  {

    print "
";
    print "$row[skill_Description], $row[skill_PayRate] ";
  }

I was looking into jquery but I'm really new at this

Answer 1

Do you mean something like this?

print "<table class='table'>
\t<tr>
";    
for ($i = 0; $i < mysqli_num_fields ($res); $i++)
{       
    print "\t\t<th>".mysqli_fetch_field_direct ($res, $i)->name."</th>
";      
}       
print "\t</tr>
";

while (($row = mysqli_fetch_assoc ($res)))
{
    print "\t<tr>
";
    foreach ($row as $val)
    {
        print "\t\t<td>".$val."</td>
";
    }
    print "\t</tr>
";
}   
print "</table>";