mmainstreet /
jodel-web
| @@ 160-183 (lines=24) @@ | ||
| 157 | return $access_token; |
|
| 158 | } |
|
| 159 | ||
| 160 | function getLocationByAccessToken($accessToken) |
|
| 161 | { |
|
| 162 | $db = new DatabaseConnect(); |
|
| 163 | $result = $db->query("SELECT * FROM accounts WHERE access_token='" . $accessToken . "'"); |
|
| 164 | ||
| 165 | $location = new Location(); |
|
| 166 | ||
| 167 | if ($result->num_rows > 0) |
|
| 168 | { |
|
| 169 | // output data of each row |
|
| 170 | while($row = $result->fetch_assoc()) |
|
| 171 | { |
|
| 172 | $location->setLat($row['lat']); |
|
| 173 | $location->setLng($row['lng']); |
|
| 174 | $location->setCityName($row['name']); |
|
| 175 | } |
|
| 176 | } |
|
| 177 | else |
|
| 178 | { |
|
| 179 | echo "Error: 0 results"; |
|
| 180 | } |
|
| 181 | ||
| 182 | return $location; |
|
| 183 | } |
|
| 184 | ||
| 185 | function getLocationByDeviceUid($deviceUid) |
|
| 186 | { |
|
| @@ 185-208 (lines=24) @@ | ||
| 182 | return $location; |
|
| 183 | } |
|
| 184 | ||
| 185 | function getLocationByDeviceUid($deviceUid) |
|
| 186 | { |
|
| 187 | $db = new DatabaseConnect(); |
|
| 188 | $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'"); |
|
| 189 | ||
| 190 | $location = new Location(); |
|
| 191 | ||
| 192 | if ($result->num_rows > 0) |
|
| 193 | { |
|
| 194 | // output data of each row |
|
| 195 | while($row = $result->fetch_assoc()) |
|
| 196 | { |
|
| 197 | $location->setLat($row['lat']); |
|
| 198 | $location->setLng($row['lng']); |
|
| 199 | $location->setCityName($row['name']); |
|
| 200 | } |
|
| 201 | } |
|
| 202 | else |
|
| 203 | { |
|
| 204 | echo "Error: 0 results"; |
|
| 205 | } |
|
| 206 | ||
| 207 | return $location; |
|
| 208 | } |
|
| 209 | ||
| 210 | function getAccessTokenByDeviceUid($deviceUid) |
|
| 211 | { |
|
