php

--3--
 <?php
        $servername = "localhost";
        $username = "root";
        $password = "";
        $dbname = "studenci";

        $conn = new mysqli($servername, $username, $password, $dbname);
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }

        $sql = "SELECT id, imie, nazwisko FROM student";
        $result = $conn->query($sql);

        if ($result->num_rows > 0) {
            while($row = $result->fetch_assoc()) {
                echo "id: " . $row["id"]. " - Dane: " . $row["imie"]. " " . $row["nazwisko"]. "<br>";
            }
        } else {
            echo "0 wyniku";
        }
        $conn->close();
    ?>


--5--
<form action="" method="GET">
        <select name="opcja">
                <option value="imie">Imie</option>
                <option value="nazwisko">Nazwisko</option>
                <option value="wszystko">Wszystko</option>
        </select>
        <input type="text" name="wartosc"/>
        <input type="submit" value="Pobierz dane">
    </form>

    <?php
        if ($_GET != null) {
            $opcja = $_GET['opcja'];
            $wartosc = $_GET['wartosc'];

            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "studenci";

            $conn = new mysqli($servername, $username, $password, $dbname);
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }

            $sql = "";
            if ($opcja == "imie")
                $sql = "SELECT id, imie, nazwisko FROM student WHERE imie='$wartosc'";
            else if ($opcja == "imie")
                $sql = "SELECT id, imie, nazwisko FROM student WHERE nazwisko='$wartosc'";
            else
                $sql = "SELECT id, imie, nazwisko FROM student";
            $result = $conn->query($sql);

            if ($result->num_rows > 0) {
                while($row = $result->fetch_assoc()) {
                    echo "id: " . $row["id"]. " - Dane: " . $row["imie"]. " " . $row["nazwisko"]. "<br>";
                }
            } else {
                echo "brak rekordu";
            }
            $conn->close();
        }
    ?>