Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(mysqli_num_rows($rezultat)<1){
- $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();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement