Advertisement
Guest User

error

a guest
Nov 27th, 2018
2,028
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. //cek apakah nama sudah tersedia di dalam database atau belum
  2.     $query = "SELECT * FROM data WHERE nama='$nama' OR email='$nama' LIMIT 1";
  3.     $result = mysqli_query($conn, $query);
  4.     $user = mysqli_fetch_assoc($result);
  5.    
  6.     if($user['nama'] === $nama) {
  7.  
  8.         echo "<script> alert('Nama Sudah Digunakan'); </script>";
  9.     }
  10.  
  11.     else{
  12.  
  13.         echo "<script> alert('Nama Bisa Digunakan'); </script>";
  14.     }
  15.    
  16.     if ($user['email'] === $email) {
  17.        
  18.         echo "<script> alert('Email Sudah Digunakan'); </script>";
  19.     }
  20.  
  21.     else{
  22.  
  23.         echo "<script> alert('Email Bisa Digunakan'); </script>";
  24.     }
  25.  
  26.    
  27.     //check lagi apakah ada username yg sama dalam database
  28.     if($user['nama'] === $nama  || empty($user['email']) === $email) {
  29.  
  30.     }
  31.    
  32.     else {
  33.  
  34.         //password enkripsi
  35.         $password = password_hash($password, PASSWORD_ARGON2I);
  36.         $cpassword =password_hash($cpassword, PASSWORD_ARGON2I);
  37.  
  38.         $query = "INSERT INTO data(nama, email, password, cpassword) VALUES('$nama','$email','$password','$cpassword')";
  39.  
  40.         $result = mysqli_query($conn, $query);
  41.  
  42.         return mysqli_affected_rows($conn);
  43.  
  44.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement