php - 使用 mysqli_fetch_array 在 PHP 表 MySQL 中显示数据

Question

目前，数据显示在一行中，我需要以表格格式显示。

将有 5 个标题与下面的 5 种“数据类型”对齐。

echo "<h3>search results for <i>". $keyword."</i></h3><br>";
while($result_arr = mysqli_fetch_array( $result )) 
{ 
echo $result_arr['datatype1']; 
echo $result_arr['2'];
echo $result_arr['3'];
echo $result_arr['4'];
echo $result_arr['5'];
}
$anymatches=mysqli_num_rows($result); 

Answer 1

这只是按照@Phil-Cooper 所说的格式化输出的情况:

echo "<h3>search results for <i>".$keyword."</i></h3><br><table><tr><th>Heading 1</th><th>Heading 2</th><th>Heading 3</th><th>Heading 4</th><th>Heading 5</th></tr>";
while($result_arr = mysqli_fetch_array( $result )) 
{ 
echo "<tr><th>".$result_arr['datatype1']."</th>"; 
echo "<th>".$result_arr['2']."</th>";
echo "<th>".$result_arr['3']."</th>";
echo "<th>".$result_arr['4']."</th>";
echo "<th>".$result_arr['5']."</th></tr>";
}
echo "</table>";
$anymatches=mysqli_num_rows($result);