Guest User

Untitled

a guest
Dec 3rd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. <?php
  2. $connection = mysqli_connect("localhost", "SENSORED", "SENSORED", "SENSORED");
  3.  
  4.  
  5.  
  6. $username = $_POST["username"];
  7. $password = $_POST["password"];
  8.  
  9.  
  10. $statement = mysqli_prepare($connection, "SELECT * FROM user WHERE username = ? AND password = ?");
  11. var_dump(mysqli_error($connection));
  12. mysqli_stmt_bind_param($statement, "ss", $username, $password);
  13. var_dump(mysqli_error($connection));
  14. mysqli_stmt_execute($statement);
  15. var_dump(mysqli_error($connection));
  16.  
  17. mysqli_stmt_store_result($statement);
  18. var_dump(mysqli_error($connection));
  19. mysqli_stmt_bind_result($statement, $user_id, $name, $username, $email, $company_id, $phone, $password, $leaveTime, $sickTime, $rateOfPay);
  20. var_dump(mysqli_error($connection));
  21.  
  22. $response = array();
  23. $response["success"] = false;
  24.  
  25. while(mysqli_stmt_fetch($statement)){
  26. var_dump(mysqli_error($connection));
  27. $response["success"] = true;
  28. $response["user_id"] = $user_id;
  29. $response["name"] = $name;
  30. $response["username"] = $username;
  31. $response["email"] = $email;
  32. $response["company_id"] = $company_id;
  33. $response["phone"] = $phone;
  34. $response["password"] = $password;
  35. $response["leaveTime"] = $leaveTime;
  36. $response["sickTime"] = $sickTime;
  37. $response["rateOfPay"] = $rateOfPay;
  38. }
  39.  
  40. echo json_encode($response);
  41. ?>
Add Comment
Please, Sign In to add comment