Advertisement
Guest User

Untitled

a guest
Mar 4th, 2019
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. mysql_num_rows() expects parameter 1 to be resource, boolean given in
  2.  
  3. if ($_POST['submit'])
  4. {
  5.  
  6. $username = $_POST['id'];
  7. $password = $_POST['pass'];
  8. //connect to the database here
  9. $username = mysql_real_escape_string($username);
  10. $query = "SELECT hashpass, salt
  11. FROM users
  12. WHERE username = '$username'";
  13. $result = mysql_query($query);
  14. if(mysql_num_rows($result) < 1) //no such user exists
  15. {
  16. echo "NO USER!";
  17. }
  18. $userData = mysql_fetch_array($result, MYSQL_ASSOC);
  19. $hash = sha1 ( $userData['salt'] . $password );
  20. if($hash != $userData['password']) //incorrect password
  21. {
  22. echo "WRONG PASS";
  23. }
  24. }
  25.  
  26. $result = mysql_query($query);
  27.  
  28. if ($result)
  29. {
  30. if(mysql_num_rows($result) == 1)
  31. {
  32. // user exists... check password
  33. }
  34. else
  35. {
  36. //no such user exists
  37. echo "NO USER!";
  38. }
  39. }
  40. else
  41. {
  42. // Query failed - no such user
  43. }
  44.  
  45. int mysql_num_rows ( resource $result )
  46.  
  47. <?php
  48.  
  49. $link = mysql_connect("localhost", "mysql_user", "mysql_password");
  50.  
  51. $query = "SELECT hashpass, salt
  52. FROM users
  53. WHERE username = '$username'";
  54.  
  55. $result = mysql_query($query);
  56.  
  57. mysql_select_db("database", $link);
  58.  
  59. $result = mysql_query($query, $link);
  60. $num_rows = mysql_num_rows($result);
  61.  
  62. if($num_rows < 1) //no such user exists
  63. {
  64. echo "NO USER!";
  65. }
  66.  
  67. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement