Guest User

Untitled

a guest
Sep 2nd, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. Logging In via AJAX/MySql/PHP
  2. <?php
  3. mysql_connect('localhost', '', '');
  4. mysql_select_db('database');
  5. if(isset($_POST['submit'])){
  6. mysql_query("SELECT username,password FROM table WHERE username='".$_POST['username']."',password='".$_POST['password']."'")
  7. }
  8. ?>
  9.  
  10. <form method="post">
  11. Username <input type="text" name="username" />
  12. Password <input type="password" name="password" />
  13. <input type="submit" name="submit" value="Login" />
  14. </form>
  15.  
  16. <form method="post">
  17. Username <input type="text" id="username" name="username" />
  18. Password <input type="password" id="password" name="password" />
  19. <input type="submit" name="submit" id="submit" value="Login" />
  20. </form>
  21.  
  22. $("#submit").hide();
  23. $.post("checkUsername.php", { username: $("#username").val(), password: $("#password").val() }, function(result) {
  24. if(result == "true") { $("#submit").fadeIn(fast); }
  25.  
  26. });
  27.  
  28. if(mysql_num_rows(mysql_query("SELECT username,password FROM table WHERE username LIKE '". mysql_real_escape_string($_POST['username']) . "',password LIKE '".mysql_real_escape_string($_POST['password'])."'")))
  29. {
  30. echo "true";
  31. }
  32. else
  33. {
  34.  
  35. echo "false";
  36. }
Add Comment
Please, Sign In to add comment