gastenbuch2_3.php

<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
  <tr>
    <td>
      <strong>G&auml;stebuch ansehen |
        <a href="gastebuch.htm">G&auml;stebuch unterschreiben</a>
      </strong>
    </td>
  </tr>
</table>
<br>

<?php

  $username = "gb";
  $password = "gb";
  $database = "gastebuch";

  $mysqli = new mysqli("localhost", $username, $password, $database);

  $query = "SELECT * FROM guestbook ORDER BY id";

  echo '<table border="2" cellspacing="2" cellpadding="4">
          <tr>
            <td> <font face="Arial">Nummer</font> </td>
            <td> <font face="Arial">Name</font> </td>
            <td> <font face="Arial">E-Mail</font> </td>
            <td> <font face="Arial">Eintrag</font> </td>
        </tr>';

  if ($result = $mysqli->query($query)) {

      while ($row = $result->fetch_assoc()) {

          $field1name = $row["id"];
          $field2name = $row["name"];
          $field3name = $row["email"];
          $field4name = $row["comment"];

          echo '<tr>
                    <td>'.$field1name.'</td>
                    <td>'.$field2name.'</td>
                    <td>'.$field3name.'</td>
                    <td>'.$field4name.'</td>
                </tr>';
       }
    
      $result->free();
  }
?>