| @@ 55-65 (lines=11) @@ | ||
| 52 | * | |
| 53 | * @return 0 | 1 | |
| 54 | */ | |
| 55 | public function validateEmailInDb($email) | |
| 56 |     { | |
| 57 | $query = "SELECT login_id FROM login WHERE email = '$email'"; | |
| 58 |         if ($result = $this->connect->query($query)) { | |
| 59 |             if ($result->num_rows > 0) { | |
| 60 | return 1; | |
| 61 | } | |
| 62 | return 0; | |
| 63 | } | |
| 64 | } | |
| 65 | ||
| 66 | /** | |
| 67 | * For checking whether the credentials are empty or not | |
| 68 | * | |
| @@ 73-82 (lines=10) @@ | ||
| 70 | * | |
| 71 | * @return 0 | 1 | |
| 72 | */ | |
| 73 | public function validateUsernameInDb($username) | |
| 74 |     { | |
| 75 | $query = "SELECT login_id FROM login WHERE username = '$username'"; | |
| 76 |         if ($result = $this->connect->query($query)) { | |
| 77 |             if ($result->num_rows > 0) { | |
| 78 | return 1; | |
| 79 | } | |
| 80 | return 0; | |
| 81 | } | |
| 82 | } | |
| 83 | } | |
| 84 | ||