Guest User

Untitled

a guest
Dec 21st, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.12 KB | None | 0 0
  1. <?php
  2.  
  3. if (isset($_POST["submit"])){
  4. echo '<pre>Before Connect' . print_r($_POST, true) . '</pre>'; // display the $_POST array
  5. include_once "dbh_inc.php";
  6. $first = mysqli_real_escape_string($conn, $_POST["first"]);
  7. $last = mysqli_real_escape_string($conn, $_POST["last"]);
  8. $nickname = mysqli_real_escape_string($conn, $_POST["nickname"]);
  9. $password = mysqli_real_escape_string($conn, $_POST["password"]);
  10. $email = mysqli_real_escape_string($conn, $_POST["email"]);
  11.  
  12. //Birthdate
  13. $birthDay = mysqli_real_escape_string($conn, $_POST["birth-day"]);
  14. $birthMonth = mysqli_real_escape_string($conn, $_POST["birth-month"]);
  15. $birthAge = mysqli_real_escape_string($conn, $_POST["birth-age"]);
  16. $birthDate = $birthDay."-".$birthMonth."-".$birthAge;
  17.  
  18. $speciality = mysqli_real_escape_string($conn, $_POST["speciality"]);
  19. $gender = mysqli_real_escape_string($conn, $_POST["gender"]);
  20.  
  21. //Error handlers
  22. //Check for empty fields
  23.  
  24. if (empty($first) || empty($last) || empty($email) || empty($last) || empty($last) || empty($last)) {
  25. header("Location: ../register.php?register=empty");
  26. exit();
  27. }else{
  28. //Check if input characters are valid
  29. if(!preg_match("/^[a-zA-Z]*$/", $first) || !preg_match("/^[a-zA-Z]*$/", $last)){
  30. header("Location: ../register.php?register=invalid");
  31. exit();
  32. }else{
  33. //Check if email is valid
  34. if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
  35. header("Location: ../register.php?register=email");
  36. exit();
  37. }else{
  38. //Check if birthdate is valid
  39. if (!checkdate ($birthMonth , $birthDay, $birthAge)) {
  40. header("Location: ../register.php?register=date");
  41. exit();
  42. }else{
  43. //Check if user exists
  44. $sql = "SELECT * FROM users WHERE user_nickname='$nickname'";
  45. $result = mysqli_query($conn, $sql);
  46. $resultCheck = mysqli_num_rows($result);
  47. //Entering to the database to check if username exists
  48. if ($resultCheck > 0) {
  49. header("Location: ../register.php?register=usertaked");
  50. exit();
  51. }else{
  52. //Hashing the password
  53. $hashedPwd = password_hash($password, PASSWORD_DEFAULT);
  54. //Insert user registration data into the database
  55. echo "Successful insertion!!!";
  56. $sql = "INSERT INTO users (user_first, user_last, user_nickname, user_password, user_email, user_birth_date, user_speciality, user_gender) VALUES ('$first', '$last', '$nickname', '$password', '$email', '$birthDate', '$speciality', '$gender')";
  57. mysqli_query($conn, $sql);
  58. header("Location: ../register.php?register=success");
  59. exit();
  60. }
  61. }
  62. }
  63. }
  64. }
  65. }else{
  66. header("Location: ../register.php");
  67. exit();
  68. }
  69.  
  70. <?php
  71.  
  72. $dbServername = "localhost";//because there's running a local server
  73. $dbUsername = "root";
  74. $dbPassword = "";
  75. $dbName = "login_system";
  76.  
  77. $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName) or die ("Conexion fallida");
Add Comment
Please, Sign In to add comment