Advertisement
Guest User

Untitled

a guest
Sep 17th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2.  
  3. $error = false;
  4.  
  5. if ($_POST['systemCall'] == "checkLogin"){
  6. /** Connect to database **/
  7. $con = new mysqli('host', 'user', 'pass', 'database name');
  8.  
  9. /** Check Database Connection **/
  10. if (mysqli_connect_errno()) {
  11. echo 'status=Failure&error=505&errmsg=Cannot Connect to DB.';
  12. exit();
  13. }
  14.  
  15. $user = $_POST['username']; // Username
  16. $pass = $_POST['password']; // Password
  17.  
  18. $query = 'SELECT password FROM users WHERE username=? AND password=? LIMIT 1'; //Statement
  19. if ($stmt = $con->prepare($query)) { //Prepare Statement
  20. $stmt->bind_param("ss", $user, $pass); //Bind Parameters
  21. $stmt->execute(); //Execute Statement
  22. $stmt->bind_result($password); //Bind Results
  23. if($stmt->fetch()) {
  24. echo "status=Success";
  25. } else {
  26. echo 'status=Failure&error=504&errmsg=Account Info is Incorrect.';
  27. }
  28. }
  29. }
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement