PHP Mysql query to html table only inserts to first table row

Question

I am trying to print all my data to an html table, which works, but only for the first table row.

My PHP code:

    $data = "";
while ($row = mysqli_fetch_assoc($result)) {
   $data = "<tr>
                <td>" . $row['name'] . "</td>
                <td>" . $row['email'] . "</td>
                <td>" . $row['message'] . "</td>
                <td>" . $row['created'] . "</td>
            </tr>";
 }

My html code:

<!DOCTYPE html>
<html>
<body>

<table border="1">
    <tr>
        <th width="15%">Name</th>
        <th width="15%">Email</th>
        <th width="50%">Message</th>
        <th width="20%">Created</th>
    </tr>
    <?= $data ?>
</table>

</body>
</html>

How can I make the table automatically insert more rows, and the MySQL data?

Both these codes are in 1 php file.

graemeboy · Accepted Answer · 2014-10-20 10:57:31Z

1

It looks to me that you're resetting $data to the latest row for each iteration of your while loop, instead of adding new html and data to that variable. Instead use:

$data .= "<tr..."

answered Oct 20, 2014 at 10:57

graemeboy

6205 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Atanu Saha · Accepted Answer · 2014-10-20 11:09:03Z

1

$data = "<tr>
            <td>" . $row['name'] . "</td>
            <td>" . $row['email'] . "</td>
            <td>" . $row['message'] . "</td>
            <td>" . $row['created'] . "</td>
        </tr>";

becomes

$data .= "<tr>
            <td>" . $row['name'] . "</td>
            <td>" . $row['email'] . "</td>
            <td>" . $row['message'] . "</td>
            <td>" . $row['created'] . "</td>
        </tr>";

answered Oct 20, 2014 at 11:09

Atanu Saha

5684 silver badges14 bronze badges

Comments

Choco · Accepted Answer · 2014-10-20 10:59:55Z

0

Instead of

$data = "<tr>

use

$data.= "<tr>

which means you are appending all the tr in the loop

answered Oct 20, 2014 at 10:59

Choco

1,0641 gold badge7 silver badges20 bronze badges

Collectives™ on Stack Overflow

PHP Mysql query to html table only inserts to first table row

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related