@@ -21,12 +21,12 @@ |
||
| 21 | 21 | trait SqlTrait |
| 22 | 22 | { |
| 23 | 23 | /** |
| 24 | - * Fetch data from filter table. |
|
| 25 | - * |
|
| 26 | - * @param string $ip An IP address. |
|
| 27 | - * |
|
| 28 | - * @return array |
|
| 29 | - */ |
|
| 24 | + * Fetch data from filter table. |
|
| 25 | + * |
|
| 26 | + * @param string $ip An IP address. |
|
| 27 | + * |
|
| 28 | + * @return array |
|
| 29 | + */ |
|
| 30 | 30 | protected function doFetchFromFilterTable(string $ip): array |
| 31 | 31 | { |
| 32 | 32 | $results = []; |
@@ -234,14 +234,14 @@ discard block |
||
| 234 | 234 | protected function update(string $table, array $data, array $where) |
| 235 | 235 | { |
| 236 | 236 | $placeholder = []; |
| 237 | - foreach($data as $k => $v) { |
|
| 237 | + foreach ($data as $k => $v) { |
|
| 238 | 238 | $placeholder[] = "$k = :$k"; |
| 239 | 239 | } |
| 240 | 240 | |
| 241 | 241 | $dataPlaceholder = implode(', ', $placeholder); |
| 242 | 242 | |
| 243 | 243 | $placeholder = []; |
| 244 | - foreach($where as $k => $v) { |
|
| 244 | + foreach ($where as $k => $v) { |
|
| 245 | 245 | $placeholder[] = "$k = :$k"; |
| 246 | 246 | } |
| 247 | 247 | |
@@ -253,7 +253,7 @@ discard block |
||
| 253 | 253 | |
| 254 | 254 | $bind = array_merge($data, $where); |
| 255 | 255 | |
| 256 | - foreach($bind as $k => $v) { |
|
| 256 | + foreach ($bind as $k => $v) { |
|
| 257 | 257 | |
| 258 | 258 | // @codeCoverageIgnoreStart |
| 259 | 259 | |
@@ -281,7 +281,7 @@ discard block |
||
| 281 | 281 | |
| 282 | 282 | // @codeCoverageIgnoreStart |
| 283 | 283 | |
| 284 | - } catch(Exception $e) { |
|
| 284 | + } catch (Exception $e) { |
|
| 285 | 285 | throw $e->getMessage(); |
| 286 | 286 | } |
| 287 | 287 | |
@@ -301,7 +301,7 @@ discard block |
||
| 301 | 301 | { |
| 302 | 302 | $placeholderField = []; |
| 303 | 303 | $placeholderValue = []; |
| 304 | - foreach($data as $k => $v) { |
|
| 304 | + foreach ($data as $k => $v) { |
|
| 305 | 305 | $placeholderField[] = "`$k`"; |
| 306 | 306 | $placeholderValue[] = ":$k"; |
| 307 | 307 | } |
@@ -313,7 +313,7 @@ discard block |
||
| 313 | 313 | $sql = 'INSERT INTO ' . $table . ' (' . $dataPlaceholderField . ') VALUES (' . $dataPlaceholderValue . ')'; |
| 314 | 314 | $query = $this->db->prepare($sql); |
| 315 | 315 | |
| 316 | - foreach($data as $k => $v) { |
|
| 316 | + foreach ($data as $k => $v) { |
|
| 317 | 317 | |
| 318 | 318 | // @codeCoverageIgnoreStart |
| 319 | 319 | |
@@ -341,7 +341,7 @@ discard block |
||
| 341 | 341 | |
| 342 | 342 | // @codeCoverageIgnoreStart |
| 343 | 343 | |
| 344 | - } catch(Exception $e) { |
|
| 344 | + } catch (Exception $e) { |
|
| 345 | 345 | return false; |
| 346 | 346 | } |
| 347 | 347 | |
@@ -360,7 +360,7 @@ discard block |
||
| 360 | 360 | { |
| 361 | 361 | |
| 362 | 362 | $placeholder = []; |
| 363 | - foreach($where as $k => $v) { |
|
| 363 | + foreach ($where as $k => $v) { |
|
| 364 | 364 | $placeholder[] = "`$k` = :$k"; |
| 365 | 365 | } |
| 366 | 366 | |
@@ -371,7 +371,7 @@ discard block |
||
| 371 | 371 | $sql = 'DELETE FROM ' . $table . ' WHERE ' . $dataPlaceholder; |
| 372 | 372 | $query = $this->db->prepare($sql); |
| 373 | 373 | |
| 374 | - foreach($where as $k => $v) { |
|
| 374 | + foreach ($where as $k => $v) { |
|
| 375 | 375 | |
| 376 | 376 | // @codeCoverageIgnoreStart |
| 377 | 377 | |
@@ -394,7 +394,7 @@ discard block |
||
| 394 | 394 | |
| 395 | 395 | // @codeCoverageIgnoreStart |
| 396 | 396 | |
| 397 | - } catch(Exception $e) { |
|
| 397 | + } catch (Exception $e) { |
|
| 398 | 398 | return false; |
| 399 | 399 | } |
| 400 | 400 | |