将MySQL数据提取为表格内容

Question

So I have a database from which I want to output data in the form of a table.

<table>
  <tr>
    <th class="tg-031e">Username</th>
    <th class="tg-031e">Password</th>
  </tr>
..
</table>

For now I get the data like this:

 <?php include 'connect.php';
 echo "<tr><td class='tg-031e'>";
 $SQL = "SELECT `Username` FROM `Users` WHERE ID=1";
 $exec = mysql_query($SQL, $connection);
 while($row = mysql_fetch_array($exec)){
    echo $row['Username'] . "</td>";
 } ?>

However, in that case I need to echo out each column independently. How can I make PHP dynamically create an HTML table row with the information from the database whenever new data is present in the MySQL columns?

Answer 1

modify your php code like this:

 <?php include 'connect.php';

   $SQL = "SELECT `Username` FROM `Users` WHERE ID=1";
   $exec = mysql_query($SQL, $connection);

   echo "<table>";
   echo "<tr>";
   echo "<th class="tg-031e">Username</th>";
   echo "<th class="tg-031e">Password</th>";
   echo "</tr>";    

   while($row = mysql_fetch_array($exec)){
      //add as many fields in record, i.e: username, password... etc.
      echo "<tr>";
      echo "<td class='tg-031e'>" . $row['Username'] . "</td>";
      echo "<td class='tg-031e'>" . $row['Password'] . "</td>";
      echo "</tr>"; 
   }

   echo "</table>";  

 ?>