if(isset($_POST["name"])){
            $nam = $_POST["name"];
            $sec_nam = $_POST["sec_name"];
            $email = $_POST["email"];
            $birt = $_POST["birth"];
            $ulica = $_POST["ul"];
            $miasto = $_POST["city"];
            $kod_p = $_POST["kod"];

            $seans  = $_POST["seans"];
            $typ = $_POST["typ"];

            $zap = "SELECT Imie, Nazwisko, Data_Urodzenia FROM klienci WHERE Imie=".$nam."AND Nazwisko=".$sec_nam."AND Data_Urodzenia=".$birt. "Limit 1";
            $rez = mysqli_query($connection, $zap);
            $bufor = mysqli_fetch_assoc($rez);


            if(empty($bufor["Imie"])&&empty($bufor["Nazwisko"]=='')&&empty($bufor["Data_Urodzenia"]=='')){
                $query = "insert into klienci(Imie, Nazwisko, Email, Data_Urodzenia, Ulica, Miasto, Kod_Pocztowy) values (?, ?, ?, ?, ?, ?, ?)";
                $statement = $connection->prepare($query);
                $statement->bind_param("sssssss", $nam, $sec_nam, $email ,$birt, $ulica, $miasto, $kod_p);

                $nam = $connection->real_escape_string($nam);
                $sec_nam = $connection->real_escape_string($sec_nam);
                $email = $connection->real_escape_string($email);
                $birt = $connection->real_escape_string($birt);
                $ulica = $connection->real_escape_string($ulica);
                $miasto = $connection->real_escape_string($miasto);
                $kod_p = $connection->real_escape_string($kod_p);
                $statement->execute();
                $statement->close();
            }

            $query = "insert into bilety(Typ_Biletu) values (?)";
            $statement = $connection->prepare($query);
            $statement->bind_param("s", $typ);
            $typ = $connection->real_escape_string($typ);
            $statement->execute();
            $statement->close();


            //łączenie klienta z biletem
            $zapytanie1 = "SELECT ID_Biletu FROM bilety order By ID_Biletu DESC LIMIT 1";
            $rezultat1 = mysqli_query($connection, $zapytanie1);
            $bufor1 = mysqli_fetch_assoc($rezultat1);
            $bilet = $bufor1["ID_Biletu"];

            $zapytanie2 = "SELECT ID_Klienta FROM klienci WHERE Imie=".$nam."AND Nazwisko=".$sec_nam."AND Data_Urodzenia=".$birt."LIMIT 1";
            $rezultat2 = mysqli_query($connection, $zapytanie2);
            $bufor2 = mysqli_fetch_assoc($rezultat2);
            $klient = $bufor2["ID_Klienta"];

            $zapytanie3 = "SELECT ID_seansu FROM seanse WHERE ID_seansu=".$seans;
            $rezultat3 = mysqli_query($connection, $zapytanie3);
            $bufor3 = mysqli_fetch_assoc($rezultat3);
            $seans = $bufor3["ID_seansu"];


            $query = "insert into zamowienia(ID_Biletu, ID_Klienta, ID_Seansu) values (?, ?, ?)";
            $statement = $connection->prepare($query);
            $statement->bind_param("sss", $bilet, $klient, $seans);

            $bilet = $connection->real_escape_string($bilet);
            $klient = $connection->real_escape_string($klient);
            $seans = $connection->real_escape_string($seans);
            $statement->execute();
            $statement->close();

            //header("Location: podsumowanie.php");
        }