如何将mySQL数据库打印到div表中？

Question

Grades table is this:

username  assignment  weight  mark
a         a1          10%     50%
b         a1          10%     60%

How would I print this out using php/html?

           <div class="a">
                <div class="divTableHeading">
                    <div class="divTableRow">
                        <div class="divTableHead">Username</div>
                        <div class="divTableHead">assignment</div>
                        <div class="divTableHead">weight</div>
                        <div class="divTableHead">mark</div>
                    </div>
                </div>
                <div class="divTableBody">

            <?php
                include("config.php");
                $sql = "SELECT username, assignment, weight, mark FROM grades";
                $result = mysqli_query($db,$sql);
                while($row = $result->fetch_assoc()) {



            ?>


                    <div class="divTableRow">
                        <div class="divTableCell">$row['username']</div>
                        <div class="divTableCell">$row['assignment']</div>
                        <div class="divTableCell">$row['weight']</div>
                        <div class="divTableCell">$row['mark']</div>
                    </div>

                </div>
            </div>

$db is the connected database that is from config.php. How would I keep looping through and output the grades table?

accidental edit

Answer 1

You're missing to echo your record values.

From just $row['username'] changed to <?php echo $row['username']; ?>

And you missed } to close your while loop. Closed it as well with - <?php } ?>

Updated code:

 <div class="divTable blueTable">
    <div class="divTableHeading">
        <div class="divTableRow">
            <div class="divTableHead">Username</div>
            <div class="divTableHead">assignment</div>
            <div class="divTableHead">weight</div>
            <div class="divTableHead">mark</div>
        </div>
    </div>
    <div class="divTableBody">

<?php
    include("config.php");
    $sql = "SELECT username, assignment, weight, mark FROM grades";
    $result = mysqli_query($db,$sql);
    while($row = $result->fetch_assoc()) {
?>
        <div class="divTableRow">
            <div class="divTableCell"><?php echo $row['username']; ?></div>
            <div class="divTableCell"><?php echo $row['assignment']; ?>/div>
            <div class="divTableCell"><?php echo $row['weight']; ?></div>
            <div class="divTableCell"><?php echo $row['mark']; ?></div>
        </div>

<?php } ?>
    </div>
</div>