Untitled

<!DOCTYPE html>
<html>
    <head>

    </head>
    <body>

    <?php
    $host = "test";
    $username = "test";
    $password = "test";
    $dbname = "test";
    $port = "test";
    $socket = "test";

    // initiate new mysqli object
    $mysqli = new mysqli($host, $username, $password, $dbname, $port, $socket);

    if(mysqli_connect_errno())
    {
      printf("Verbindungsfehler:  %sn". mysqli_connect_error());
      exit();
    }

    $queryString = "SELECT anrede, vorname, nachname, strasse , plz, ort , strasser, plzr, ortr, firma, funktion, email, sektion, anfahrt, uebernachtung, status, ksprache, usprache FROM tab_teilnehmer WHERE aktiv = 1";
    $queryResult = $mysqli->query($queryString);

    while ($row = mysqli_fetch_assoc($queryResult)) {
      echo "<tr>";
      echo "<td>". $row["anrede"] . "</td>";
      echo "<td>". $row["nachname"] . "</td>";
      echo "<td>". $row["vorname"] . "</td>";
      echo "<td>". $row["strasse"] . "</td>";
      echo "<td>". $row["plz"] . "</td>";
      echo "<td>". $row["ort"] . "</td>";
      echo "<td>". $row["strasser"] . "</td>";
      echo "<td>". $row["plzr"] . "</td>";
      echo "<td>". $row["ortr"] . "</td>";
      echo "<td>". $row["firma"] . "</td>";
      echo "<td>". $row["funktion"] . "</td>";
      echo "<td>". $row["email"] . "</td>";
      echo "<td>". $row["sektion"] . "</td>";
      echo "<td>". $row["anfahrt"] . "</td>";
      echo "<td>". $row["uebernachtung"] . "</td>";
      echo "<td>". $row["status"] . "</td>";
      echo "<td>". $row["ksprache"] . "</td>";
      echo "<td>". $row["usprache"] . "</td>";
      echo "<td>""<a href='mailto:$row["email"]'>Mail</a>""</td>";
      echo "</tr>";
    }
    ?>
    </body>
</html>