Minecraft Infinity Evoled wird an Weihnachten gespielt okey


<!DOCTYPE html>
<html>
<body>

  <?php
  $servername = "localhost";
  $username = "root";
  $password = "";
  $dbname = "ci3o117";

  // Verbindung herstellen
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Verbindung überprüfen
  if ($conn->connect_error)
  {
      die("Connection failed: " . $conn->connect_error);
  }
?>


    <!-- Dropdown Box mit den Werten aus der Datenbank -->
    <form action="index.php" method="GET">
    <select name="person">
      <option value="0" selected>--Bitte Waehlen--</option>
      <?php
      $sql = 'SELECT * FROM person order by Vorname';
      $result = mysqli_query($conn, $sql);

      while($row = mysqli_fetch_array($result,MYSQL_ASSOC))
      {
        if($row['Vorname'] != "" && $row['Nachname'] != "")
        {
          echo '<option value="'.$row['PersonID'].'">'.$row['Vorname']." ". $row['Nachname'].'</option>';
        }
      }
      mysqli_free_result( $result );

      echo '</select>';
      echo '<input type="submit" value="OK">';
      echo '</form>';


  $conn->close();
  ?>


</body>