<?php

$serwer = "localhost";
$login = "root";
$haslo = "";
$baza = 'klasa';
$tabela = 'uczen';

?>

<h1>Welcome in database!</h1>
<form method="post">
    <input type="text" name="searchQuery" id="">
    <input type="submit" value="Szukaj...">
</form>

<?php

if (!isset($_POST['searchQuery'])) {
    $_POST['searchQuery'] = "";
}

$searchQuery = $_POST["searchQuery"];

$conn = mysqli_connect($serwer, $login, $haslo, $baza);

$query = mysqli_query($conn, "SELECT * FROM $tabela WHERE name LIKE '$searchQuery'") or die("Błąd w zapytaniu.");

while ($req = mysqli_fetch_assoc($query)) {

    $id = $req["idUcznia"];
    $name = $req["name"];
    $surname = $req["surname"];
    $adress = $req["address"];

    echo "$id, $name, $surname, $adress";

    $conn . die();
}

?>

<ul>
    <?php

    $conn = mysqli_connect($serwer, $login, $haslo, $baza);

    $query = mysqli_query($conn, "SELECT * FROM $tabela") or die("Błąd w zapytaniu.");

    while ($req = mysqli_fetch_assoc($query)) {

        $id = $req["idUcznia"];
        $name = $req["name"];
        $surname = $req["surname"];
        $adress = $req["address"];

        echo "<li>$id, $name, $surname, $adress</li>";
    }

    $conn . die();

    ?>
</ul>


</table>