Guest User

Untitled

a guest
Nov 29th, 2016
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1.  
  2. $db_host = 'localhost';
  3. $db_user = 'root';
  4. $db_pass = '';
  5. $db_name = 'szkola';
  6.  
  7. $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name)
  8. or die("Failed to connect");
  9.  
  10. $login = mysqli_real_escape_string($conn, $_POST['login']);
  11. $passWord = mysqli_real_escape_string($conn, $_POST['password']);
  12. $firstName = mysqli_real_escape_string($conn, $_POST['firstName']);
  13. $lastName = mysqli_real_escape_string($conn, $_POST['lastName']);
  14.  
  15. $firstQuerry = "INSERT INTO `uczen` (`uczen_id`, `imie`, `nazwisko`) VALUES (NULL, '$firstName', '$lastName');";
  16. $getId = mysqli_query($conn, "SELECT * FROM uczen WHERE imie='$firstName' AND nazwisko='$lastName'")
  17. or die("Failed to querry database " . mysqli_error($conn));
  18. $rows = mysqli_fetch_array($getId);
  19. $id = $rows['uczen_id'];
  20. $id = intval($id);
  21. print $id;
  22. $secondQuerry = "INSERT INTO `rejestracja` (`uczen_id`, `login`, `haslo`) VALUES ('$id', '$login', '$passWord');";
  23. if(!mysqli_query($conn, $firstQuerry)){
  24. echo "Error " .mysqli_error($conn);
  25. }else{
  26. if(!mysqli_query($conn, $secondQuerry)){
  27. echo "Error " .mysqli_error($conn);
  28. }else{
  29. header("Location: rejestracja.php?msg=1");
  30. }
  31. }
Add Comment
Please, Sign In to add comment