CODEWITHSUNDEEP
phphtml
e t
e t

Reputation: 253

How to print out mySQL database into a div table?

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

Upvotes: 0

Views: 1153

Answers (2)

Karlo Kokkak
Karlo Kokkak

Reputation: 3714

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>

Upvotes: 1

Anthony Massaro
Anthony Massaro

Reputation: 31

Don't forget to output your values

<?php echo $row['username']; ?>

Upvotes: 0

Related Questions