SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include 'koneksi.php'; | |
| 3 | $username = $_POST['username']; | |
| 4 | $password = $_POST['password']; | |
| 5 | $sql="SELECT * FROM user WHERE username='$username' AND password='$password'"; | |
| 6 | - | $login=mysql_query("SELECT * FROM user WHERE username='$username' AND password='$password'");
|
| 6 | + | $login=mysql_query($sql); |
| 7 | if(!$login){
| |
| 8 | die( mysql_error()."<br/>$sql"); //error krn salah ada disini | |
| 9 | } | |
| 10 | ||
| 11 | $ketemu=mysql_num_rows($login); | |
| 12 | $r=mysql_fetch_array($login); | |
| 13 | ||
| 14 | if($ketemu > 0) {
| |
| 15 | session_start(); | |
| 16 | $_SESSION['namauser'] = $r['username']; | |
| 17 | $_SESSION['passuser'] = $r['password']; | |
| 18 | $_SESSION['leveluser'] = $r['level']; | |
| 19 | if ($r[level]===1){
| |
| 20 | $_SESSION['admin']=$username; | |
| 21 | echo '<script language="javascript">alert("Anda berhasil Login Admin!"); document.location="admin.php";</script>';
| |
| 22 | } | |
| 23 | else {
| |
| 24 | $_SESSION['member']=$username; | |
| 25 | echo '<script language="javascript">alert("Anda berhasil Login member!"); document.location="member.php";</script>';
| |
| 26 | ||
| 27 | ||
| 28 | ||
| 29 | header('location:member.php');
| |
| 30 | ||
| 31 | } | |
| 32 | } | |
| 33 | else {
| |
| 34 | ||
| 35 | echo "<center>LOGIN GAGAL <br> | |
| 36 | ||
| 37 | Username atau Password Anda Tidak benar <br> | |
| 38 | ||
| 39 | Atau Acount Anda Sedang Di blokir <br>"; | |
| 40 | ||
| 41 | - | ?> |
| 41 | + | |
| 42 | ||
| 43 | } |