Advertisement
Paarzivall

Untitled

Jan 22nd, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.56 KB | None | 0 0
  1. if(mysqli_num_rows($rezultat)<1){
  2.                 $query = "insert into klienci(Imie, Nazwisko, Email, Data_Urodzenia, Ulica, Miasto, Kod_Pocztowy) values (?, ?, ?, ?, ?, ?, ?)";
  3.                 $statement = $connection->prepare($query);
  4.                 $statement->bind_param("sssssss", $nam, $sec_nam, $email ,$birt, $ulica, $miasto, $kod_p);
  5.                
  6.                 $nam = $connection->real_escape_string($nam);
  7.                 $sec_nam = $connection->real_escape_string($sec_nam);
  8.                 $email = $connection->real_escape_string($email);
  9.                 $birt = $connection->real_escape_string($birt);
  10.                 $ulica = $connection->real_escape_string($ulica);
  11.                 $miasto = $connection->real_escape_string($miasto);
  12.                 $kod_p = $connection->real_escape_string($kod_p);
  13.                 $statement->execute();
  14.                 $statement->close();
  15.             }
  16.  
  17.             $query = "insert into bilety(Typ_Biletu) values (?)";
  18.             $statement = $connection->prepare($query);
  19.             $statement->bind_param("s", $typ);
  20.             $typ = $connection->real_escape_string($typ);
  21.             $statement->execute();
  22.             $statement->close();
  23.  
  24.  
  25.             //łączenie klienta z biletem
  26.             $zapytanie1 = "SELECT ID_Biletu FROM bilety order By ID_Biletu DESC LIMIT 1";
  27.             $rezultat1 = mysqli_query($connection, $zapytanie1);    
  28.             $bufor1 = mysqli_fetch_assoc($rezultat1);
  29.             $bilet = $bufor1["ID_Biletu"];
  30.  
  31.             $zapytanie2 = "SELECT ID_Klienta FROM klienci WHERE Imie=".$nam."AND Nazwisko=".$sec_nam."AND Data_Urodzenia=".$birt."LIMIT 1";
  32.             $rezultat2 = mysqli_query($connection, $zapytanie2);    
  33.             $bufor2 = mysqli_fetch_assoc($rezultat2);
  34.             $klient = $bufor2["ID_Klienta"];
  35.  
  36.             $zapytanie3 = "SELECT ID_seansu FROM seanse WHERE ID_seansu=".$seans;
  37.             $rezultat3 = mysqli_query($connection, $zapytanie3);    
  38.             $bufor3 = mysqli_fetch_assoc($rezultat3);
  39.             $seans = $bufor3["ID_seansu"];
  40.  
  41.  
  42.             $query = "insert into zamowienia(ID_Biletu, ID_Klienta, ID_Seansu) values (?, ?, ?)";
  43.             $statement = $connection->prepare($query);
  44.             $statement->bind_param("sss", $bilet, $klient, $seans);
  45.                
  46.             $bilet = $connection->real_escape_string($bilet);
  47.             $klient = $connection->real_escape_string($klient);
  48.             $seans = $connection->real_escape_string($seans);
  49.             $statement->execute();
  50.             $statement->close();
  51.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement