Guest User

Untitled

a guest
Aug 5th, 2018
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. <?php
  2. $username = $_POST['username'];
  3. $password = $_POST['password'];
  4.  
  5. //Database Vars
  6. $host = "localhost";
  7. $database = "ajax-login";
  8. $username = "root";
  9. $password = "root";
  10.  
  11.  
  12. $db = new PDO("mysql:host=$host;dbname=$database", $username, $password);
  13.  
  14. $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15.  
  16. //Statement
  17. $stmt = $db->prepare("SELECT * FROM users WHERE username = :username AND password = :password");
  18. $stmt->bindParam(':username', $username, PDO::PARAM_STR);
  19. $stmt->bindParam(':password', $password, PDO::PARAM_STR);
  20.  
  21. //Query
  22. $stmt->execute();
  23.  
  24. //Get results
  25. if($data = $stmt->fetch()) {
  26. echo "worked";
  27. } else {
  28. echo"meh :/";
  29. }
  30. //Encode in JSON
  31. /* json_encode($data); */
  32.  
  33. ?>
Add Comment
Please, Sign In to add comment