| @@ 49-62 (lines=14) @@ | ||
| 46 | * |
|
| 47 | * @return void |
|
| 48 | */ |
|
| 49 | public static function setOnlineStatus($userId) |
|
| 50 | { |
|
| 51 | $connect = new mysqli( |
|
| 52 | getenv('DB_HOST'), |
|
| 53 | getenv('DB_USER'), |
|
| 54 | getenv('DB_PASSWORD'), |
|
| 55 | getenv('DB_NAME') |
|
| 56 | ); |
|
| 57 | $query = "Update login set login_status = 1 where login_id = '$userId'"; |
|
| 58 | if (!$connect->query($query)) { |
|
| 59 | echo $connect->error; |
|
| 60 | } |
|
| 61 | $connect->close(); |
|
| 62 | } |
|
| 63 | ||
| 64 | /** |
|
| 65 | * Remove Online Status |
|
| @@ 71-84 (lines=14) @@ | ||
| 68 | * |
|
| 69 | * @return void |
|
| 70 | */ |
|
| 71 | public static function removeOnlineStatus($userId) |
|
| 72 | { |
|
| 73 | $connect = new mysqli( |
|
| 74 | getenv('DB_HOST'), |
|
| 75 | getenv('DB_USER'), |
|
| 76 | getenv('DB_PASSWORD'), |
|
| 77 | getenv('DB_NAME') |
|
| 78 | ); |
|
| 79 | $query = "Update login set login_status = 0 where login_id = '$userId'"; |
|
| 80 | if (!$connect->query($query)) { |
|
| 81 | echo $connect->error; |
|
| 82 | } |
|
| 83 | $connect->close(); |
|
| 84 | } |
|
| 85 | } |
|
| 86 | ||