使表头正确定位的问题

问题描述

我正在尝试创建一个表时遇到困难。

I am having difficulties with a table I am trying to create.

我有一个用户数组，用于显示数据库表中的用户。这里有10个用户。那么每个用户下面应该有14个玩家。喜欢这个......

I have a users array that displays the users in my database table. There is 10 users in this. Then I should have 14 players under each user. Like this...

user1 user2 user3

user1 user2 user3

player1 player1 player1

player1 player1 player1

player2 player2 player2

player2 player2 player2

player3 player3 player3

player3 player3 player3

等..

现在正在这样做

这是我的代码......

Here is my code...

<table class="draft_border_table">
        <tr>
            <th>Rnd</th>
            <th><?php echo "<div>" . $draft_order_row['username'] . "</div>"; ?></th>
<?php               
while($draft_order_row = mysqli_fetch_array($draft_order_stmt)) {
?>  

            </tr>
            <tr>
                <td><?php echo "<div class='draftBorder'>" . $player1 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player2 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player3 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player4 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player5 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player6 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player7 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player8 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player9 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player10 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player11 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player12 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player13 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player14 . "</div>"; ?></td>
            </tr>
        </table>        
<?php
}
?>

我做错了什么？

更新：

<table class="draft_border_table">
        <tr>
            <th>Rnd</th>

<?php 
while($draft_username_row = mysqli_fetch_array($draft_order_stmt2)) {
    $username = $draft_username_row['username'];
?>

                <th><?php echo "<div>" . $username . "</div>"; ?></th>
<?php
}
?>
            </tr>
<?php
$count = 1;
while($draft_order_row = mysqli_fetch_array($draft_order_stmt)) {
    $count + 1;
    $player1 = $draft_order_row['player1'];
    $player2 = $draft_order_row['player2'];
    $player3 = $draft_order_row['player3'];
    $player4 = $draft_order_row['player4'];
    $player5 = $draft_order_row['player5'];
    $player6 = $draft_order_row['player6'];
    $player7 = $draft_order_row['player7'];
    $player8 = $draft_order_row['player8'];
    $player9 = $draft_order_row['player9'];
    $player10 = $draft_order_row['player10'];
    $player11 = $draft_order_row['player11'];
    $player12 = $draft_order_row['player12'];
    $player13 = $draft_order_row['player13'];
    $player14 = $draft_order_row['player14'];
?>
<tr>
            </tr>
            <tr>
                <td><?php echo $count; ?></td>
            </tr>
            <tr>
                <td><?php echo "<div class='draftBorder'>" . $player1 . "</div>"; ?></td>
            </tr>
            <tr>
                <td><?php echo "<div class='draftBorder'>" . $player2 . "</div>"; ?></td>
            </tr>

推荐答案

试试这个：

<table class="draft_border_table">
    <tr>
        <th>Rnd</th>
<?php

while ($draft_user_row = mysqli_fetch_array($draft_order_stmt2)) {

    $username = $draft_user_row['username'];

    echo "<th><div>" . $username . "</div></th>";

}
?>

    </tr>

<?php
for ($count = 1; $count < 15; $count++) {

    $col = "player" . $count;
    $query = "SELECT $col FROM user_players ORDER BY id";
    $draft_order_stmt = mysqli_query($con, $query);

    echo "<tr><td>" . $count . "</td>";

    while (list($players) = mysqli_fetch_array($draft_order_stmt)) {

        echo "<td><div class=\"draftBorder\">";

        if ($players == NULL) {

            $players = "&nbsp;";

        }

        echo $players . "</div></td>";

    }

    echo "</tr>";
}
?>
</table>

这篇关于使表头正确定位的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！