Guest User

Untitled

a guest
Jan 14th, 2019
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  2. <?php
  3. include ("config/koneksi.php");
  4. include ("config/library.php");
  5. $pass = md5($_POST['password']);
  6.  
  7. $login = mysql_query("SELECT * FROM user WHERE id_user='$_POST[username]' AND sesi='$pass'");
  8. $found = mysql_num_rows($login); //error
  9. $r = mysql_fetch_array($login); //error
  10.  
  11. if ($r){
  12. session_start();
  13. session_register("username");
  14. session_register("sesi");
  15. session_register("role");
  16.  
  17. $_SESSION[username] = $r[id_user];
  18. $_SESSION[sesi] = $r[sesi];
  19. $_SESSION[role]= $r[role];
  20. header ('location:home.php');
  21. }
  22.  
  23. $_POST["username"];
  24.  
  25. $login = mysql_query("SELECT * FROM user WHERE id_user='{$_POST["username"]}' AND sesi='$pass'");
  26.  
  27. if($login && (mysql_num_rows($login)==1)){
  28. $found = mysql_num_rows($login); //error
  29. $r = mysql_fetch_array($login);
  30.  
  31. }
  32.  
  33. $login = mysql_query("SELECT * FROM user WHERE id_user='$_POST[username]' AND
  34. sesi='$pass'") or die(mysql_error());
  35.  
  36. $login=$pdo->prepare("SELECT * FROM user WHERE id_user=:username AND
  37. sesi=:pass")
  38.  
  39. $login->execute(array(":username"=>$_POST["username"],":pass"=>$pass))
Add Comment
Please, Sign In to add comment