Html表错误

Question

This codes shows Title for every line. What is my mistake?

foreach($db->query('SELECT * FROM uyeler') as $row) {

            echo "<table>
                    <tr>
                    <th>ID</th>
                    <th>Username</th>
                    <th>Sex</th>
                    <th>Country</th>
                    <th>Age</th>
                    <th>Twitter</th>
                    <th>Instagram</th>
                    <th>Snapchat</th>
                    </tr>";

            echo "<tr><td>" .$row['id'] . "</td>";
            echo "<td>" .$row['username'] . "</td>";
            echo "<td>" .$row['sex'] . "</td>";
            echo "<td>" .$row['country'] . "</td>";
            echo "<td>" .$row['age'] . "</td>";
            echo "<td>" .$row['twitter'] . "</td>";
            echo "<td>" .$row['instagram'] . "</td>";
            echo "<td>" .$row['snapchat'] . "</td>";

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

The table seems like this

ID  Username    Sex Country Age Twitter Instagram   Snapchat

1   canozpey    male    sadsad  0   twit    insta   snap

ID  Username    Sex Country Age Twitter Instagram   Snapchat

2   s   male    Russia  12  test2   sad jgfhf

ID  Username    Sex Country Age Twitter Instagram   Snapchat

3   sda male    male    6   male    male    male

ID  Username    Sex Country Age Twitter Instagram   Snapchat

4   asd female  sadasd  0       

ID  Username    Sex Country Age Twitter Instagram   Snapchat

5   adsafa  female  dassd   0           

Answer 1

You need to put the wrapping and header outside of the loop - note that you are only looping on content so you don't include those tags in your foreach.

<table>
  <tr>
    <th>ID</th>
    <th>Username</th>
    <th>Sex</th>
    <th>Country</th>
    <th>Age</th>
    <th>Twitter</th>
    <th>Instagram</th>
    <th>Snapchat</th>
</tr>

<?php
foreach($db->query('SELECT * FROM uyeler') as $row) {
        echo "<tr><td>" .$row['id'] . "</td>";
        echo "<td>" .$row['username'] . "</td>";
        echo "<td>" .$row['sex'] . "</td>";
        echo "<td>" .$row['country'] . "</td>";
        echo "<td>" .$row['age'] . "</td>";
        echo "<td>" .$row['twitter'] . "</td>";
        echo "<td>" .$row['instagram'] . "</td>";
        echo "<td>" .$row['snapchat'] . "</td>";
        echo "</tr>";
    }
?>

</table>