login.php 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  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. if ($row["IsAdmin"]==1) {
  24. // Declare an array
  25. $value = array(
  26. "UserID"=>(int)$row["UserID"],
  27. "UserName"=>$row["UserName"],
  28. "PhoneNumber"=>$row["PhoneNumber"],
  29. "IsAdmin"=>(int)$row["IsAdmin"],
  30. "UserCreatedAt"=>$row["UserCreatedAt"],
  31. "UserUpdatedAt"=>$row["UserUpdatedAt"],
  32. "Message"=>"Your login successful"
  33. );
  34. }else {
  35. http_response_code(404);
  36. $value = array(
  37. "Message"=>"Your login failed, You are not a admin to access",
  38. "Error"=>"You are not a admin"
  39. );
  40. }
  41. $listArray[]= $value;
  42. }
  43. $count = count($listArray);
  44. if($count==1){
  45. // Use json_encode() function
  46. $json = json_encode($listArray[0]);
  47. }else {
  48. // Use json_encode() function
  49. $json = json_encode($listArray);
  50. }
  51. } else {
  52. http_response_code(404);
  53. $errorMesage= $conn->error;
  54. if ($errorMesage=="") {
  55. $errorMesage = "User name or password incorrect";
  56. }
  57. // Declare an array with error message
  58. $value = array(
  59. "Message"=>"Your login failed",
  60. "Error"=>$errorMesage
  61. );
  62. // Use json_encode() function
  63. $json = json_encode($value);
  64. }
  65. // Display the output
  66. echo($json);
  67. $conn->close();