Untitled

<!doctype html>
<html>
  <head>
    <meta charset="utf-8">
    <title>input-Elemente</title>
    <style>
     table,td{
       border : 1pt solid black;
     }

    </style>
  </head>
  <body>
    <form action ='index.php' method = 'POST'>
        <input type='text' name='suchfeld'><input type='submit' name='suche_enter' value='Suchen'>
    </form>
    <hr> <br>
    <?php
    if(isset($_POST['suche_enter']))
    {
      $host = "127.0.0.1";
      $user = "root";
      $pass = "";


      $mysqli = new mysqli($host,$user,$pass,"shop");
      if ($mysqli->connect_errno) {
          die("Verbindung fehlgeschlagen: " . $mysqli->connect_error);
      }


      $suchbegriff = $_POST['suchfeld'];

      $sql = "Select PID,PName,PMarke FROM TProdukt WHERE PName LIKE ?";
      $statement = $mysqli->prepare($sql);
      $statement->bind_param('s', $suchbegriff);
      $statement->execute();

      $abfrage = $statement->get_result();


      WHILE($ausgabe= $abfrage->fetch_assoc())
      {
         echo $ausgabe['PID'] ;
         echo $ausgabe['PName'];
         echo $ausgabe['PMarke'];
      }
      echo '</table>';
    }
    ?>
  </body>
</html>