Untitled

<!DOCTYPE html>
<html>
<head>
  <title>Strona</title>
  <meta charset="utf-8">
</head>
<body>

<form method="POST">


  <select name="select">
    <?php

    $connection = mysqli_connect('localhost', 'root', '', 'fabryka');
    $query = "SELECT NAZWA from etaty";
    $require = mysqli_query($connection, $query);
    while($row= mysqli_fetch_array($require)){


      echo"<option name='".$row['NAZWA']."'>".$row['NAZWA']."</option>";
    }

     ?>

   </select>
   <input type="submit" name="request" value="Szukaj">

</form>


<?php

  $select = $_POST['select'];
  $connection2 = mysqli_connect('localhost', 'root', '', 'fabryka');
  $query2 = "SELECT * FROM pracownicy where ETAT LIKE '$select'";
  $require2 = mysqli_query($connection2, $query2);
  echo"<table border=2>";
  echo"<tr><td>ID_PRAC</td><td>NAZWISKO</td><td>IMIE</td><td>ETAT</td><td>ID_SZEFA</td><td>ZATRUDNIONY</td><td>PLACA_POD</td><td>PLACA_DOD</td><td>ID_ZESP</td></tr>";
  while($row= mysqli_fetch_array($require2)){
      echo"<tr><td>".$row['ID_PRAC']."</td><td>".$row['NAZWISKO']."</td><td>".$row['IMIE']."</td><td>".$row['ETAT']."</td><td>".$row['ID_SZEFA']."</td><td>".$row['ZATRUDNIONY']."</td><td>".$row['PLACA_POD']."</td><td>".$row['PLACA_DOD']."</td><td>".$row['ID_ZESP']."</td></tr>";

}
echo"</table>";
 ?>

</body>
</html>