Advertisement
taufikherjanto

Based Email or Username

Mar 3rd, 2015
248
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.76 KB | None | 0 0
  1. if(isset($_POST['process']) && ($_POST['username'] !='') & ($_POST['password']!='')){
  2.  
  3.         $username = cleaninput ($_POST['username']);
  4.         $password = cleaninput(md5($_POST['password']));
  5.         $check_email = Is_email($username);
  6.        
  7.     $query = $connect->prepare("SELECT * FROM users WHERE username = ? AND password = ?");
  8.        
  9.     if($check_email){
  10.                         $query = $connect->prepare("SELECT * FROM users WHERE email = ? AND password = ?");
  11.     }
  12.  
  13.         $query->bind_param('ss', $username, $password);
  14.  
  15.         $query->execute();
  16.         $query->bind_result($id_user, $username, $password, $nama_depan, $nama_belakang, $alamat, $email, $idlevel, $no_kontak, $jenis_kelamin, $foto);
  17.         $query->store_result();
  18.         $nums = $query->num_rows;
  19.         $query->fetch();
  20.  
  21.         if($nums > 0){
  22.                
  23.                 $_SESSION['id_user'] = $id_user;
  24.                 $_SESSION['username'] =$username;
  25.                 $_SESSION['nama_depan'] = $nama_depan;
  26.                 $_SESSION['nama_belakang'] = $nama_belakang;
  27.                 $_SESSION['email'] = $email;
  28.                 $_SESSION['idlevel'] = $idlevel;
  29.  
  30.                         switch($_SESSION['idlevel']){
  31.                         case 1 :
  32.                         header('location:admin/index.php');
  33.                         break;
  34.                         case 2 :
  35.                         header('location:staff/index.php');
  36.                         break;
  37.                         case 3 :
  38.                         header('location:marketing/index.php');
  39.                         break;
  40.                         }
  41.         }else{
  42.                 header('location:index.php');
  43.         }              
  44.  
  45. } else{
  46.                 header('location:index.php');
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement