login.php 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. include_once "../include/DB.php";
  3. $userPhoneNumber="";
  4. $userPassword="";
  5. if (isset($_POST["phonenumber"]) && !empty($_POST["phonenumber"])) {
  6. $userPhoneNumber=$_POST["phonenumber"];
  7. }
  8. if (isset($_POST["password"]) && !empty($_POST["password"])) {
  9. $userPassword=$_POST["password"];
  10. }
  11. $sql = "SELECT UserID,
  12. UserName,
  13. PhoneNumber,
  14. IsAdmin,
  15. CreatedAt AS UserCreatedAt,
  16. UpdatedAt AS UserUpdatedAt
  17. FROM user WHERE PhoneNumber='$userPhoneNumber' AND Password='$userPassword'";
  18. $result = $conn->query($sql);
  19. if ($result!== false && $result->num_rows > 0) {
  20. $listArray = [];
  21. // output data of each row
  22. while($row = $result->fetch_assoc()) {
  23. // Declare an array
  24. $value = array(
  25. "UserID"=>(int)$row["UserID"],
  26. "UserName"=>$row["UserName"],
  27. "PhoneNumber"=>$row["PhoneNumber"],
  28. "IsAdmin"=>(int)$row["IsAdmin"],
  29. "UserCreatedAt"=>$row["UserCreatedAt"],
  30. "UserUpdatedAt"=>$row["UserUpdatedAt"],
  31. "Message"=>"Your login successful"
  32. );
  33. $listArray[]= $value;
  34. }
  35. $count = count($listArray);
  36. if($count==1){
  37. // Use json_encode() function
  38. $json = json_encode($listArray[0]);
  39. }else {
  40. // Use json_encode() function
  41. $json = json_encode($listArray);
  42. }
  43. // Display the output
  44. echo($json);
  45. } else {
  46. http_response_code(404);
  47. $errorMesage= $conn->error;
  48. if ($errorMesage=="") {
  49. $errorMesage = "User name or password incorrect";
  50. }
  51. // Declare an array with error message
  52. $value = array(
  53. "Message"=>"Your login failed",
  54. "Error"=>$errorMesage
  55. );
  56. // Use json_encode() function
  57. $json = json_encode($value);
  58. // Display the output
  59. echo($json);
  60. }
  61. $conn->close();