Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.40 KB | None | 0 0
  1. //UserRegistration.php
  2. <?php
  3. if($_SERVER['REQUEST_METHOD']=='POST'){
  4. //DatabaseConfig это подключение к БД
  5. include 'DatabaseConfig.php';
  6.  
  7.  $con = mysqli_connect($HostName,$HostUser,$HostPass,$DatabaseName);
  8.  
  9.  $F_name = $_POST['f_name'];
  10.  $L_name = $_POST['L_name'];
  11.  $email = $_POST['email'];
  12.  $password = $_POST['password'];
  13.  
  14.  $CheckSQL = "SELECT * FROM users WHERE user_email='$email'";
  15.  
  16.  $check = mysqli_fetch_array(mysqli_query($con,$CheckSQL));
  17.  
  18.  if(isset($check)){
  19.  
  20.  echo 'Email Already Exist';
  21.  
  22.  }
  23. else{
  24. $Sql_Query = "INSERT INTO users (first_name,last_name,user_email,user_pass) values ('$F_name','$L_name','$email','$password')";
  25.  
  26.  if(mysqli_query($con,$Sql_Query))
  27. {
  28.  echo 'Registration Successfully';
  29. }
  30. else
  31. {
  32.  echo 'Something went wrong';
  33.  }
  34.  }
  35. }
  36.  mysqli_close($con);
  37. ?>
  38.  
  39. //UserLogin.php
  40.  
  41. <?php
  42.  
  43.  if($_SERVER['REQUEST_METHOD']=='POST'){
  44.  
  45.  include 'DatabaseConfig.php';
  46.  
  47.  $con = mysqli_connect($HostName,$HostUser,$HostPass,$DatabaseName);
  48.  
  49.  $email = $_POST['email'];
  50.  $password = $_POST['password'];
  51.  
  52.  $Sql_Query = "select * from user where user_email = '$email' and user_pass = '$password' ";
  53.  
  54.  $check = mysqli_fetch_array(mysqli_query($con,$Sql_Query));
  55.  
  56.  if(isset($check)){
  57.  
  58.  echo "Data Matched";
  59.  }
  60.  else{
  61.  echo "Invalid Username or Password Please Try Again";
  62.  }
  63.  
  64.  }else{
  65.  echo "Check Again";
  66.  }
  67. mysqli_close($con);
  68.  
  69. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement