Guest User

Untitled

a guest
Aug 7th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. mysql_query() expects parameter 1 to be string, resource given
  2. <?php
  3.  
  4. $password=(!isset($_POST['password']));
  5. $username=(!isset($_POST['username']));
  6.  
  7. $username = mysql_real_escape_string($username);
  8. $password = mysql_real_escape_string($password);
  9.  
  10. $query = mysql_query ("SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'");
  11.  
  12. $result = mysql_query($query);
  13.  
  14. var_dump($result);
  15.  
  16. $num_rows = $result->$num_rows;
  17.  
  18. if ($num_rows)
  19. {
  20. echo "username already exist";
  21. }
  22. else
  23. {
  24. $query = "INSERT INTO tb_funcionario (nome_funcionario, username, password) VALUES (
  25. '$_POST[nome_funcionario]',
  26. '$_POST[username]',
  27. '$_POST[password]'
  28. )";;
  29.  
  30. $result = mysql_query($query) or die (mysql_error());
  31.  
  32. }
  33.  
  34.  
  35. mysql_query($query);
  36. mysql_close($bd_con);
  37. ?>
  38.  
  39. $query = mysql_query ("SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'");
  40.  
  41. $result = mysql_query($query);
  42.  
  43. $query = mysql_query ("SELECT * FROM tb_funcionario WHERE
  44. username='$username' and password='$password'");
  45.  
  46. $result = mysql_query($query);
  47.  
  48. $query = "SELECT * FROM tb_funcionario WHERE
  49. username='$username' and password='$password'";
  50.  
  51. $result = mysql_query($query);
  52.  
  53. $query = mysql_query ("SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'");
  54. $result = mysql_query($query);
  55.  
  56. $query = "SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'";
  57. $result = mysql_query($query);
  58.  
  59. $query = mysql_query ("SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'");
  60. $result = mysql_query($query);
  61.  
  62. $query = "SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'");
  63. $result = mysql_query($query);
  64.  
  65. $query = mysql_query ("SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'");
  66.  
  67. $result = mysql_query($query);
  68.  
  69. $sql = "SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'";
  70.  
  71. $result = mysql_query($sql);
  72.  
  73. $result = mysql_query( "SELECT * FROM tb_funcionario WHERE username='$username' and password='$password'"; );
Add Comment
Please, Sign In to add comment