时间戳

首页 > 解决方案 > 表中数组的组列表

php - 表中数组的组列表

问题描述

我想在表格中显示一个数组的列表，我想在列中插入每个ID，在ID列name中插入每个"name"，等等......

但它在单列中显示所有内容，我该如何解决？

它现在显示如下：

[![在此处输入图像描述][1]][1]

PHP：

<table class="blueTable">
    <thead>
        <tr>
            <th>ID</th>
            <th>USER</th>
            <th>MAIL</th>
        </tr>
    </thead>
    <tfoot>
        <tr>
            <td colspan="3">
                <div class="links"><a href="#">&laquo;</a> <a class="active" href="#">1</a> <a href="#">2</a> <a href="#">3</a> <a href="#">4</a> <a href="#">&raquo;</a></div>
            </td>
        </tr>
    </tfoot>
    <tbody>
        <?php
$query = $db->query("SELECT * FROM users ORDER by id");
echo "<tr>";
while ($row = $query->fetch_array()) {
    echo "<td>" . $row['id'] . "</td>";
    echo "<tr><td>" . $row['username'] . "</td></tr>";
    echo "<tr><td>" . $row['email'] . "</td></tr>";
}
?>
 </tbody>
</table>



  [1]: https://i.stack.imgur.com/jPTR8.png

标签： php

解决方案

更改while()循环代码如下：

$query = $db->query("SELECT * FROM users ORDER by id");
while($row = $query->fetch_array()){
    echo "<tr>"; //put <tr> opening code inside, not outside
    echo "<td>".$row['id']."</td>";
    echo "<td>".$row['username']."</td>"; //remove <tr></tr>
    echo "<td>".$row['email']."</td>"; //remove <tr></tr>
    echo "</tr>"; //</tr> need to be added at last
}

推荐阅读